SB37 ABEND on IXX601 (CA11)
Article ID: 54792
Updated On:
Products
Issue/Introduction
If the CA11 MANT task is not run on a regular basis or the IXX for Database 601 is not sized appropriately, the database index area (IXX601) for CA 11 could fill up. This can result in an Abend SB37 on the IXX601 file and affect batch processing. This article explains how to correct.
Environment
z/OS
Resolution
Before the IXX601 file can be allocated larger, shut down or suspend the CA 11 application and make DB 601 unavailable to CA 11. Use the Datacom/AD DBUTLTY program with this input:
//SYSIN DD *
ACCESS DBID=601,STATUS=OFF,USERS=FAIL
COMM DBID=601,OPTION=CLOSE
/*
If the DBUTLTY step does not complete with a COND CODE 0000, at least one instance of CA 11 is still connected to the Datacom MUF. Identify and suspend or end the instances and then resubmit the DBUTLTY job. If the DBUTLTY still fails after verifying all CA 11 instances are inactive, contact Datacom Support for assistance.
Once this is done , delete or rename the IXX601. After the IXX601 has been deleted or renamed, allocate a larger IXX601 dataset, rebuild its index entries and make DB 601 available for access by CA11 again. Below is a sample to do all this. Please see information in the NOTE that follows the JCL prior to running this job.
//INITDB EXEC PGM=DBUTLTY,REGION=0M
//STEPLIB DD DISP=SHR,DSN=DATACOM.CUSLIB
// DD DISP=SHR,DSN=DATACOM.CAAXLOAD
//IXX601 DD DISP=(,CATLG),DSN=<HLQ>..IXX601,
// SPACE=(CYL,(nnn,nn)),UNIT=3390
//SYSIN DD *
INIT DBID=601,AREA=IXX
RETIX DBID=601,OPTIMIZE=YES,SORT=999,SORTDFLT=YES,OPTION1='(I)'
COMM DBID=601,OPTION=STATS
REPORT DBID=601,AREA=CXX,TYPE=A
ACCESS DBID=601,STATUS=WRITE
/*
NOTE: As a rule of thumb, the IXX601 should be as large as the larger of your JHF601 or DSN601, and the secondary extent should be about 20% of the primary. DSNTYPE=LARGE or multiple volumes can be used if desired. To rebuild the index, the Datacom/AD MUF stays up and all CA 11 started tasks must be Suspended or shut down (if TRKRMS=NO in the CA 11 config file). Be certain that the STEPLIB references for the DATACOM CUSLIB and CAAXLOAD are the same as the ones referenced in the Datacom/AD started task (MUF).
If the DBUTLTY completes with a COND CODE 0000, either Resume or start CA 11.
If the DBUTLTY does not complete with a COND CODE 0000, contact Datacom Support for assistance.
Additional Information
One way to ensure that your IXX601 optimizes its space is to use the Datacom/AD DBUTLTY function called DEFRAG. The DBUTLTY DEFRAG function defragments or compresses the partial blocks used by the index so that space is reclaimed, and this function runs while the databases are open and in use. Because it runs in the background, users will not be affected.
To run the DEFRAG function, execute the DBUTLTY program with this input:
//SYSIN DD *
DEFRAG DBID=601
/*
You should run the DEFRAG function once a month or more frequently, following the CA 11 MANT process. For additional information on this function, please see the documentation DEFRAG (Defragment Index)
Feedback
