CA RC/Query for DB2 for Z/OS: Index Detail Inquiry , Partitioned Index Runstats Fields
book
Article ID: 186860
calendar_today
Updated On:
Products
RC/Query for DB2 for z/OS
Issue/Introduction
Why do the fields: 'FIRST KEY', 'FULL KEY', 'N.LEAF', 'LEVELS', 'KEY COUNT', 'CLUSTER%', 'LIMITKEY' and 'STATSTIME' display blanks or 'N/A' on the Index Detail Inquiry?
Environment
DB2 for Z/OS
Resolution
The 'RC/Query Index Detail Inquiry' screen is a two-part screen. The second screen can be accessed by pressing PF11. The information for these fields appears on the second screen and relates to Index Partitions if they exist.
The information for these fields is extracted from the SYSIBM.SYSINDEXSTATS table. Sysindexstats contains one row for each partition of a partitioned index. If the index is NOT partitioned(a non-partitioned index)the fields 'FIRST KEY', 'FULL KEY', 'N.LEAF', 'LEVELS' will be filled in on the FIRST screen if the runstats utility has been executed on the non-partitioned index.
First screen if non-partitioned index and runstats has been run:
BUFFERPOOL: BP0 DATABASE: DBCORP01 FIRST KEY: 1 CLOSE : YES UNIQUE : PRIMARY FULL KEY : 4 ERASE : NO COPY : NO N.LEAF : 1 SUBPAGE : N/A PAGESIZE: 4 LEVELS : 2 DSETPASS : COLUMNS : 2 DBID : X'21ED' 8,685 CLUSTERED: Y KEYLENGTH : 6 OBID : X'03F9' 1,017 CLUSTER% : 100 CLUSTER : Y ISOBID: X'03FA' 1,018 SPACE : 0K PIECESIZE : 2097152 K STATSTIME : 2016-06-27-01.24.50.860000
VERSION : 0 CURRENT VER: 0 OLDEST VER: 0 PADDED : N/A RELCREATED: O AVGKEYLEN: 6 UNIQUE COUNT: 0 HASH: NO KEY TARGET COUNT: 0 IX EXT TYPE: SIMPLE INDEX ENV ID: 0 COMPRESSION: NOT ACTIVE DATA REPEAT FACTOR F: 2 COPYLRSN: X'000000000000' SPARSE: N