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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » RDBMS MIB Reference » The RDBMS MIB

rdbmsDbTable Next Page

rdbmsDbInfoTable


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

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

OIDTypeNameValue returned
1.3.6.1.2.1.39.1.2.1.1.dbStringrdbmsDbInfoProductNamePROPERTY( 'ProductName' )
1.3.6.1.2.1.39.1.2.1.2.dbStringrdbmsDbInfoVersionPROPERTY( 'ProductVersion' )
1.3.6.1.2.1.39.1.2.1.3.dbIntegerrdbmsDbInfoSizeUnits

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.dbIntegerrdbmsDbInfoSizeAllocatedDB_PROPERTY( 'PageSize' ) * DB_PROPERTY( 'FileSize' )
1.3.6.1.2.1.39.1.2.1.5.dbIntegerrdbmsDbInfoSizeUsedDB_PROPERTY( 'PageSize' ) * (DB_PROPERTY( 'FileSize' ) - DB_PROPERTY( 'FreePages' ) )
1.3.6.1.2.1.39.1.2.1.6.dbStringrdbmsDbInfoLastBackup NULL1

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