Noticed DEFRAG and CXX Report numbers don't match up.

Document ID:  TEC1874175
Last Modified Date:  06/12/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Datacom/DB

Releases

  • CA Datacom/DB:Release:15.0

Components

  • CA DATACOM/DB:DB
Introduction:

ran a 3 steps job,

1- First step is a DBUTLTY COMM=STATS and CXX REPORT TYPE=A.  The index used blocks in first step show 885,469.

2- The second step is a DEFRAG, the report shows 792,603 blocks deleted. 

3- The final step shows the index used blocks, after the DEFRAG, with 807,719. 

Question:

If the DEFRAG report is accurate, the CXX report, should show only 92,866 blocks used.

One of the reports seems wrong, but which one?   

Environment:
z/os, CA Datacom/DB 15.0
Answer:

The most accurate report is the CXX report if one is wanting values for a grand total. 

Additional Information:

Also, note that there is a printed statistic of "blocks deleted". This contains two things.

The first is DXX blocks which DEFRAG found already deleted but which the index queue has not yet processed.

The second are blocks which the DEFRAG itself deletes. These are typically blocks which are combined with other blocks, but they may also be something like a cleanup of logically deleted entries which were still physically present in the DXX when DEFRAG ran.

Hence DEFRAG can be used as a form of DXX TSN cleanup. 

... 

So, the Deleted Blocks by DEFRAG cannot be necessarily seen reported in the next CXX report as we may expect. Your Database may be or was very fragmented or disorganized. 

Other remark:

"The DEFRAG and its report deal with the DXX only.

The CXX report is IXX and DXX."

 

See CA Datacom/DB DBUTLTY REFERENCE GUIDE - DEFRAG FUNCTION for more info.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing