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.