rdbmsDbLimitedResourceTable

This table lists free space information on each dbspace. In this table, n represents each dbspace as follows:

  • 1-13 are for normal dbspaces (numbered 0-12 in the database)

  • 14 is the transaction log file

  • 15 is the transaction log mirror file

  • 16 is the temporary file

The value db is the database number in the sasnmp.ini file.

OID Type Name Value returned
1.3.6.1.2.1.39.1.4.1.1.n.db String rdbmsDbLimitedResourceName Name of dbspace, or Transaction Log, Transaction Log Mirror, or Temporary File.
1.3.6.1.2.1.39.1.4.1.2.n.db OID rdbmsDbLimitedResourceID 1.3.6.1.4.1.897.2
1.3.6.1.2.1.39.1.4.1.3.n.db Integer rdbmsDbLimitedResourceLimit Free space available on disk + current file size
1.3.6.1.2.1.39.1.4.1.4.n.db Integer rdbmsDbLimitedResourceCurrent Current file size
1.3.6.1.2.1.39.1.4.1.5.n.db Integer rdbmsDbLimitedResourceHighwater Current size
1.3.6.1.2.1.39.1.4.1.6.n.db Integer rdbmsDbLimitedResourceFailure 01
1.3.6.1.2.1.39.1.4.1.7.n.db String rdbmsDbLimitedResourceDescription One of Bytes, KB, MB, GB, or TB.

1 This OID is not supported by the SQL Anywhere SNMP Extension Agent.