Blocks in use as per CXX report are lower after running DBUTLTY LOAD DBID=700 . Why?

Document ID : KB000011843
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

I ran a DBUTLTY reorganization on the CA ENF database , DBID 700 .

DBUTLTY REPORT AREA=CXX,DBID=700  now shows a different value in BLOCKS IN USE than before the reorg.

Question:

Is there a problem?

Environment:
z/OS 2.1 CA Common Services 14.1 CA Datacom/AD 14.0
Answer:

You ran  DBUTLTY BACKUP DBID=700,SEQ=NATIVE.

This native sequence backup uses the Native Key defined to each table in a data area to reorganize the data area in Native Key sequence.

This ENF area uses DSOP MODE - SEQUENTIAL .

With this mode , deleted row space is not reclaimed until you run a native backup/load .

So when you use this backup as input to the DBUTLTY LOAD function , each row will be reloaded in perfect native key sequence .

DBUTLTY reloads the rows in each data area block until it is completely full . When the load finishes , the number of used blocks can be lower if the data area blocks had space that was not reused for deleted rows.

 

Before the load , the data took BLOCKS IN USE - 1,262 per your CXX report and after the load BLOCKS IN USE - 87 .