Utility Statements › PRINT INDEX › Examples

Examples

Printing an entire index

The following example directs the PRINT utility to report on the EMP-IDX-SET using the FULL option.

PRINT INDEX "EMP-IDX-SET" DBNAME VLDBDBN USING VLDBSUBC FULL;

Printing the bottom level of an index

The following example directs the PRINT utility to report on the COV-IDX-SET using the LEVEL and TERSE options.

PRINT INDEX "COV-IDX-SET" SEGMENT VLDBSPG1 USING VLDBSUBC  MEMBER X'01390448' LVL 0 TERSE;

Printing individual SR8 record

The following example directs the PRINT utility to report on a specific SR8 record.

PRINT INDEX SR8 5:80130:03 NEXT 2 HEX;

Printing an index from an SQL-defined database

The following example directs the PRINT utility to report on the EMP-COVERAGE index that is part of the SQLSPG.EMPLOYEE table.

PRINT INDEX "EMP-COVERAGE” SEGMENT VLDBSPG1 TABLE SQLSPG.EMPLOYEE SUMMARY;

Printing a summary report of an index

The following example directs the PRINT utility to report on the DEPT_EMPL index using the SUMMARY option.

PRINT INDEX DEPT_EMPL SEGMENT USERDB TABLE DEMO.DEPT SUMMARY;

Printing a REFERENCING ROWID summary report of an index

The following example directs the PRINT utility to report on the index occurrence containing the row ID of the referencing row identified by X'01390201'.

PRINT INDEX "COV-IDX-SET" SEGMENT VLDBSPG1 TABLE SQLSPG.COVERAGE REFERENCING ROWID X'01390201' SUMMARY;