This view contains information for every user table/file/member.
Fields
Field Type Length Text TABSCHEMA VARCHAR 128 TABLE_SCHEMA / Library name TABNAME VARCHAR 128 TABLE_NAME / Long file name PARTTYPE CHARACTER 1 PARTITION_TYPE NBRPARTS INTEGER 9 NUMBER_PARTITIONS DSTPARTS INTEGER 9 NUMBER_DISTRIBUTED_PARTITIONS CARD BIGINT 18 NUMBER_ROWS NPAGES BIGINT 18 NUMBER_ROW_PAGES FPAGES BIGINT 18 Same as NUMBER_ROW_PAGES OVERFLOW BIGINT 18 CLUSTERED CHARACTER 1 Will always be null ACTBLOCKS BIGINT 18 Will always be -1 ACROWSIZE BIGINT 18 Will always be -1 ACROWRATIO FLOAT 9/8 Will always be -1 AVGROWSIZE BIGINT 18 PCTCROWS FLOAT 9/8 Will always be -1 PCTPGSAVED SMALLINT 4 Will always be -1 DELETED BIGINT 18 NUMBER_DELETED__ROWS SIZE BIGINT 18 DATA_SIZE VLSIZE BIGINT 18 VARIABLE_LENGTH_SIZE FLEXTENS BIGINT 18 Will always be -1 VLEXTENS BIGINT 18 Will always be -1 CSTATSSIZE BIGINT 18 COLUMN_STATS_SIZE MTISIZE BIGINT 18 DISTINCTIX INTEGER 9 NUMBER_DISTINCT_INDEXES OPENS BIGINT 18 OPEN_OPERATIONS CLOSES BIGINT 18 CLOSE_OPERATIONS INSERTS BIGINT 18 INSERT_OPERATIONS UPDATES BIGINT 18 UPDATE_OPERATIONS DELETES BIGINT 18 DELETE_OPERATIONS DSCLEARS BIGINT 18 CLEAR_OPERATIONS DSCOPIES BIGINT 18 COPY_OPERATIONS DSREORGS BIGINT 18 REORGANIZE_OPERATIONS DSINXBLDS BIGINT 18 INDEX_BUILDS LGLREADS BIGINT 18 LOGICAL_READS PHYREADS BIGINT 18 PHYSICAL_READS SEQREADS BIGINT 18 SEQUENTIAL_READS RANREADS BIGINT 18 RANDOM_READS LASTCHG TIMESTAMP 26/6 LAST_CHANGE_TIMESTAMP LASTSAVE TIMESTAMP 26/6 LAST_SAVE_TIMESTAMP LASTRST TIMESTAMP 26/6 LAST_RESTORE_TIMESTAMP LASTUSED TIMESTAMP 26/6 LAST_USED_TIMESTAMP DAYSUSED INTEGER 9 DAYS_USED_COUNT LASTRESET TIMESTAMP 26/6 LAST_RESET_TIMESTAMP NBRPKEYS INTEGER 9 NUMBER_PARTITIONING_KEYS PARTKEYS VARCHAR 2880 PARTITIONING_KEYS "VOLATILE" CHARACTER 1 SYS_DNAME CHARACTER 10 SYSTEM_TABLE_SCHEMA / Library name SYS_TNAME CHARACTER 10 SYSTEM_TABLE_NAME / File name