Backup and Restore 2 Manual

BRCOM BACKUP Command

Backup and Restore 2 Manual—522696-019

6-4

Summary of Backing Up OSS or SQL/MX Files

SQLCAT.SQLSCH.SQLTAB

*SQL 255,255 550 A+ 0 10Jan2013 14:43 ATP

HPIDMR5_SYSTEM_ZSD

PJB33_Q452KH00

*** Meta object BRIC backed up ***

Summary Information

Job completed.

Last error or warning occurred on page 1

Process elapsed time = 0:00:16.752

Objects processed = 6

Objects backed up = 6 Objects not backed up = 0

Objects not found = 0 Objects skipped = 0

Total tapes used = 1

Total Mbytes moved = 0

Total bytes:173442

Compressed bytes: 1982

Backing Up OSS Objects

Backing up a directory includes all its subdirectories and files.

Backing Up SQL/MX Objects

A catalog is a logical object. The catalog is a collection of schemas.



Backing up a catalog includes backing up all its subordinate schemas.

To back up objects on a remote node, you must register the catalog. The

A catalog is not visible to a remote node until you register it. For more information,

see the SQL/MX Reference Manual.



Backing up a schema includes backing up all its subordinate tables.



Backing up a table includes:



Nondroppable constraints.



Droppable constraints unless you specify the CONSTRAINTS EXCLUDED job

option.



All the table partitions including data.



Indexes unless you specify the INDEXES EXCLUDED job option.



All index partitions unless you specify the INDEXES EXCLUDED job option.



Backing up individual table partitions includes the partition data only when you

specify the PARTONLY job option.