Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | DB2TBTOTALROWS |
| Short Description | Real Time Statistics: Number of rows in Table |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | FLTP | |
| Data Type | FLTP | Floating point number, accurate to 8 bytes |
| Length | 16 | |
| Decimal Places | 16 | |
| Output Length | 22 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 7 | TB Rows |
| Medium | 13 | TB Row number |
| Long | 60 | RTS: Number of rows in Table |
| Heading | 37 | RTS: Number of rows in Table |
Documentation
Definition
Starting with DB2 V7, real time statistics provide a possibility of monitoring changes in the database in real time. There are two tables, collecting statistics on tablespaces and indexspaces.
Column TOTALROWS in table SYSIBM.TABLESPACESTATS is only suited for determining the number of table rows in a single-table-tablespace, because if the table space contains more than one table, this value is the sum of all rows in all tables.
For tables in multi-table-tablespaces, the number of entries can be derived from column TOTALENTRIES in table SYSIBM.INDEXSPACESTATS for any key on the table. This works, because there is always only one index in the indexspace. Note, that for a partitioned table TOTALENTRIES for any of its non-partitioning indexes is the correct number.
If this number is small, while number of changes is high, this table is a candidate for the VOLATILE attribute.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
