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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database monitoring » The SQL Anywhere SNMP Extension Agent » RDBMS MIB reference

 

rdbmsDbInfoTable

This table provides additional information about the databases on the system.

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.2.1.1.db String rdbmsDbInfoProductName PROPERTY( 'ProductName' )
1.3.6.1.2.1.39.1.2.1.2.db String rdbmsDbInfoVersion PROPERTY( 'ProductVersion' )
1.3.6.1.2.1.39.1.2.1.3.db Integer rdbmsDbInfoSizeUnits

Calculated based on dbInfoSizeAllocated and dbInfoSizeUsed.

  • 1=bytes

  • 2=KB

  • 3=MB

  • 4=GB

  • 5=TB

(Each unit is 1024 times the previous.)

1.3.6.1.2.1.39.1.2.1.4.db Integer rdbmsDbInfoSizeAllocated DB_PROPERTY( 'PageSize' ) * DB_PROPERTY( 'FileSize' )
1.3.6.1.2.1.39.1.2.1.5.db Integer rdbmsDbInfoSizeUsed DB_PROPERTY( 'PageSize' ) * (DB_PROPERTY( 'FileSize' ) - DB_PROPERTY( 'FreePages' ) )
1.3.6.1.2.1.39.1.2.1.6.db String rdbmsDbInfoLastBackup NULL1

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