Cleaning the SYNC database

SYNC file controls database access

The Adabas Audit Data Retrieval SYNC file is used to control access to the Adabas Audit Data Retrieval database.

The batch utility B97CLSYN clears this information from this database.

When to run B97CLSYN

Run the batch utility B97CLSYN:

  • If you are instructed to do so by support
  • If the following error message is displayed when trying to restart the Adabas Audit Data Retrieval started task:

    IRM9545E MASTER SUBSYSTEM IN USE

Before you run B97CLSYN

In most cases, the message IRM9545E MASTER SUBSYSTEM IN USE is simply due to an obsolete entry in the file BETA97.SYNC, which was left behind by a started task or a batch job that was not terminated properly.

Before running B97CLSYN, you must be positive that the message is not caused by an active Adabas Audit Data Retrieval started task or an active Adabas Audit Data Retrieval batch utility having control over the Adabas Audit Data Retrieval database. All Adabas Audit Data Retrieval started tasks using this database must be down when running B97CLSYN.

Note on sharing databases

The SYNC file contains an entry identifying the Adabas Audit Data Retrieval master subsystem. This entry is deleted when running B97CLSYN.

If you are sharing the Adabas Audit Data Retrieval database and if the active LST member contains BQL_SHARE_OPTION=ALL or BQL_SHARE_OPTION=SPOOL, make sure that the Adabas Audit Data Retrieval master subsystem is the first Adabas Audit Data Retrieval subsystem to be started after running B97CLSYN.

For information on BQL_SHARE_OPTION, see "Sharing databases with the BQL share option" in BSA Installation and System Guide.

Sample JCL

You can find sample JCL in member B97CLSYN in the BETA97.CNTL.

+-----------------------------------------------------------------------+
|jobcard |
|//CLSYN EXEC PGM=BST05SYC |
|//STEPLIB DD DISP=SHR, |
|// DSN=BSA.LOAD |
|//SYNCFILE DD DISP=OLD, |
|// DSN=BETA97.SYNC |
|//SYSUDUMP DD SYSOUT=* |
+-----------------------------------------------------------------------+

Return codes

0

Program ended normally – SYNC file has been cleaned.

16

Program ended normally – SYNC file was empty.

20

Read error

24

Write error

32

DD card missing or open error