Batch Processing & Reporting › The Archive/Restore Program (CAKSARCH) › The RESTORE Option › RESTORE Option Output

RESTORE Option Output

When the Archive/Restore program successfully restores your tables, you receive printed output that looks like this:

CA                    - Q  ARCHIVE/RESTORE PROGRAM                     PAGE   1
CA PMA/DM 1.0 9010KS100             REPORT             FRI JAN 25 16:58:41 1991
                USING: DATABASE=DSNDB04, SUBSYS=DB23, WHATSQL=DB2
 
                                   A.              B.           C.
INPUT:
RESTORE TBL=QAHRDN1.ELEMTAB,DD=BACKTAB
 
FILE HEADER LINE=** TABLE=QAHRDN1.ELEMTAB  COLS=9  on 1/18/1991  4:33:49 PM
 
SQL:
    CREATE TABLE  QAHRDN1.SHIRL
    (VERSION CHAR(8),
    ORDID CHAR(3),
    ELEMENT CHAR(16),
    UNIT CHAR(16),
    NORMAL CHAR(16),
    DEFRATE DECIMAL(15,0),
    MINCHG DECIMAL(15,0),
    MAXCHG DECIMAL(15,0),
    COST DECIMAL(15,0)) IN DATABASE DSNDB04
 
CAKS632I - TOTAL NUMBER OF ROWS PROCESSED=8
CAKS611I - RESTORE PROCESSING COMPLETED SUCCESSFULLY

A.

DATABASE=DSNDB04:

This parameter is defined in CA PMA Chargeback CAIKSPAR parameter file and identifies the database you want information restored to. In this example, the database is DSNDB04.

B.

SUBSYS=DB23:

This parameter is defined in CA PMA Chargeback CAIKSPAR parameter file and provides your database's SUBSYSTEM_ID. This example uses DATABASE2 - DB23.

C.

WHATSQL=DB2:

This parameter is defined in CA PMA Chargeback CAIKSPAR parameter file and identifies the type of SQL you are using: either DB2 or Datacom. This example uses DB2.