Question
*U11D-8200-5 SSN=CAL7 DBID=0601 Area=IXX at 90% used. Why does this message occur?
Answer:
The CA 11 STC will generate a U11D-8200-5 message once any database file reach a designated threshold, based on its ‘DBWARN=’ configuration file setting. If the area is identified as the IXX, a DEFRAG should be performed.
Note: The DEFRAG option can only be used for the IXX601.
The following DBUTLTY can be submitted to reclaim the unused space.
//*******************************************************************
//* *
//* SAMPLE DEFRAG OF A CA DATACOM DATABASE INDEX *
//* *
//* THIS JOB PERFORMS AN ONLINE COMPRESS OF THE INDEX FOR A *
//* CA DATACOM DATABASE USING THE CA DATACOM DBUTLTY PROGRAM. *
//* *
//* THIS JOB CAN BE RUN WHILE THE CA DATACOM DATABASE IS OPEN *
//* AND THE APPLICATION IS ACTIVE. *
//* *
//* THIS JOB WILL: *
//* 1. REFRESH CXX DISK-BASED STATISTICS *
//* 2. RUN A CXX TYPE=A REPORT ON THE DBID *
//* 3. DEFRAGMENT THE INDEX BLOCKS *
//* 4. REFRESH THE CXX STATISTICS AGAIN *
//* 5. PRODUCE A FINAL CXX TYPE=A REPORT *
//* *
//*******************************************************************
//*
// SET CUS=YOUR DATACOM CUSLIB
// SET CAI=YOUR DATACOM CAILIB (R11.0) OR CAAXLOAD (V12.0)
// SET CXX=YOUR CXX FILE NAME
//*
//DEFRAG EXEC PGM=DBUTLTY,REGION=4M
//STEPLIB DD DISP=SHR,DSN=&CUS
// DD DISP=SHR,DSN=&CAI
//SYSPRINT DD SYSOUT=*
//CXX DD DISP=SHR,DSN=&CXX
//SYSIN DD *
COMM DBID=601,OPTION=STATS
REPORT DBID=601,AREA=CXX,TYPE=A
DEFRAG DBID=601
COMM DBID=601,OPTION=STATS
REPORT DBID=601,AREA=CXX,TYPE=A
/*
//
After running the DEFRAG utility, if you would like to increase the space in the IXX601, please perform the following steps:
1. Suspend CA WA Restart Option on all LPARs that share the same 601 database.
2. Set Access Off and execute a COMM CLOSE on DBID 601 (using DBUTLTY).
3. Delete IXX601.
4. Increase IXX601 size.
5. Perform DBUTLTY RETIX.
6. Perform DBUTLTY access write.
7. Resume CA WA Restart Option.
Note: Before the IXX601 file can be expanded, make database 601 unavailable to CA WA Restart Option. Use the CA Datacom DBUTLTY with the following SYSIN control statements to make database 601 unavailable:
ACCESS STATUS=OFF,DBID=601,USERS=FAIL
COMM OPTION=CLOSE,DBID=601
As always, please contact CA 7 support if you have further questions.