BMCATSnn.RS_TABLESPACE

DBNAME

CHAR(8)

Y

Name of the database that contains the table space

NAME

CHAR(8)

Y

Name of the table space

PARTITIONS

SMALLINT

Y

Number of partitions in the table space or 0 if the table space is not partitioned

NTABLES

SMALLINT

Y

Number of tables defined in the table space

SEGSIZE

SMALLINT

Y

Number of pages in the segment for this table space or 0 if the table space is not segmented

NACTIVE

FLOAT(53)

(8 bytes)

Y

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

SPACE

INTEGER

N

Total number of tracks of DASD storage allocated to the table space ¹

SPACE_KB

FLOAT(53)

(8 bytes)

Y

Number of kilobytes of DASD storage allocated to the table space ¹    

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

FLOAT(53)

(8 bytes)

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) ¹    

SPACE_AVAILABLE

FLOAT(53)

(8 bytes)

N

Reserved for future use

TIMESTMP

TIMESTAMP

Y

LOCATION

CHAR(16)

N

Current server

MAXROWS

SMALLINT

Y

Maximum number of rows that a Db2 subsystem will put on a page (where the default is 255)

TYPE

CHAR(1)

Y

Type of table space:

• L = Large
• K = Large cluster member
• I = Normal cluster member
• G = Defined with the MAXPARTITIONS option and with the underlying structure of a universal table space (UTC)
• R = range-partitioned (PBR) universal table space (UTS)
• Blank = other

ENCODING_SCHEME

CHAR(1)

Y

Encoding scheme:

• A = ASCII
• E= EBCDIC
• U = UNICODE

PGSIZE

SMALLINT

Y

Size of pages in the table space, in kilobytes

DSSIZE

INTEGER

Y

Maximum size of a data set, in kilobytes

ROWMAXFOUND

INTEGER

N

Largest row length found in the table space ¹    

If the table space is compressed, this value reflects the compressed size of the row.

ROWMINFOUND

INTEGER

N

Smallest row length found in the table space ¹    

If the table space is compressed, this value reflects the compressed size of the row.

UTILCODE

CHAR(3)

N

A code for the utility that is generating these statistics

DATA_TIMESTMP

TIMESTAMP

N

Reserved for future use

AUDIT_DATA

CHAR(30)

N

Reserved for future use

AVGROWLEN

INTEGER(4)

Y

Average row length or -1 if not calculated

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

MAXPARTITIONS

SMALLINT

Y

Maximum number of partitions to which the table space can grow

A value of 0 indicates that the table space is not partitioned by growth.

VERSION

CHAR(8)

N

Product version

MEMBER_CLUSTER

CHAR(1)

N

Whether the table space uses the MEMBER CLUSTER page set structure