Datacom DEFRAG and CXX Report numbers not matching
book
Article ID: 14649
calendar_today
Updated On:
Products
Datacom
IPC
Datacom/AD
Datacom/DB
Issue/Introduction
Running a 3 step job and noticed the following:
- First step is a DBUTLTY COMM=STATS and CXX REPORT TYPE=A. The index used blocks in first step show 885,469.
- The second step is a DEFRAG, the report shows 792,603 blocks deleted.
- The final step shows the index used blocks, after the DEFRAG, with 807,719.
One of the reports seems wrong, but which one?
Resolution
DEFRAG and its report deal with the DXX only while the CXX report includes both IXX and DXX blocks.
The most accurate report to follow would be the CXX report.
Feedback
thumb_up
Yes
thumb_down
No