THE NUMBER OF LINE INDEXES FOR PHYSICALLY DELETED RECORDS FOUND IN AN IDMSDBAN

book

Article ID: 220609

calendar_today

Updated On:

Products

CA IDMS - Database

Issue/Introduction

WHAT THE BEST EXPLANATION THE NUMBER OF LINE INDEXES FOR PHYSICALLY DELETED RECORDS FOUND IN AN IDMSDBAN REPORT

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.