When should I execute a DEFRAG against my IXX770 database file for CA 7?
Article ID: 36824
Updated On:
Products
Issue/Introduction
Why does the following message occur in the CA 7 STC during initialization time and again directly after midnight?
*CAL2SM00I Area: IXX DBID: 0770 Full: nn.nn%
*CAL2SM01W Area: IXX DBID: 0770 Full: nn.nn%
The CA 7 STC will generate a CAL2SM00I on each database file at during initialization time and again directly after midnight to show the current allocations of each CA Datacom/AD area.
The CA 7 STC will generate a CAL2SM01W indicating that the CA WA CA 7 Edition is over 80 percent in its current allocation. The situation could cause CA 7 outage if the area gets full.
Cause
INDEX % Full
Environment
Component: 7
Resolution
Run the DBUTLTY from the CAL2JCL(AL2DEFRG) install library at any time with while the CA 7 STC is active or inactive. The parm ‘DEFRAG’ must be present to reclaim any unused space.
Note: The DEFRAG option can only be used for the IXX770.
The following DBUTILITY can be submitted to reclaim the unused space.
//AL2DEFRG JOB (ACCTINFO),PGMR,CLASS=A,MSGCLASS=A
//* Sample job to defragment CA Datacom Index.
//* This job may run while CA 7 is active.
//DEFRAG EXEC PGM=DBUTLTY,REGION=4M
//STEPLIB DD DISP=SHR,
// DSN=datacomhlq.CUSLIB
// DD DISP=SHR,
// DSN=datacomhlq.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DEFRAG DBID=770
/*
Schedule the AL2DEFRG job in CA 7 to run bi-weekly for efficiency and to reclaim space in the IXX.
Feedback
