TUNE INDEX reports incorrect IBC

Products

• IDMS
• IDMS - Database

Issue/Introduction

TUNE INDEX reports a different IBC (Index Block Contains) than PRINT INDEX.

Environment

IDMS: All supported releases.

Resolution

PRINT INDEX reports the IBC as defined in the schema.

DIS SET EMP-NAME-NDX.
*+   ADD
*+   SET NAME IS EMP-NAME-NDX
*+       ORDER IS SORTED
*+       MODE IS INDEX BLOCK CONTAINS 40 KEYS
…     

PRINT INDEX EMP-NAME-NDX SEGMENT EMPDEMO USING EMPSS01 SUMMARY;
*+ Status = 0        SQLSTATE = 00000
*+ SET Name: EMP-NAME-NDX
*+    IBC 40                               Displacement        0
…

It is possible to TUNE an index with a different IBC expressed either as an absolute value or a percentage of the schema-defined value. If you do that, and use the REBALANCE option, then TUNE INDEX will report the calculated IBC accordingly.

TUNE INDEX FOR DBNAME EMPDEMO SUBSCHEMA EMPSS01
SET(EMP-NAME-NDX)
DEFAULT TUNE OPTIONS
REBALANCE YES
TEMPORARY INDEX UTILIZATION 70%;
*+ Status = 0        SQLSTATE = 00000        Messages follow:
*+ DB002994 T118 C0M333: IDMSTUNE  -  processing started
*+ DB002994 T118 C0M333: IDMSTUNE  -  Indexes selected for processing:
*+ DB002994 T118 C0M333: IDMSTUNE  -  EMP-NAME-NDX (IBC=28) in area
*+ EMPDEMO.EMP-DEMO-REGION (PGRSV=0)