PRINT SPACE reporting impossible statistics

Products

• IDMS
• IDMS - Database

Issue/Introduction

The output of a PRINT SPACE with the FULL option is reporting nonsense values, such as Total Space Available being reported as greater than 100%.

For example:

-Total Space Allocated                             3,919,440,000
 Total Space Available            (Percent)        4,677,708,928    (119.34%)
 Total Reserved Space Available   (Percent)                    0    (  0.00%)
 Total Unreserved Space Available (Percent)        4,677,708,928    (119.34%)

Environment

Release: All supported releases.

Cause

The ORIGINAL PAGE SIZE clause for the area is missing or incorrect.

Resolution

Correct the ORIGINAL PAGE SIZE clause.

If an area has had its page size increased by the EXPAND PAGE utility, the original page size must be defined in the area with the ORIGINAL PAGE SIZE clause. If this is missing from such an area or if it is incorrect, this problem can occur in PRINT SPACE.

Note that the problem will only occur if the FULL option is used. Without the FULL option, this situation will result in DB002701 SMP/SMI mismatch error.

Additional Information

If there is any doubt about what a particular area's ORIGINAL PAGE SIZE should be, see Determine the ORIGINAL PAGE SIZE of an existing database area.