Procedure to cleanup system files.

Document ID : KB000010244
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

In some occasions you will need to re-initialize Dataquery areas files.

Note that some of these files depend on each other and so need to be initialized together.

Background:

Either to enlarge these files, or one of these files, or resolve some errors...   

Errors like: Have you ever issued a query using CA Dataquery online or batch, and received a RC14(48) or a RECORD NOT FOUND error?  In either case, you KNOW the data exists!

Environment:
z/os or z/VSE, CA Datacom/DB 14.0 and above
Instructions:

 You may want to implement a practice of running through these steps every 6-month as preventative maintenance, to ensure your Dataquery System files have not become corrupted.

 

  1. Close down access via CICS to CA Datacom's Dataquery database, by issuing DBOC CLOSE=0003 from CICS regions that access your Multi-User Facility (MUF).

  2. Run a DBUTLTY batch job with the following SYSIN:

    ACCESS STATUS=OFF,DBID=3,USERS=FAIL

  3. Run DBUTLTY batch job with the following SYSIN:

    COMM OPTION=CLOSE,DBID=3

  4. Run the DBUTLTY INIT function for the following database 3 areas: DQE, DQF, DQR, DQS, DQT, and DQW. The SYSIN looks like:

    INIT AREA=DQE,DBID=3
    INIT AREA=DQF,DBID=3
    INIT AREA=DQR,DBID=3
    INIT AREA=DQS,DBID=3
    INIT AREA=DQT,DBID=3
    INIT AREA=DQW,DBID=3

  5. Run DBUTLTY LOAD, with FORMAT=NONE to null load each of the above areas. The SYSIN looks like:

    LOAD AREA=DQE,DBID=3,FORMAT=NONE,SORT=100000
    LOAD AREA=DQF,DBID=3,FORMAT=NONE,SORT=100000
    LOAD AREA=DQR,DBID=3,FORMAT=NONE,SORT=100000
    LOAD AREA=DQS,DBID=3,FORMAT=NONE,SORT=100000
    LOAD AREA=DQT,DBID=3,FORMAT=NONE,SORT=100000
    LOAD AREA=DQW,DBID=3,FORMAT=NONE,SORT=100000

  6. Run the DQWFINIT function for the DQE, DQF, and DQW.

    for DQE:

    //SYSIN DD *
    DQE
    /*

    for DQF:

    //SYSIN DD *
    DQF
    /*

    for DQW:

    //SYSIN DD *
    DQW nn
    /*

    Where nn is any number you have previously set. At installation time nn = 03

  7. Issue a DBOC OPEN=0003 command in each CICS communicating with the MUF to allow access to Datacom via CICS.

  8. After all jobs run successfully, run ACCESS STATUS=WRITE,DBID=3 to allow access to Dataquery database in batch.
Additional Information:

Please review CA Dataquery for CA Datacom Administration Guide for more information.