Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Monitoring Your Database » The SQL Anywhere SNMP Extension Agent » RDBMS MIB reference

 

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.