onTableTable

The following list summarizes this table:

Contents:: Information about a database table
Index:: applIndex, rdbmsDbIndex, onTableIndex
Scope of a row:: One database table

For a fragmented database table, the values in this table are summaries of the values from all the database table fragments. The table has the following MIB objects.

Table 1. MIB objects for onTableTable
MIB object	Description
applIndex	See applTable.
rdbmsDbIndex	See rdbmsDbTable.
onTableIndex	Table number This value is the same as tabid in the system catalog table systables
onTableName	Table name
onTableOwner	Table owner
onTableType	Type of table: table (1) view (2) privateSynonyn (3) synonym (4)
onTableLockLevel	Locking level of the table: page (1) row (2)
onTableCreated	Creation date, in string format
onTableFirstDbspace	Name of the first (or only) dbspace for the table
onTableRowSize	Length of a row
onTableRows	Number of rows
onTableColumns	Number of columns
onTableIndices	Number of indexes
onTableExtents	Number of extents in use
onTablePagesAllocated	Total (extent) size allocated to the table, in pages
onTablePagesUsed	Number of pages in use
onTableFragments	Number of fragments
onTableFragmentStrategy	Fragmentation strategy: roundRobin (1) byExpression (2) tableBased (3)

If the table is not fragmented, this value is noSuchInstance (SNMPv2) or noSuchName (SNMPv1).

onTableActiveFragments: Number of active fragments
If the table is not fragmented, this value is noSuchInstance (SNMPv2) or noSuchName (SNMPv1).