DataManager Batch Processing and Reporting › The Archive/Restore Program (CAKSARCH) › The BACKUP Option

The BACKUP Option

Archival/Backup of DataManager tables is performed using the BACKUP option of the CAKSARCH program described below.

►►─ BACKUP ─ TBL=qualifier.tablename ─ DD=ddname ─────────────────────────────►

 ►─┬──────────────────────┬───────────────────────────────────────────────────►◄
   └─ where_clause; ─┘

where:

TBL=

Specifies the fully qualified data set name of the table to be backed up. Since DataManager stores definitions in four tables (IRDDESC, IRDTAB, ORDDESC and ORDTAB), submit four BACKUP statements to archive all these tables in one run. All versions stored in each table will be backed up.

DD=

Specifies the ddname of the DD statement that describes the output data set. The DD statement specifies where this backup file will be created ─ on tape or disk. When archiving multiple tables, be sure to assign each table a unique ddname. Corresponding DD statements must also be defined.

where_clause (optional)

It is recommended that you always backup an entire table, which means you would not use a where_clause. However, if used, the where_clause can selectively backup specific records within a table, for example, WHERE ORDID='MBJ'. When creating where_clauses, refer to the field names listed in Appendix C: DataManager Tables and end the where_clause with a semicolon (;).

• If a where_clause is used, DataManager backs up the records that meet the where_clause's selection criteria.
• If a where_clause is omitted, DataManager backs up all records stored in the specified table.