Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-16
Backup Object
IND | INDEX
is the object type for an index.
sqlmx-source-object
is the set of SQL/MX objects to be backed up. It is a valid SQL/MX object such
as the name of a catalog, schema, table, or index. The specified object and all
subordinate objects are backed up. Wild cards are not permitted in
sqlmx-source-object.
TPART
is the object type for a table partition. Table partitions are physical objects.
sqlmx-table
is a valid SQL/MX table name.
IPART
is the object type for an index partition. Index partitions are physical objects.
sqlmx-index
is a valid SQL/MX index name.
PARTITION[(sqlmx-part[,sqlmx-part ]...) |
(sqlmx-ipart[,sqlmx-ipart ]...)]
is one or more existing SQL/MX table or index partition names of the table or
index specified in the sqlmx-table. or sqlmx-index. If you specify TPART
or IPART object type, you must specify at least one table partition name and
the PARTONLY job option. You must enclose the names of the table partitions
in parentheses.
WHERE expression
allows further exclusions from an sqlmx-source-directory. It specifies
qualifying criteria for including objects from the source directory for backup. The
order of precedence in expression evaluation is parentheses, NOT, AND, OR.
Parentheses within a WHERE expression are optional. For SQL/MX, it is any of:
{ sqlmx-qualifier }
{ NOT sqlmx-qualifier }
{ (sqlmx-qualifier AND sqlmx-qualifier ... ) }
{ (sqlmx-qualifier OR sqlmx-qualifier ... ) }
sqlmx-qualifier
is one or more of these filters: