The number of Line Indexes for Physically Deleted Records found in an IDMSDBAN report

Products

• IDMS - Database

Issue/Introduction

 

What is the best explanation for the "# of Line Indexes for Physically Deleted Records" found in an IDMSDBAN report?

Environment

IDMS 19.0 and all releases of IDMS

Resolution

The '# of line indexes for physically deleted records' reports on the total number of line indexes that were associated with deleted records. When a record gets deleted, the line index is set to binary zero. These are line indexes that have not been used after a record was deleted. Whether to be concerned or not depends on the number you see. Each line index is 8 bytes. So, multiplying 8 by the number of deleted records would give you an idea. Not usually a significant amount of space. Those line indexes can be reused if a store of a record targets to that page. 
An Unload-Reload can clean up that area and would remove those line indexes.
This statistic is also in the PRINT SPACE report, but is known as Null line.