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

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

book

Article ID: 11843

calendar_today

Updated On:

Products

Datacom DATACOM - AD

Issue/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.



Is there a problem?

Environment

z/OS 2.1 CA Common Services 14.1 CA Datacom/AD 14.0

Resolution

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 .