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?
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.
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
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.
Rename the existing area A01 dataset to Name.Old.
Allocate a new larger dataset with same data set name as before.
Run DBUTLTY with:
INIT AREA=A01,DBID=1007 LOAD AREA=A01,DBID=1007,FORMAT=BACKUP,DDNAME=xxxxxx,SORT=99999 ACCESS STATUS=WRITE,DBID=1007
If the LOAD runs successfully, then run DBUTLTY with:
This will start the History task and will save the History records that were kept in MUF memory to disk.
Delete that renamed history dataset Name.Old.