Generating JCL for database utilities

Overview

You can generate JCL for the maintenance of the Adabas Audit Data Retrieval database (ENLARGE, REDUCE, ALTER, etc.) with Option 4 - UTILITIES.

The option uses skeletons from the BSA skeleton library (ISPSLIB) and generates the JCL according to your input in the displayed panels. You can display, send or save the generated JCL in a member.

Note

Please note the following:

  • The libraries that are currently allocated by the Adabas Audit Data Retrieval started task are used for generating the JCL. (This option does not use the libraries specified in the system options.)
  • If mirror databases exist, they are automatically taken into consideration when the JCL is generated.

Instructions

To generate JCL for a database utility:

  1. Select Option 1 - Database, then Option 4 - UTILITIES.

    The Adabas Audit Data Retrieval databases are displayed in a table.

  2. Enter the line command S in front of the desired database.
  3. In the displayed panel, select the maintenance task for which you would like to generate the JCL and follow the instructions in the displayed panels.

Maintenance tasks

The maintenance tasks offered depend on the respective database type:

  • Type Data (DA)

    1     ENLARGE

    2     REDUCE

    3     ALTER

    4     MOVE (alter with copy)

    5     UPD-HWM (change the High Water Mark)

    6     UNLOAD

    7     LOAD

    8     REBUILD (recreating the key file)

  • Type Key (KE)

    1     ENLARGE

    2     REDUCE

    3     ALTER

    4     MOVE (alter with copy)

    5     UPD-HWM (change the High Water Mark)

  • Type Sync (SY)

    1     ALTER

    2     RE-ALLOC (re-allocate)

    3     CLEARSYN

  • Type Log (LO)

    1     ALTER

    2     RE-ALLOC (re-allocate)

  • Spool file of any type (Spool (SP), Reload (SR), Index (IX), Cache (CA) or Global (GL))

    None

  • Definition file (NO)

    None

Further information

For more information on individual database utilities, see "Databases and database batch utilities" in BSA Installation and System Guide.