When should I execute a DEFRAG against my IXX770 database file for CA 7?
Article ID: 36824
Updated On:
Products
Issue/Introduction
Question:
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%
Answer:
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. A defragmentation bi-weekly makes the CA Datacom/AD index function more efficiently and reclaims space in the index.
The CA 7 STC will generate a CAL2SM01W indicating that CA WA CA 7 Edition is over 80 percent in its current allocation. This situation could cause a CA WA CA 7 outage to occur if the area becomes full.
The following DBUTLTY can be run 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.
//AL2DBFRG 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
/*
As always, please contact CA Technologies support for CA 7 if you have further questions.
Cause
INDEX % Full
Environment
Component: 7
Resolution
Run AL2DEFRG
Feedback
