Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-36
SQLDATA Job Option

If you do not specify any index partitions or table partitions, you must not specify
PARTONLY ON.

If you specified the PARTONLY ON job option during a backup operation, you must
also specify PARTONLY ON for the RESTORE command.

The PARTONLY ON job option supports only SQL/MX objects. If you specify this
job option but do not specify any SQL/MX objects, an error occurs. This option is
not supported for OSS.

If you specify PARTONLY ON for backing up table partitions, you must specify
INDEXES EXCLUDED and CONSTRAINTS EXCLUDED.

You cannot specify SQLDATA OFF with the PARTONLY ON job option.
PARTONLY is not supported for hash-partitioned (as opposed to range-partitioned)
tables.
SQLDATA Job Option
This job option specifies whether to back up the SQL/MX data in index partitions and
table partitions or to back up only the DDL information for these objects. ON is the
default.
OFF
records the DDL, which lets you issue a create table or create index on the
RESTORE. The resulting backup tape contains the DDL information necessary to
re-create an empty version of the SQL object, without any of the SQL data.
ON
records the SQL data and the DDL.
Guidelines

The SQLDATA job option supports only SQL/MX objects. If you specify this job
option but do not specify any SQL/MX objects, an error occurs. This option is not
supported for OSS objects.

The SQLDATA OFF job option has no effect on catalogs, schemas, tables, and
indexes. However, if you specify a catalog, schema, or table and SQLDATA OFF,
any table partitions and index partitions subordinate to the specified object are not
backed up.

You cannot specify SQLDATA OFF with the PARTONLY ON job option.
SQLDATA { OFF | ON }