CA Datacom RC 07 (38) on CADTCM_HISTORY_ADS

Document ID : KB000021840
Last Modified Date : 20/08/2018
Show Technical Document Details
Issue:

CA Datacom dynamic extend failure on A011007 and return code 07 (36) on CADTCM_HISTORY_ADS
The following errors are issued :

DB01705I - DYNAMIC EXTEND START A011007 TRK 274 DATACOM.A011007
IEC030I B37-04,IFG0554A,DATACOM,DATACOM,A011007,830D,DCMP01,  018
        DATACOM.A011007
DB01702I - DYNAMIC EXTEND OF AREA A011007  HAS FAILED
DB03003E - UNEXPECTED RETURN CODE 07 (36) PROCESSING CADTCM_HISTORY_ADS

This table is an area daily statistics table part of the history database DBID 1007 in AREA A01. It is enabled with the MUF startup option HISTORY.
How can the size of this table be increased?

Cause:

By default , this table has been defined with DYNAMIC-EXTEND turned on but when the maximum number of extents have been reached or when there is no more space available then an ADDIT to this table fails with a Datacom return code 07.

Resolution:
Follow this procedure in order to increase the size of the history database:
  1. Run DBUTLTY using the following SYSIN cards:

    ​COMM OPTION=CLOSE,DBID=1007
    ACCESS STATUS=OFF,DBID=1007,USERS=FAIL
    REPORT AREA=CXX,DBID=1007
    BACKUP AREA=A01,DBID=1007,SEQ=PHY,RECID=YES,DDNAME=xxxxxx
  2. After a successful backup, look for dataset  name of area A01 in the CXX report created in step 1.  Alternatively look for the dataset name in the error messages.

  3. Rename the existing area A01 dataset  to Name.Old.

  4. Allocate a new larger dataset with same data set name as before.

  5. Run DBUTLTY with:

    INIT AREA=A01,DBID=1007
    LOAD AREA=A01,DBID=1007,FORMAT=BACKUP,DDNAME=xxxxxx,SORT=99999
    ACCESS STATUS=WRITE,DBID=1007
  6. If  the LOAD runs successfully, then run DBUTLTY  with:

    COMM OPTION=STATS

     This will start the History task and will save the History records that were kept in MUF memory to disk.

  7. Delete that renamed history dataset Name.Old.

Additional Information:
See DocOps section HISTORY and Creating and Maintaining the History Database