HP 3000 Manuals HP 3000 Manuals
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.
Click here to view figure.
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]
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
Figure 2-10. LOG COMMENT Statement Syntax