Table and Table Space Data
This section of the Explain report shows information for the accessed table and its corresponding table space.
The data is derived from the SYSIBM.SYSTABLES and SYSIBM.SYSTABLESPACE tables.
For details on how to specify EXPLAIN commands refer to the Report Command Reference.
Explain Report - Table Data Block
This is an example of the Explain Table Data section.
TABLE: SYSIBM.SYSPACKAGE ------------------------------------------------------
STATSTIME: 2016-02-16-14.45.54.186869, TB TYPE : TABLE
CREATED : 2013-04-01-00.00.00.000000, ALTERED : 2010-07-01-09.00.57.417442
ROWS : 885, COLUMNS : 60, ROWLENGTH: 3913, EDIT PROC.:
% PAGES : 16, DBASE ID: 6, AUDITING : NONE, VALIDPROC.:
ACT.PAGES: 62, TABLE ID: 128, STATUS : COMPX, TABCREATOR: SYSIBM
TAB.STAT.: , ENC.SCHEME: UNICODE
TABLESPACE: DSNDB06.SYSTSPKG --------------------------------------------------
NAME : SYSTSPKG , DATABASE : DSNDB06
CREATOR : SYSIBM , CREATED BY: SYSIBM
CREATED : 2013-02-15-13.39.20.690282, ALTERED : 2010-02-15-13.39.20.690282
STATSTIME : 2016-02-16-14.45.54.186869,
ACTIVE PGS: 372, DBASE ID : 6, TS STATUS : A, TS TYPE : G
PAGE SIZE : 4KB, OBJ ID : 2067, ERASERULE : NO, STORGROUP :
SPACE : 1.720M, PAGESET ID: 2068, CLOSERULE : NO, BUF.POOL : BP0
DS SIZE : 68.719G, OLD VERS : 0, LOCKPART : N/A, ENC.SCHEME: UNICODE
LOCKMAX : SYSTEM, CUR VERS : 1, LOCKRULE : ROW, SBCS CCSID: 367
TABLES/TS : 1, PARTITIONS: 1, LOG : YES, DBCS CCSID: 1200
MAXROWS : 255, SEG SIZE : 32, IMPLICIT : NO, MIX. CCSID: 1208
AVG ROWLEN: 201,If table space scan has been selected as the access path method, and INDEX(NO) is not specified, a separate block is presented for each available index on the subject table along with information about key columns.
See Index Data and Key Data for the layout of these blocks.