Managing Databases › Time Series Facility Database › Increase Data Set Space Allocations

Increase Data Set Space Allocations

System administrators can add space to the TSF database after customizing the database to optimize database space performance and to reclaim free space. Adding more space enables continuous use of the database when the data area is full.

You can add space to the TSF database by increasing data set space allocations. A backup, delete, define, and reload of the database is performed through JCL. Use this option to control the number of extents used. A backup and load is required if you want to retain the data.

Note: Sample JCL is provided in chorus_runtime_hlq.CETJJCL. You can run the CHTSDBBK periodically to create a backup of the database.

Follow these steps:

1. Confirm that your CA Datacom/AD MUF for CA Chorus is active.
2. Edit the following members located in chorus_runtime_hlq.CETJJCL as described in the members:

   CHTSDBBK

   Creates a backup of the TSF database.

   TSDB102

   Deletes the TSF database definition in the CA Datacom/AD MUF.

   CHTSDBDL

   Deletes the existing TSF database files.

   TSDB002

   Allocates and defines the TSF database to the CA Datacom/AD MUF. Change the space allocations for IXX4003, G014003, G024003, G034003, and G044003 in accordance with the increased space requirement.

   Note: TSDB002 allocates the files needed for the TSF database and performs an initial load, which creates a database with schema definitions but no data.

   CHTSDBLD

   Loads the TSF database from the backup.

3. Reallocate the TSF database by executing the following steps in the order shown:

   Important! Select a time to run these jobs that least impacts your users.

   1. Stop the CHORJBOS and CHORTSF started tasks:

      P CHORJBOS
      P CHORTSF
      

   2. Submit CHTSDBBK.

      A backup version of the database is created.

   3. Submit TSDB102.

      TSF database definition is deleted from the CA Datacom/AD MUF.

   4. Submit CHTSDBDL.

      The TSF database files are deleted.

   5. Submit TSDB002 (includes adjusted space requirements from step 2).

      The TSF database is created.

   6. Submit CHTSDBLD.

      The TSF database is loaded from the backup made in CHTSDBBK.

   7. Start the CHORTSF and CHORJBOS started tasks:

      S CHORTSF
      S CHORJBOS
      

   The TSF database is reallocated.

   Note: A return code of 0 is expected from all jobs.

   You have successfully increased the data set space allocations and helped ensure continuous operation of the database.