When should I execute a DEFRAG against my IXX770 database file for CA 7?

book

Article ID: 36824

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition CA-7 JOB MGMT CA 7 Workload Automation

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(AL2DBFRG) 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.

Environment

Release:
Component: 7