CA RC/Query for DB2 for Z/OS: Index Detail Inquiry , Partitioned Index Runstats Fields

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

PARTITION :    0 OF 0    PRIQTY  : 12K            N.ROWS   : 4
STORTYPE  : I            SECQTY  : 12K            FAROFF   : 0             0%
STORNAME  : SYSDEFLT     FREEPAGE: 0              NEAROFF  : 0             0%

Second screen if the index is partitioned and runstats has been run:

CREATED   : 2010/04/13 / 14:00:29         ALTERED: 2010/04/13 / 14:00:29

LIMITKEY  :

FIRST KEY : 32            N.LEAF  : 1             KEY COUNT: 32
FULL KEY  : 32            LEVELS  : 2             CLUSTER% : 100
STATSTIME : 2010-04-13-14.02.53.177620

DSNUM   : 1                          EXTENTS : 1
LEAFNEAR: 0                          LEAFFAR : 0
PSEUDO_DEL_ENTRIES: 0                SPACEF  : 720

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

Additional Information

Index Reports