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

 

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.