Backup and Restore 2 Manual

BRCOM BACKUP Command

Backup and Restore 2 Manual—522696-019

6-30

INDEXES Job Option

This job option specifies whether or not table indexes are backed up. INCLUDED is the

default.

EXCLUDED

does not back up the table indexes and index partitions for each of the tables

selected for backup.

INCLUDED

backs up the table indexes and index partitions for each of the tables selected for

backup.

Guidelines



The INDEXES job option is supported only for 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.



If you specify INDEXES INCLUDED, you cannot specify PARTONLY ON.



If you specify PARTONLY ON, you must specify INDEXES EXCLUDED.



If you specify INDEXES EXCLUDED, you must specify CONSTRAINTS

EXCLUDED.

JOB Job Option

This job option specifies a job identifier.

jobid

is a valid unique job identifier with a maximum of eight characters. The characters

can be alphabetic, numeric, or a combination of both. The first character cannot be

numeric. Wild cards (* or ?) are not permitted. Job IDs are not case-sensitive. For

example:

A1234567

aaaaaaaa

abcdEFG

I607

INDEXES { EXCLUDED | INCLUDED }

JOB jobid