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:

• fragmentedIndex (1)
• fragmentedTable (2)

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.