What is the best explanation for the "# of Line Indexes for Physically Deleted Records" found in an IDMSDBAN report?
IDMS 19.0 and all releases of IDMS
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.