Skip to content
≡

Administrator

Developer

Tools

External Tools

About This Manual#

This manual explains the concepts, components, and basic use of Altibase.

Audience#

This manual has been prepared for the following Altibase users:

  • Database managers
  • Performance managers
  • Database users
  • Application developers
  • Technical support engineers

It is recommended for those reading this manual possess the following background knowledge:

  • Basic knowledge in the use of computers, operating systems, and operating system utilities
  • Experience in using relational databases and understanding of database concepts
  • Computer programming experience
  • Experience in database server management, operating system management, or network administration


Organization#

This manual has been organized as follows:

  • Chapter 1: Introduction

    This chapter provides an overview of Altibase replication

  • Chapter 2: Managing Replication

    This chapter explains how to manage Altibase replication.

  • Chapter 3: Deploying Replication

    This chapter explains how to deploy Altibase replication.

  • Chapter 4: Executing DDL Statements in a Replication Environment

    This chapter explains how to execute DDL statements in a replication environment.

  • Chapter 5: DDL Synchronization

    This chapter describes the DDL Synchronization feature.

  • Chapter 6: Fail-Over

    This chapter explains the Fail-Over feature provided by Altibase and how to use it.

  • Chapter 7: Sequence Replication

    This chapter describes how to use the sequence replication that Altibase provides.

  • Chapter 8: ROLE

    This chapter explains how to configure the system to perform special functions by assigning ROLE to replication.

  • Appendix A. FAQ

    This chapter provides FAQs related to Altibase replication and replication properties.

  • Appendix B. Executing DDL Statements for Replication Targets

    This appendix explains how to execute DDL statements on replication targets without changing property settings.

  • Appendix C. SQL Apply Mode

    This appendix describes the SQL Apply mode used in various replication operations.


Documentation Conventions#

This section describes the conventions used in this manual. Understanding these conventions will make it easier to find information in this manual and other manuals in the series.

There are two sets of conventions:

  • Syntax diagrams
  • Sample code conventions

Syntax diagrams#

This manual describes command syntax using diagrams composed of the following elements:

Elements Meaning
Indicates the start of a command.
If a syntactic element starts with an arrow, it is not a complete command.
Indicates that the command continues to the next line.
If a syntactic element ends with this symbol, it is not a complete command.
Indicates that the command continues from the previous line.
If a syntactic element starts with this symbol, it is not a complete command.
Indicates the end of a statement.
Indicates a mandatory element.
Indicates an optional element.
Indicates a mandatory element comprised of options.
One, and only one, option must be specified.
Indicates an optional element comprised of options
Indicates an optional element in which multiple elements may be specified.
A comma must precede all but the first element.

Sample Code Conventions#

The code examples explain SQL, stored procedures, iSQL, and other command line syntax.

The following describes the conventions used in the code examples:

Rules Meaning Example
[ ] Indicates an optional item VARCHAR [(size)] [[FIXED |] VARIABLE]
{ } Indicates a mandatory field for which one or more items must be selected. { ENABLE | DISABLE | COMPILE }
| A delimiter between optional or mandatory arguments. { ENABLE | DISABLE | COMPILE }
[ ENABLE | DISABLE | COMPILE ]
. . . Indicates that the previous argument is repeated, or that sample code has been omitted. iSQL> SELECT e_lastname FROM employees;
E_LASTNAME
------------------------
Moon
Davenport
Kobain
. . .
20 rows selected.
Other Symbols Symbols other than those shown above are part of the actual code. EXEC :p1 := 1;
acc NUMBER(11,2)
Italics Statement elements in italics indicate variables and special values specified by the user. SELECT * FROM table_name;
CONNECT userID/password;
Lower case words Indicate program elements set by the user, such as table names, column names, file names, etc. SELECT ename FROM employee;
Upper case words Keywords and all elements provided by the system appear in upper case. DESC SYSTEM_.SYS_INDICES_;


Please refer to the following documents for more detailed information:

  • Installation Guide

  • Administrator's Manual

  • Getting Started Guide

  • SQL Reference

  • iSQL User's Manual

  • Error Message Reference


Altibase Welcomes Your Comments and Feedbacks#

We welcome your feedback on this manual. Your input is valuable in helping us improve future versions of the manual.

If you find any errors, omissions, or other technical issues in the Altibase manual, please report them through the Customer Service Portal, and we will address them with care. For immediate assistance with technical matters, you may also request support through the Technical Support Portal.

Thank you for your continued interest and valuable feedback.