BMCATSnn.RS_TABLEPART

DBNAME

CHAR(8)

Y

Name of the data base that contains the table space

TSNAME

CHAR(8)

Y

Name of the table space

PARTITION

SMALLINT

Y

Partition of the table space or 0 if the table space is not partitioned

CARD

FLOAT(53) (8 bytes)

Y

Number of rows in the partition

FARINDREF

INTEGER

Y

Number of referenced rows that have been relocated to more than 16 pages from their original page

NEARINDREF

INTEGER

Y

Number of referenced rows that have been relocated to within 16 pages from their original page

AVGINDREF_DISTANCE

INTEGER

N

Reserved for future use

PERCACTIVE

SMALLINT

Y

Percentage of allocated space that is occupied by rows of active tables

PERCDROP

SMALLINT

Y

Percentage of allocated space that is occupied by rows of dropped tables

NACTIVE

INTEGER

Y

Number of active pages in the partition (that is, pages that have been allocated but might not yet contain rows)

DIRTY

INTEGER

N

Number of modified pages since the last COPY

SPACE

INTEGER

N

Total number of tracks of DASD storage allocated to the partition

SPACE_KB

INTEGER

Y

Total number of kilobytes of DASD storage allocated to the partition

REORGSPACE

INTEGER

N

Number of tracks of DASD storage that would be required if the free space were reestablished at this time (that is, if the object were redefined and reorganized)

REORGSPACE_KB

INTEGER

N

Number of kilobytes of DASD storage that would be required if the free space were reestablished at this time (that is, if the object were redefined and reorganized)

PQTY

INTEGER

Y

Primary quantity of the last allocated data set in the partition or multi-data-set space in ALOCUNIT units

PQTY_USED

INTEGER

N

Reserved for future use

SQTY

INTEGER

Y

Secondary quantity of the last allocated data set in the partition or multi-data-set space in ALOCUNIT units

SQTY_USED

INTEGER

N

Reserved for future use

EXTENTS

INTEGER

N

Number of data set extents allocated to the partition

PCTFREE

SMALLINT

Y

Percentage of each page to be left as free space each time free space is reestablished

FREEPAGE

SMALLINT

Y

Number of pages to be loaded before a page is left empty each time free space is reestablished

ALOCUNIT

CHAR(1)

N

Allocation unit:

• C = cylinder
• T = track

VOLID

CHAR(6)

N

Volume of the first data set allocated to the partition or multi-data-set space

DEVTYPE

CHAR(4)

N

Device type of the first data set allocated to the partition or multi-data-set space

STORNAME

VARCHAR(128)

Y

Name of the storage group used for allocation

TIMESTMP

TIMESTAMP

Y

COMPRESS

CHAR(1)

Y

Whether to compress the table space (Y, N, or blank)

NPAGES

INTEGER

Y

Total number of pages in which rows appear

PCTPAGES

SMALLINT

Y

Percentage of active pages that contain rows of data

PCTROWCOMP

SMALLINT

Y

Percentage of compressed active rows

PAGESAVE

SMALLINT

Y

VOLCOUNT

SMALLINT

N

Total number of volumes allocated to the table space partition or multi-data-set space

VCATNAME

CHAR(8)

Y

VSAM catalog name

NDICTIONARY

INTEGER

N

Number of dictionary pages in the partition

LOCATION

CHAR(16)

N

Current server

STORTYPE

CHAR(1)

Y

Storage type:

• E = explicit (storage group not used)
• I = implicit (storage group used)

TRACKMOD

CHAR(1)

Y

Reserved for future use

IPREFIX

CHAR(1)

Y

Reserved for future use

NUMDS

INTEGER

Y

Number of data sets allocated to the partition or multi-data-set space

UTILCODE

CHAR(3)

N

A code for the utility that is generating these statistics

SPACEAVAIL_TOTAL

INTEGER

N

Reserved for future use

SPACEAVAIL_ACTIVE

INTEGER

N

Reserved for future use

ROWMAXFOUND

INTEGER

N

Largest row length found in the partition

If the table space is compressed, this value reflects the largest compressed row length found.

ROWMINFOUND

INTEGER

N

Smallest row length found in the partition

If the table space is compressed, this value reflects the smallest compressed row length found.

ROWAVG

INTEGER

N

Average row length

This value does not include the row overhead bytes.

NUM_LARGEROWS

FLOAT(53) (8 bytes)

N

Reserved for future use

NUM_SMALLROWS

FLOAT(53) (8 bytes)

N

Reserved for future use

NUM_AVGROWS

FLOAT(53) (8 bytes)

N

Reserved for future use

FULL

INTEGER

N

Number of full pages in the partition (that is, the number of pages in which the free space available is less than the minimum size of a row— in compressed format, if applicable)

FREEPGS_LGROW

INTEGER

N

Reserved for future use

FREEPGS_SMROWS

INTEGER

N

Reserved for future use

FREEPGS_AVGROWS

INTEGER

N

Reserved for future use

AVGNONCOMPROWLEN

INTEGER

N

Average row length of all uncompressed rows in the partition

If column statistics are not being collected, this value defaults to -1. If the table space or table space partition is not compressed, this value is the average row length found in the object. This value includes the row overhead bytes.

DATA_TIMESTMP

TIMESTAMP

N

Reserved for future use

AUDIT_DATA

CHAR(30)

N

Reserved for future use

TOTAL_ROW_LEN

FLOAT(8)

N

Total length of all rows

The default is -1 if the statistics are migrated from the previous release.

LAST_DS_EXTENTS

INTEGER(4)

Y

Number of extents in the last data set

The default is -1 if the statistics are migrated from the previous release.

VERSION

CHAR(8)

N

Product version

PCTUSED

SMALLINT

Y

Percentage of allocated space that is used in the partition

PQTYROWS

FLOAT(53)

(8 bytes)

Y

Maximum number of rows that can exist in the primary space allocation of the partition after a reorganization

RBA_FORMAT

CHAR(1)

N

Format indicator for RBA