V8 Tablespacestats From V8 – 9 Changed "DBNAME" CHAR(8) NOT NULL VARCHAR(24) "NAME" CHAR(8) NOT NULL VARCHAR(24) "PARTITION" SMALLINT NOT NULL "DBID" SMALLINT NOT NULL "PSID" SMALLINT NOT NULL "UPDATESTATSTIME" TIMESTAMP NOT NULL "TOTALROWS" FLOAT(53) BIGINT "NACTIVE" INTEGER "SPACE" INTEGER BIGINT "EXTENTS" SMALLINT "LOADRLASTTIME" TIMESTAMP "REORGLASTTIME" TIMESTAMP "REORGINSERTS" INTEGER "REORGDELETES" INTEGER "REORGUPDATES" INTEGER "REORGUNCLUSTINS" INTEGER "REORGDISORGLOB" INTEGER "REORGMASSDELETE" INTEGER "REORGNEARINDREF" INTEGER "REORGFARINDREF" INTEGER "STATSLASTTIME" TIMESTAMP "STATSINSERTS" INTEGER "STATSDELETES" INTEGER "STATSUPDATES" INTEGER "STATSMASSDELETE" INTEGER "COPYLASTTIME" TIMESTAMP "COPYUPDATEDPAGES" INTEGER "COPYCHANGES" INTEGER "COPYUPDATELRSN" CHAR(6) "COPYUPDATETIME" TIMESTAMP V9 Systablespacestats "IBMREQD" CHAR(1) NOT NULL "NPAGES" INTEGER "INSTANCE" SMALLINT NOT NULL "DATASIZE" BIGINT "UNCOMPRESSEDDATASIZE" BIGINT This column is not actually used! It is always zero V10 Systablespacestats "REORGCLUSTERSENS" BIGINT "REORGSCANACCESS" BIGINT "REORGHASHACCESS" BIGINT "HASHLASTUSED" DATE "DRIVETYPE" CHAR(3) NOT NULL "LPFACILITY" CHAR(1) "STATS01" BIGINT V8 Indexspacestats From V8 – 9 Changed "DBNAME" CHAR(8) NOT NULL VARCHAR(24) "INDEXSPACE" CHAR(8) NOT NULL VARCHAR(24) "PARTITION" SMALLINT NOT NULL "DBID" SMALLINT NOT NULL "ISOBID" SMALLINT NOT NULL "PSID" SMALLINT NOT NULL "UPDATESTATSTIME" TIMESTAMP NOT NULL "TOTALENTRIES" FLOAT(53) BIGINT "NLEVELS" SMALLINT "NACTIVE" INTEGER "SPACE" INTEGER "EXTENTS" SMALLINT "LOADRLASTTIME" TIMESTAMP "REBUILDLASTTIME" TIMESTAMP "REORGLASTTIME" TIMESTAMP "REORGINSERTS" INTEGER "REORGDELETES" INTEGER "REORGAPPENDINSERT" INTEGER "REORGPSEUDODELETES" INTEGER "REORGMASSDELETE" INTEGER "REORGLEAFNEAR" INTEGER "REORGLEAFFAR" INTEGER "REORGNUMLEVELS" INTEGER "STATSLASTTIME" TIMESTAMP "STATSINSERTS" INTEGER "STATSDELETES" INTEGER "STATSMASSDELETE" INTEGER "COPYLASTTIME" TIMESTAMP "COPYUPDATEDPAGES" INTEGER "COPYCHANGES" INTEGER "COPYUPDATELRSN" CHAR(6) "COPYUPDATETIME" TIMESTAMP V9 Sysindexspacestats "LASTUSED" DATE "IBMREQD" CHAR(1) NOT NULL "NPAGES" INTEGER "NLEAF" INTEGER "INSTANCE" SMALLINT NOT NULL "NAME" VARCHAR(128) NOT NULL "CREATOR" VARCHAR(128) NOT NULL V10 Sysindexspacestats "REORGINDEXACCESS" BIGINT "DRIVETYPE" CHAR(3) NOT NULL "STATS101" BIGINT