HP 3000 Manuals

ALLBASE/Replicate User's Guide

ALLBASE/SQL Statements that Support ALLBASE/Replicate 

Several ALLBASE/SQL statements have been modified to include clauses that
support the operation of ALLBASE/Replicate.  In addition, several
new statements have been created which specifically handle only
ALLBASE/Replicate related functionality.

The modified and new statements that support ALLBASE/Replicate are as
follows:

   *   ALTER TABLE
   *   CREATE TABLE
   *   CREATE PARTITION
   *   DISABLE AUDIT LOGGING
   *   DROP PARTITION
   *   ENABLE AUDIT LOGGING
   *   LOG COMMENT
   *   START DBE NEW
   *   START DBE NEWLOG

These statements are briefly described on the following pages.  For each
statement, there is an annotated syntax diagram.  Clauses in the syntax
that apply to ALLBASE/Replicate operation are highlighted, and
information about specific clauses is presented in highlighted boxes
where appropriate.  A more complete description of each statement can be
found in chapter 6, "ALLBASE/Replicate Statement Syntax Reference."

Brief Description of ALLBASE/Replicate Statements 

   *   START DBE NEW--Use this statement to create a new DBEnvironment
       and specify its startup parameters.

          *   Use either the START DBE NEW or the START DBE NEWLOG
              statements to specify several clauses that can define
              startup parameters for an ALLBASE/Replicate DBEnvironment.

          *   Use the ALLBASE/Replicate related clauses that are
              highlighted in gray in the syntax diagrams at START DBE NEW
              time.

          *   Specify the ALLBASE/Replicate related clauses that are
              boxed in white in the syntax diagrams at START DBE NEWLOG
              time.

          *   Use the AUDIT LOG parameter, which starts audit logging, at
              START DBE NEWLOG time, after the DBEnvironment has been
              created and loaded.

          *   Specify any other ALLBASE/Replicate parameters when the
              DBEnvironment is originally created, using START DBE NEW.

          *   Change any ALLBASE/Replicate related clauses specified
              using START DBE NEW later using START DBE NEWLOG.


          Figure 2-3.  START DBE NEW Statement Syntax 

   *   START DBE NEWLOG--Use this statement to change parameters set
       using the START DBE NEW statement, and to replace existing log
       files with log files newly defined using this statement.
       Several clauses that can define startup parameters for an
       ALLBASE/Replicate DBEnvironment can be specified in either the
       START DBE NEW or the START DBE NEWLOG statements.

          *   Specify the ALLBASE/Replicate related clauses that are
              highlighted in gray in the syntax diagrams at START DBE NEW
              time.

          *   Specify the ALLBASE/Replicate related clauses that are
              boxed in white in the annotated syntax diagrams at START
              DBE NEWLOG time.

          *   Use the AUDIT LOG parameter, which starts audit logging, at
              START DBE NEWLOG time, after the DBEnvironment has been
              created and loaded.[REV BEG] This prevents the generation
              of unnecessary audit log records during the load process
              and therefore makes more efficient use of log file
              space.[REV END]


          Figure 2-4.  START DBE NEWLOG Statement Syntax 

   *   CREATE TABLE--Use this statement to create new tables in the
       DBEnvironment.

          *   Use IN PARTITION to specify the partition the table will be
              associated with.

          *   Place the table in any partition except the NONE partition
              for the table to be replicated when audit logging is
              enabled.

          *   Change partition assignments created with this statement
              later using the ALTER TABLE statement.


          Figure 2-5.  CREATE TABLE Statement Syntax 

   *   ALTER TABLE--Use this statement to make alterations to the table
       parameters specified at CREATE TABLE time.  The annotated syntax
       diagram shows only that portion of the ALTER TABLE syntax needed
       to support ALLBASE/Replicate operations.  For full syntax, see the
       syntax section of the ALLBASE/SQL Reference Manual.

          *   Change partition assignments made using CREATE TABLE using
              this statement.

          *   Use the ALTER TABLE statement for assigning partitions to
              tables when converting DBEnvironments (which were created
              before the use of ALLBASE/Replicate) into ALLBASE/Replicate
              DBEnvironments.


          Figure 2-6.  ALTER TABLE Statement Syntax 

   *   CREATE PARTITION--Use this statement to create user-defined
       partitions.

          *   You must specify both a PartitionName and a
              PartitionNumber.

          *   You must use the PartitionName in the CREATE TABLE and
              ALTER TABLE statements.

          *   You must specify the PartitionNumber as a parameter when
              initially starting the ALLBASE/Replicate slave application.
              This indicates which ALLBASE/Replicate master partitions
              will be replicated on the slave.


          Figure 2-7.  CREATE PARTITION Statement Syntax 

   *   DROP PARTITION--Use this statement to drop partitions created
       using CREATE PARTITION.

          *   The partition must not have any tables associated with it
              or the statement will fail and generate an error message.

          *   The partition is identified by PartitionName, not by
              PartitionNumber.


          Figure 2-8.  DROP PARTITION Statement Syntax 

   *   DISABLE AUDIT LOGGING--Use this statement to disable audit logging
       for only the current session.  Use it when you want to perform
       bulk operations and do not want to generate audit log records for
       the operations.  An example of such an operation is hard
       resynchronization.  DBA authority is required to use this
       statement.

   *   ENABLE AUDIT LOGGING--Use this statement to reenable audit logging
       after use of the DISABLE AUDIT LOGGING statement.  DBA authority
       is required.


          Figure 2-9.  ENABLE/DISABLE AUDIT LOGGING Statement Syntax 

   *   LOG COMMENT--Use this statement to allow user comments to be
       written to the log files as audit log records in the COMMENT
       PARTITION.

          *   The COMMENT PARTITION must be defined in the START DBE NEW
              or START DBE NEWLOG statement if LOG COMMENT will be used.

          *   The COMMENT AUDIT ELEMENT must also be specified.

          *   Comment audit log records may be viewed in the log file
              using the SQLAudit tool.


          Figure 2-10.  LOG COMMENT Statement Syntax 

MPE/iX 5.0 Documentation