DELETED ROWS in a RETIX KEYNAME=*SETR report question

Document ID : KB000094733
Last Modified Date : 04/05/2018
Show Technical Document Details
Introduction:
DBUTLTY RETIX with KEYNAME=*SETR parameter is used to resynch the CXX records count with the actual number of records in a table. 
 
Question:
I ran a RETIX with KEYNAME=*SETR parameter and the generated report shows:
BLOCKS READ 37 TABLE ROWS 4,256 DELETED ROWS 33 OTHER ROWS 0 

What are the DELETED ROWS? 
Answer:
A deleted row is one that has been deleted in the past and has not been removed from the data block yet. Physically removing the row only occurs when it is convenient to write the block. 
Additional Information:
Note that RETIX KEYNAME=*SETR was replaced by DBUTLTY DATASCAN COUNT_SET_RECORDS function on Datacom 15.1: 
 DATASCAN AREA=aaa,DBID=nnnn,OPTION=COUNT_SET_RECORDS 
The AREA= is optional where if it is missing all areas in the DBID are done.