☞ For a list of the database server statistic OIDs, see “Server statistics” on page 27.
♦ Database options
☞ For a list of the database option OIDs, see “Database options” on page 36.
♦ Database properties
☞ For a list of the database property OIDs, see “Database properties” on page 33.
| ♦ Database statistics |
|
|
| |
| ☞ For a list of the database statistic OIDs, see “Database statistics” on | ||||
| page 31. |
|
|
| |
| The way you retrieve these values will depend on your SNMP management | ||||
| software. |
|
|
| |
Examples | The table below provides a description and sample value that could be | ||||
| returned for the following OIDs. |
|
|
| |
OID |
| Explanation |
| Sample value | |
|
| ||||
|
|
|
|
|
|
1.3.6.1.4.1.897.2.1.1.1.1 |
| Server statistic ActiveReq on |
| 1 |
|
|
| database 1 |
|
|
|
1.3.6.1.4.1.897.2.1.2.1.3 |
| Server property C2 on database 3 |
| NO | |
1.3.6.1.4.1.897.2.2.1.4.1 |
| Database statistic CacheRead on |
| 11397 |
|
|
| database 1 |
|
|
|
1.3.6.1.4.1.897.2.2.2.7.4 |
| Database property CaseSensi- |
| OFF | |
|
| tivePasswords on database 4 |
|
|
|
1.3.6.1.4.1.897.2.2.3.5.2 |
| Database option ANSI_- |
| OFF | |
|
| INTEGER_OVERFLOW on |
|
|
|
|
| database 2 |
|
|
|
1.3.6.1.4.1.897.2.3.1 |
| Agent version |
| 9.0.1(1841) |
|
1.3.6.1.4.1.897.2.3.2.1 |
| Connection string for database 1 |
| UID=DBA;PWD=SQL; | |
|
|
|
| ENG=server1; DBN=sales; | |
|
|
|
| DBF=sales.db | |
|
|
|
|
|
|
16
