| DATE_ANA |
✔ |
Date of the last check |
DB2BCKDATE |
DATS |
8 |
|
| TIME_ANA |
✔ |
Time of the last check |
DB2BCKTIME |
TIMS |
6 |
|
| DBNAM |
✔ |
Database name |
DB2DBNAME |
CHAR |
8 |
|
| TSNAM |
✔ |
Name of the tablespace |
DB2TSNAME |
CHAR |
8 |
|
| TSPART |
✔ |
Partition number |
DB2PARTNRS |
INT2 |
5 |
|
| NAME |
|
Name of the tablespace |
DB2TSNAME |
CHAR |
8 |
|
| CREATOR |
|
DB2 creator name |
DB2CREATOR |
CHAR |
8 |
|
| BPOOL |
|
DB2 buffer pool name |
DB2BPNAME |
CHAR |
8 |
|
| LOCKRULE |
|
Lock size of the tablespace |
DB2LRULE |
CHAR |
1 |
|
| LOCKMAX |
|
Maximum number of locks per user before escalating |
DB2LMAX |
INT4 |
10 |
|
| CLOSERULE |
|
Data sets for closure when limit of open data sets reached |
DB2CRULE |
CHAR |
1 |
|
| ENCODING |
|
Default encoding scheme of the tablespace |
DB2ENCODE |
CHAR |
1 |
|
| LOCKPART |
|
Lockpart for the tablespace |
DB2LPART |
CHAR |
1 |
|
| MAXROWS |
|
Maximum number of rows that DB2 will place on a data page |
DB2MROW |
INT2 |
5 |
|
| PARTITIONS |
|
Number of partitions of the tablespace or indexspace |
DB2PART |
INT2 |
5 |
|
| TYPE |
|
Tablespace type |
DB2TYPE |
CHAR |
1 |
|
| SEGSIZE |
|
Number of pages in each segment of a segmented tablespace |
DB2SSIZE |
INT2 |
5 |
|
| SPACE |
|
Number of KB of DASD Storage Allocated to Tablespace |
DB2SPACE |
INT4 |
10 |
|
| NTABLES |
|
Number of tables defined in the tablespace |
DB2NTAB |
INT2 |
5 |
|
| STATUS |
|
Availability status of tablespace |
DB2STATS |
CHAR |
1 |
|
| STATSTIME |
|
Date and time of last RUNSTATS |
DB2STATSTM |
CHAR |
26 |
|
| ERASERULE |
|
Datasets are to be erased when dropped |
DB2ERULE |
CHAR |
1 |
|
| DBNAME |
|
Database name |
DB2DBNAME |
CHAR |
8 |
|
| DSETPASS |
|
The password for the datasets of the tablespace |
DB2DPASS |
CHAR |
8 |
|
| LOG |
|
Whether the changes to a tablespace are to be logged |
DB2LOG |
CHAR |
1 |
|
| DSSIZE |
|
Maximum size of a dataset in KBytes |
DB2DSIZE |
INT4 |
10 |
|
| PARTNR |
|
Partition number |
DB2PARTNRS |
INT2 |
5 |
|
| OPERATION |
|
Date and time of last RUNSTATS |
DB2STATSTM |
CHAR |
26 |
|
| NDAYS |
|
Number of days since last invocation |
DB2DAYS |
INT4 |
10 |
|
| PERCOFFPOS |
|
Different of far and near optimal position in page |
DB2OFFPOS |
INT2 |
5 |
|
| PERCINDREF |
|
Different of far and near relocated position in page |
DB2INDREF |
INT2 |
5 |
|
| PERCDROP |
|
Percentage of space occupied by rows of dropped tables |
DB2CDROP |
INT2 |
5 |
|
| EXTENTS |
|
Number of extents of a tablespace |
DB2EXTENT |
INT4 |
10 |
|
| REASON |
|
Reason running utility is recommended |
DB2REASON |
CHAR |
18 |
|