onFragmentTable
The following list summarizes this table:
- Contents:
- Information about the fragments that are in fragmented database tables
- Index:
- applIndex, rdbmsDbIndex, onTableIndex, onFragmentIndex
- Scope of a row:
- One fragment of a fragmented database table
The table has the following MIB objects.
| MIB object | Description |
|---|---|
| applIndex | See applTable. |
| rdbmsDbIndex | See rdbmsDbTable. |
| onTableIndex | See onDbspaceTable. |
| onFragmentIndex | Unique integer index for the fragment |
| onFragmentType | Type of database table:
|
| onFragmentDbspace | Dbspace name for the fragment |
| onFragmentExpression | Expression text used for fragmentation of the
table or index This value is blank if the fragmentation scheme is round-robin. |
| onFragmentIndexName | Index identifier |
| onFragmentExtents | Number of extents used |
| onFragmentPagesAllocated | Total (extent) size allocated to the fragment, in pages |
| onFragmentPagesUsed | Number of pages used |
| onFragmentIsamReads | Number of reads from the fragment If the fragment is not active, this value is noSuchInstance (SNMPv2) or noSuchName (SNMPv1). |
| onFragmentIsamWrites | Number of writes to the fragment If the fragment is not active, this value is noSuchInstance (SNMPv2) or noSuchName (SNMPv1). |
| onFragmentUsers | Number of user threads that access the fragment. |
| onFragmentLockRequests | Number of locks of any type requested for this fragment. |
| onFragmentLockWaits | Number of times an initial lock request failed because the lock could not be granted initially for the fragment. |
| onFragmentLockTimeouts | Number of deadlock timeouts for the fragment. |