RDBMS-MIB 54 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398
  1. RDBMS-MIB DEFINITIONS ::= BEGIN
  2. IMPORTS
  3. MODULE-IDENTITY, OBJECT-TYPE, NOTIFICATION-TYPE,
  4. OBJECT-IDENTITY, Counter32, Gauge32, Integer32
  5. FROM SNMPv2-SMI
  6. MODULE-COMPLIANCE, OBJECT-GROUP
  7. FROM SNMPv2-CONF
  8. DisplayString, DateAndTime, AutonomousType
  9. FROM SNMPv2-TC
  10. applIndex, applGroups
  11. FROM NETWORK-SERVICES-MIB
  12. mib-2
  13. FROM RFC1213-MIB;
  14. rdbmsMIB MODULE-IDENTITY
  15. LAST-UPDATED "9406150655Z"
  16. ORGANIZATION "IETF RDBMSMIB Working Group"
  17. CONTACT-INFO
  18. " David Brower
  19. Postal: The ASK Group, INGRES DBMS Development
  20. 1080 Marina Village Parkway
  21. Alameda, CA 94501
  22. US
  23. Tel: +1 510 748 3418
  24. Fax: +1 510 748 2770
  25. E-mail: daveb@ingres.com"
  26. DESCRIPTION
  27. "The MIB module to describe objects for generic relational
  28. databases."
  29. ::= { mib-2 39 }
  30. rdbmsObjects OBJECT IDENTIFIER ::= { rdbmsMIB 1 }
  31. ----------------------------------------------------------------
  32. rdbmsDbTable OBJECT-TYPE
  33. SYNTAX SEQUENCE OF RdbmsDbEntry
  34. MAX-ACCESS not-accessible
  35. STATUS current
  36. DESCRIPTION
  37. "The table of databases installed on a system."
  38. ::= { rdbmsObjects 1 }
  39. rdbmsDbEntry OBJECT-TYPE
  40. SYNTAX RdbmsDbEntry
  41. MAX-ACCESS not-accessible
  42. STATUS current
  43. DESCRIPTION
  44. "An entry for a single database on the host. Whether a
  45. particular database is represented by a row in rdbmsDbTable
  46. may be dependent on the activity level of that database,
  47. according to the product's implementation. An instance of
  48. rdbmsRelState having the value active, other, or restricted
  49. implies that an entry, corresponding to that instance, will
  50. be present."
  51. INDEX { rdbmsDbIndex }
  52. ::= { rdbmsDbTable 1 }
  53. RdbmsDbEntry ::=
  54. SEQUENCE {
  55. rdbmsDbIndex INTEGER,
  56. rdbmsDbPrivateMibOID OBJECT IDENTIFIER,
  57. rdbmsDbVendorName DisplayString,
  58. rdbmsDbName DisplayString,
  59. rdbmsDbContact DisplayString
  60. }
  61. rdbmsDbIndex OBJECT-TYPE
  62. SYNTAX INTEGER (1..2147483647)
  63. MAX-ACCESS not-accessible
  64. STATUS current
  65. DESCRIPTION
  66. "A numeric index, unique among all the databases from all
  67. products on this host. This value is a surrogate for the
  68. conceptually unique key, which is {PrivateMibOID,
  69. databasename}"
  70. ::= { rdbmsDbEntry 1 }
  71. rdbmsDbPrivateMibOID OBJECT-TYPE
  72. SYNTAX OBJECT IDENTIFIER
  73. MAX-ACCESS read-only
  74. STATUS current
  75. DESCRIPTION
  76. "The authoritative identification for the private MIB for
  77. this database, presumably based on the vendor, e.g., {
  78. enterprises 111 <optional subidentifiers>} for Oracle
  79. databases, {enterprises 757 <optional subidentifiers>} for
  80. Ingres databases, { enterprises 897 <optional
  81. subidentifiers>} for Sybase databases, etc.
  82. If no OBJECT IDENTIFIER exists for the private MIB, attempts
  83. to access this object will return noSuchName (SNMPv1)
  84. or noSuchInstance (SNMPv2)."
  85. ::= { rdbmsDbEntry 2 }
  86. rdbmsDbVendorName OBJECT-TYPE
  87. SYNTAX DisplayString
  88. MAX-ACCESS read-only
  89. STATUS current
  90. DESCRIPTION
  91. "The name of the vendor whose RDBMS manages this database,
  92. for informational purposes."
  93. ::= { rdbmsDbEntry 3 }
  94. rdbmsDbName OBJECT-TYPE
  95. SYNTAX DisplayString
  96. MAX-ACCESS read-only
  97. STATUS current
  98. DESCRIPTION
  99. "The name of this database, in a product specific format. The
  100. product may need to qualify the name in some way to resolve
  101. conflicts if it is possible for a database name to be
  102. duplicated on a host. It might be necessary to construct a
  103. hierarchical name embedding the RDBMS instance/installation
  104. on the host, and/or the owner of the database. For instance,
  105. '/test-installation/database-owner/database-name'."
  106. ::= { rdbmsDbEntry 4 }
  107. rdbmsDbContact OBJECT-TYPE
  108. SYNTAX DisplayString
  109. MAX-ACCESS read-write
  110. STATUS current
  111. DESCRIPTION
  112. "The textual identification of the contact person for this
  113. managed database, together with information on how to contact
  114. this person.
  115. Note: if there is no server associated with this database, an
  116. agent may need to keep this in other persistent storage,
  117. e.g., a configuration file.
  118. Note that a compliant agent does not need to
  119. allow write access to this object."
  120. ::= { rdbmsDbEntry 5 }
  121. ----------------------------------------------------------------
  122. rdbmsDbInfoTable OBJECT-TYPE
  123. SYNTAX SEQUENCE OF RdbmsDbInfoEntry
  124. MAX-ACCESS not-accessible
  125. STATUS current
  126. DESCRIPTION
  127. "The table of additional information about databases present
  128. on the host."
  129. ::= { rdbmsObjects 2 }
  130. rdbmsDbInfoEntry OBJECT-TYPE
  131. SYNTAX RdbmsDbInfoEntry
  132. MAX-ACCESS not-accessible
  133. STATUS current
  134. DESCRIPTION
  135. "Information that must be present if the database is actively
  136. opened. If the database is not actively opened, then
  137. attempts to access corresponding instances in this table may
  138. result in either noSuchName (SNMPv1) or noSuchInstance
  139. (SNMPv2). 'Actively opened' means at least one of the
  140. rdbmsRelState entries for this database in the rdbmsRelTable
  141. is active(2)."
  142. INDEX { rdbmsDbIndex }
  143. ::= { rdbmsDbInfoTable 1 }
  144. RdbmsDbInfoEntry ::=
  145. SEQUENCE {
  146. rdbmsDbInfoProductName DisplayString,
  147. rdbmsDbInfoVersion DisplayString,
  148. rdbmsDbInfoSizeUnits INTEGER,
  149. rdbmsDbInfoSizeAllocated INTEGER,
  150. rdbmsDbInfoSizeUsed INTEGER,
  151. rdbmsDbInfoLastBackup DateAndTime
  152. }
  153. rdbmsDbInfoProductName OBJECT-TYPE
  154. SYNTAX DisplayString
  155. MAX-ACCESS read-only
  156. STATUS current
  157. DESCRIPTION
  158. "The textual product name of the server that created or last
  159. restructured this database. The format is product specific."
  160. ::= { rdbmsDbInfoEntry 1 }
  161. rdbmsDbInfoVersion OBJECT-TYPE
  162. SYNTAX DisplayString
  163. MAX-ACCESS read-only
  164. STATUS current
  165. DESCRIPTION
  166. "The version number of the server that created or last
  167. restructured this database. The format is product specific."
  168. ::= { rdbmsDbInfoEntry 2 }
  169. rdbmsDbInfoSizeUnits OBJECT-TYPE
  170. SYNTAX INTEGER {
  171. bytes(1),
  172. kbytes(2),
  173. mbytes(3),
  174. gbytes(4),
  175. tbytes(5)
  176. }
  177. MAX-ACCESS read-only
  178. STATUS current
  179. DESCRIPTION
  180. "Identification of the units used to measure the size of this
  181. database in rdbmsDbInfoSizeAllocated and rdbmsDbInfoSizeUsed.
  182. bytes(1) indicates individual bytes, kbytes(2) indicates
  183. units of kilobytes, mbytes(3) indicates units of megabytes,
  184. gbytes(4) indicates units of gigabytes, and tbytes(5)
  185. indicates units of terabytes. All are binary multiples -- 1K
  186. = 1024. If writable, changes here are reflected in the get
  187. values of the associated objects."
  188. ::= { rdbmsDbInfoEntry 3 }
  189. rdbmsDbInfoSizeAllocated OBJECT-TYPE
  190. SYNTAX INTEGER (1..2147483647)
  191. MAX-ACCESS read-write
  192. STATUS current
  193. DESCRIPTION
  194. "The estimated size of this database (in
  195. rdbmsDbInfoSizeUnits), which is the disk space that has been
  196. allocated to it and is no longer available to users on this
  197. host. rdbmsDbInfoSize does not necessarily indicate the
  198. amount of space actually in use for database data. Some
  199. databases may support extending allocated size, and others
  200. may not.
  201. Note that a compliant agent does not need to
  202. allow write access to this object."
  203. -- Note: computing SizeAllocated may be expensive, and SNMP
  204. -- agents might cache the value to increase performance.
  205. ::= { rdbmsDbInfoEntry 4 }
  206. rdbmsDbInfoSizeUsed OBJECT-TYPE
  207. SYNTAX INTEGER (1..2147483647)
  208. MAX-ACCESS read-only
  209. STATUS current
  210. DESCRIPTION
  211. "The estimated size of this database, in rdbmsDbInfoSizeUnits,
  212. which is actually in use for database data."
  213. -- Note: computing SizeUsed may be expensive, and SNMP
  214. -- agents might cache the value to increase performance.
  215. ::= { rdbmsDbInfoEntry 5 }
  216. rdbmsDbInfoLastBackup OBJECT-TYPE
  217. SYNTAX DateAndTime
  218. MAX-ACCESS read-only
  219. STATUS current
  220. DESCRIPTION
  221. "The date and time that the latest complete or partial backup
  222. of the database was taken. If a database has never been
  223. backed up, then attempts to access this object will
  224. result in either noSuchName (SNMPv1) or noSuchInstance
  225. (SNMPv2)."
  226. ::= { rdbmsDbInfoEntry 6 }
  227. ----------------------------------------------------------------
  228. rdbmsDbParamTable OBJECT-TYPE
  229. SYNTAX SEQUENCE OF RdbmsDbParamEntry
  230. MAX-ACCESS not-accessible
  231. STATUS current
  232. DESCRIPTION
  233. "The table of configuration parameters for a database.
  234. Entries should be populated according to the following
  235. guidelines:
  236. (1) The value should be specified through administrative
  237. (human) intervention.
  238. (2) It should be configured on a per-database basis.
  239. (3) One of the following is true:
  240. (a) The parameter has a non-numeric value;
  241. (b) The current value is numeric, but it only changes due
  242. to human intervention;
  243. (c) The current value is numeric and dynamic, but the
  244. RDBMS does not track access/allocation failures
  245. related to the parameter;
  246. (d) The current value is numeric and dynamic, the
  247. RDBMS tracks changes in access/allocation failures
  248. related to the parameter, but the failure has no
  249. significant impact on RDBMS performance or
  250. availability.
  251. (e) The current value is numeric and dynamic, the
  252. RDBMS tracks changes in access/allocation failures
  253. related to the parameter, the failure has
  254. significant impact on RDBMS performance or
  255. availability, and is shown in the
  256. rdbmsDbLimitedResource table."
  257. ::= { rdbmsObjects 3 }
  258. rdbmsDbParamEntry OBJECT-TYPE
  259. SYNTAX RdbmsDbParamEntry
  260. MAX-ACCESS not-accessible
  261. STATUS current
  262. DESCRIPTION
  263. "An entry for a single configuration parameter for a database.
  264. Parameters with single values have a subindex value of one.
  265. If the parameter is naturally considered to contain a
  266. variable number of members of a class, e.g. members of the
  267. DBA user group, or files which are part of the database, then
  268. it must be presented as a set of rows. If, on the other
  269. hand, the parameter represents a set of choices from a class,
  270. e.g. the permissions on a file or the options chosen out of
  271. the set of all options allowed, AND is guaranteed to always
  272. fit in the 255 character length of a DisplayString, then it
  273. may be presented as a comma separated list with a subindex
  274. value of one. Zero may not be used as a subindex value.
  275. If the database is not actively opened, then attempts
  276. to access corresponding instances in this table may result in
  277. either noSuchName (SNMPv1) or noSuchInstance (SNMPv2).
  278. 'Actively opened' means at least one of the
  279. rdbmsRelState entries for this database in the rdbmsRelTable
  280. is active(2)."
  281. INDEX { rdbmsDbIndex, rdbmsDbParamName, rdbmsDbParamSubIndex }
  282. ::= { rdbmsDbParamTable 1 }
  283. RdbmsDbParamEntry ::=
  284. SEQUENCE {
  285. rdbmsDbParamName DisplayString,
  286. rdbmsDbParamSubIndex INTEGER,
  287. rdbmsDbParamID AutonomousType,
  288. rdbmsDbParamCurrValue DisplayString,
  289. rdbmsDbParamComment DisplayString
  290. }
  291. rdbmsDbParamName OBJECT-TYPE
  292. SYNTAX DisplayString (SIZE (1..64))
  293. MAX-ACCESS not-accessible
  294. STATUS current
  295. DESCRIPTION
  296. "The name of a configuration parameter for a database. This
  297. name is product-specific. The length is limited to 64
  298. characters to constrain the number of sub-identifiers needed
  299. for instance identification (and to minimize network
  300. traffic)."
  301. ::= { rdbmsDbParamEntry 1 }
  302. rdbmsDbParamSubIndex OBJECT-TYPE
  303. SYNTAX INTEGER (1..2147483647)
  304. MAX-ACCESS not-accessible
  305. STATUS current
  306. DESCRIPTION
  307. "The subindex value for this parameter. If the parameter is
  308. naturally considered to contain a variable number of members
  309. of a class, e.g. members of the DBA user group, or files
  310. which are part of the database, then it must be presented as
  311. a set of rows. If, on the other hand, the parameter
  312. represents a set of choices from a class, e.g. the
  313. permissions on a file or the options chosen out of the set of
  314. all options allowed, AND is guaranteed to always fit in the
  315. 255 character length of a DisplayString, then it may be
  316. presented as a comma separated list with a subindex value of
  317. one. Zero may not be used as a value."
  318. ::= { rdbmsDbParamEntry 2 }
  319. rdbmsDbParamID OBJECT-TYPE
  320. SYNTAX AutonomousType
  321. MAX-ACCESS read-only
  322. STATUS current
  323. DESCRIPTION
  324. "The ID of the parameter which may be described in some other
  325. MIB (e.g., an enterprise-specific MIB module). If there is
  326. no ID for this rdbmsDbParamName, attempts to access this
  327. object will return noSuchName (SNMPv1) or noSuchInstance
  328. (SNMPv2)."
  329. ::= { rdbmsDbParamEntry 3 }
  330. rdbmsDbParamCurrValue OBJECT-TYPE
  331. SYNTAX DisplayString
  332. MAX-ACCESS read-write
  333. STATUS current
  334. DESCRIPTION
  335. "The value for a configuration parameter now in effect, the
  336. actual setting for the database. While there may multiple
  337. values in the temporal domain of interest (for instance, the
  338. value to take effect at the next restart), this is the
  339. current setting.
  340. Note that a compliant agent does not need to
  341. allow write access to this object."
  342. ::= { rdbmsDbParamEntry 4 }
  343. rdbmsDbParamComment OBJECT-TYPE
  344. SYNTAX DisplayString
  345. MAX-ACCESS read-write
  346. STATUS current
  347. DESCRIPTION
  348. "Annotation which describes the purpose of a configuration
  349. parameter or the reason for a particular parameter's
  350. setting.
  351. Note that a compliant agent does not need to
  352. allow write access to this object."
  353. ::= { rdbmsDbParamEntry 5 }
  354. ----------------------------------------------------------------
  355. rdbmsDbLimitedResourceTable OBJECT-TYPE
  356. SYNTAX SEQUENCE OF RdbmsDbLimitedResourceEntry
  357. MAX-ACCESS not-accessible
  358. STATUS current
  359. DESCRIPTION
  360. "The table of limited resources that are kept per-database."
  361. ::= { rdbmsObjects 4 }
  362. rdbmsDbLimitedResourceEntry OBJECT-TYPE
  363. SYNTAX RdbmsDbLimitedResourceEntry
  364. MAX-ACCESS not-accessible
  365. STATUS current
  366. DESCRIPTION
  367. "An entry for a single limited resource kept per-database.
  368. A limited resource has maximum use determined by a parameter
  369. that might or might not be changeable at run time, or visible
  370. in the rdbmsDbParamTable. Examples would be the number of
  371. available locks, or disk space on a partition. Arrays of
  372. resources are supported through an integer sub index, which
  373. should have the value of one for single-instance names.
  374. Limited resources that are shared across databases, are best
  375. put in the rdbmsSvrLimitedResourceTable instead of this one.
  376. If the database is not actively opened, then attempts to
  377. access corresponding instances in this table may result in
  378. either noSuchName (SNMPv1) or noSuchInstance (SNMPv2).
  379. 'Actively opened' means at least one of the rdbmsRelState
  380. entries for this database in the rdbmsRelTable is active(2)."
  381. INDEX { rdbmsDbIndex, rdbmsDbLimitedResourceName }
  382. ::= { rdbmsDbLimitedResourceTable 1 }
  383. RdbmsDbLimitedResourceEntry ::=
  384. SEQUENCE {
  385. rdbmsDbLimitedResourceName DisplayString,
  386. rdbmsDbLimitedResourceID AutonomousType,
  387. rdbmsDbLimitedResourceLimit INTEGER,
  388. rdbmsDbLimitedResourceCurrent INTEGER,
  389. rdbmsDbLimitedResourceHighwater INTEGER,
  390. rdbmsDbLimitedResourceFailures Counter32,
  391. rdbmsDbLimitedResourceDescription DisplayString
  392. }
  393. rdbmsDbLimitedResourceName OBJECT-TYPE
  394. SYNTAX DisplayString
  395. MAX-ACCESS not-accessible
  396. STATUS current
  397. DESCRIPTION
  398. "The name of the resource, for instance 'global locks' or
  399. 'locks for the FOO database', or 'data space on /dev/rdsk/5s0
  400. for FOO'. The length is limited to 64 characters to constrain
  401. the number of sub-identifiers needed for instance
  402. identification (and to minimize network traffic)."
  403. ::= { rdbmsDbLimitedResourceEntry 1 }
  404. rdbmsDbLimitedResourceID OBJECT-TYPE
  405. SYNTAX AutonomousType
  406. MAX-ACCESS read-only
  407. STATUS current
  408. DESCRIPTION
  409. "The ID of the resource which may be described in some other
  410. MIB (e.g., an enterprise-specific MIB module). If there is
  411. no ID for this rdbmsDbLimitedResourceName, attempts to access
  412. this object will return noSuchName (SNMPv1) or noSuchInstance
  413. (SNMPv2)."
  414. ::= { rdbmsDbLimitedResourceEntry 2 }
  415. rdbmsDbLimitedResourceLimit OBJECT-TYPE
  416. SYNTAX INTEGER (1..2147483647)
  417. MAX-ACCESS read-write
  418. STATUS current
  419. DESCRIPTION
  420. "The maximum value the resource use may attain.
  421. Note that a compliant agent does not need to
  422. allow write access to this object."
  423. ::= { rdbmsDbLimitedResourceEntry 3 }
  424. rdbmsDbLimitedResourceCurrent OBJECT-TYPE
  425. SYNTAX INTEGER (1..2147483647)
  426. MAX-ACCESS read-only
  427. STATUS current
  428. DESCRIPTION
  429. "The current value for the resource."
  430. ::= { rdbmsDbLimitedResourceEntry 4 }
  431. rdbmsDbLimitedResourceHighwater OBJECT-TYPE
  432. SYNTAX INTEGER (1..2147483647)
  433. MAX-ACCESS read-only
  434. STATUS current
  435. DESCRIPTION
  436. "The maximum value of the resource seen since applUpTime
  437. was reset for the earliest server which has the database
  438. actively opened.
  439. If there are two servers with the database open, and the
  440. oldest one dies, the proper way to invalidate the value is by
  441. resetting sysUpTime."
  442. ::= { rdbmsDbLimitedResourceEntry 5 }
  443. rdbmsDbLimitedResourceFailures OBJECT-TYPE
  444. SYNTAX Counter32
  445. MAX-ACCESS read-only
  446. STATUS current
  447. DESCRIPTION
  448. "The number of times the system wanted to exceed the limit of
  449. the resource since applUpTime was reset for the earliest
  450. server which has the database actively opened.
  451. If there are two servers with the DB open, and the
  452. oldest one dies, the proper way to invalidate the value is by
  453. resetting sysUpTime."
  454. ::= { rdbmsDbLimitedResourceEntry 6 }
  455. rdbmsDbLimitedResourceDescription OBJECT-TYPE
  456. SYNTAX DisplayString
  457. MAX-ACCESS read-write
  458. STATUS current
  459. DESCRIPTION
  460. "A description of the resource and the meaning of the integer
  461. units used for Limit, Current, and Highwater.
  462. Note that a compliant agent does not need to
  463. allow write access to this object."
  464. ::= { rdbmsDbLimitedResourceEntry 7 }
  465. ----------------------------------------------------------------
  466. rdbmsSrvTable OBJECT-TYPE
  467. SYNTAX SEQUENCE OF RdbmsSrvEntry
  468. MAX-ACCESS not-accessible
  469. STATUS current
  470. DESCRIPTION
  471. "The table of database servers running or installed
  472. on a system."
  473. ::= { rdbmsObjects 5 }
  474. rdbmsSrvEntry OBJECT-TYPE
  475. SYNTAX RdbmsSrvEntry
  476. MAX-ACCESS not-accessible
  477. STATUS current
  478. DESCRIPTION
  479. "An entry for a single database server. A server is an
  480. independent entity that provides access to one or more
  481. databases. Failure of one does not affect access to
  482. databases through any other servers. There might be one or
  483. more servers providing access to a database. A server may be
  484. a 'process' or collection of 'processes', as interpreted by
  485. the product."
  486. INDEX { applIndex }
  487. ::= { rdbmsSrvTable 1 }
  488. RdbmsSrvEntry ::=
  489. SEQUENCE {
  490. rdbmsSrvPrivateMibOID OBJECT IDENTIFIER,
  491. rdbmsSrvVendorName DisplayString,
  492. rdbmsSrvProductName DisplayString,
  493. rdbmsSrvContact DisplayString
  494. }
  495. rdbmsSrvPrivateMibOID OBJECT-TYPE
  496. SYNTAX OBJECT IDENTIFIER
  497. MAX-ACCESS read-only
  498. STATUS current
  499. DESCRIPTION
  500. "The authoritative identification for the private MIB for this
  501. server, presumably based on the vendor, e.g., { enterprises
  502. 111 <optional subidentifiers>} for Oracle servers, {
  503. enterprises 757 <optional subidentifiers>} for Ingres
  504. servers, { enterprises 897 <optional subidentifiers>} for
  505. Sybase servers, etc.
  506. If no OBJECT IDENTIFIER exists for the private MIB, attempts
  507. to access this object will return noSuchName (SNMPv1)
  508. or noSuchInstance (SNMPv2)."
  509. ::= { rdbmsSrvEntry 1 }
  510. rdbmsSrvVendorName OBJECT-TYPE
  511. SYNTAX DisplayString
  512. MAX-ACCESS read-only
  513. STATUS current
  514. DESCRIPTION
  515. "The name of the vendor whose RDBMS manages this database,
  516. for informational purposes."
  517. ::= { rdbmsSrvEntry 2 }
  518. rdbmsSrvProductName OBJECT-TYPE
  519. SYNTAX DisplayString
  520. MAX-ACCESS read-only
  521. STATUS current
  522. DESCRIPTION
  523. "The product name of this server. This is normally the
  524. vendor's formal name for the product, in product specific
  525. format."
  526. ::= { rdbmsSrvEntry 3 }
  527. rdbmsSrvContact OBJECT-TYPE
  528. SYNTAX DisplayString
  529. MAX-ACCESS read-write
  530. STATUS current
  531. DESCRIPTION
  532. "The textual identification of the contact person for this
  533. managed server, together with information on how to contact
  534. this person.
  535. Note: if there is no active server associated with this
  536. object, an agent may need to keep this in other persistent
  537. storage, e.g., a configuration file.
  538. Note that a compliant agent does not need to
  539. allow write access to this object."
  540. ::= { rdbmsSrvEntry 4 }
  541. ----------------------------------------------------------------
  542. rdbmsSrvInfoTable OBJECT-TYPE
  543. SYNTAX SEQUENCE OF RdbmsSrvInfoEntry
  544. MAX-ACCESS not-accessible
  545. STATUS current
  546. DESCRIPTION
  547. "The table of additional information about database servers.
  548. Entries in this table correspond to applications in the
  549. NETWORK-SERVICES-MIB applTable. Some objects in that table are
  550. application-specific. When they are associated with an RDBMS
  551. server in this table, the objects have the following
  552. meanings.
  553. applName - The name of this server, i.e., the process or
  554. group of processes providing access to this database. The
  555. exact format will be product and host specific.
  556. applVersion - The version number of this server, in product
  557. specific format.
  558. applOperStatus - up(1) means operational and available for
  559. general use. down(2) means the server is not available for
  560. use, but is known to the agent. The other states have broad
  561. meaning, and may need to be supplemented by the vendor
  562. private MIB. Halted(3) implies an administrative state of
  563. unavailability. Congested(4) implies a resource or or
  564. administrative limit is prohibiting new inbound associations.
  565. The 'available soon' description of restarting(5) may include
  566. an indeterminate amount of recovery.
  567. applLastChange is the time the agent noticed the most recent
  568. change to applOperStatus.
  569. applInboundAssociation is the number of currently active
  570. local and remote conversations (usually SQL connects).
  571. applOutboundAssociations is not provided by this MIB.
  572. applAccumulatedInboundAssociations is the total number of
  573. local and remote conversations started since the server came
  574. up.
  575. applAccumulatedOutbound associations is not provided by this
  576. MIB.
  577. applLastInboundActivity is the time the most recent local or
  578. remote conversation was attempted or disconnected.
  579. applLastOutboundActivity is not provided by this MIB.
  580. applRejectedInboundAssociations is the number of local or
  581. remote conversations rejected by the server for
  582. administrative reasons or because of resource limitations.
  583. applFailedOutboundAssociations is not provided by this MIB."
  584. ::= { rdbmsObjects 6 }
  585. rdbmsSrvInfoEntry OBJECT-TYPE
  586. SYNTAX RdbmsSrvInfoEntry
  587. MAX-ACCESS not-accessible
  588. STATUS current
  589. DESCRIPTION
  590. "Information that must be present for a single 'up' database
  591. server, with visibility determined by the value of the
  592. corresponding applOperStatus object. If an instance of
  593. applOperStatus is not up(1), then attempts to access
  594. corresponding instances in this table may result in either
  595. noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned
  596. by the agent."
  597. INDEX { applIndex }
  598. ::= { rdbmsSrvInfoTable 1 }
  599. RdbmsSrvInfoEntry ::=
  600. SEQUENCE {
  601. rdbmsSrvInfoStartupTime DateAndTime,
  602. rdbmsSrvInfoFinishedTransactions Gauge32,
  603. rdbmsSrvInfoDiskReads Counter32,
  604. rdbmsSrvInfoDiskWrites Counter32,
  605. rdbmsSrvInfoLogicalReads Counter32,
  606. rdbmsSrvInfoLogicalWrites Counter32,
  607. rdbmsSrvInfoPageWrites Counter32,
  608. rdbmsSrvInfoPageReads Counter32,
  609. rdbmsSrvInfoDiskOutOfSpaces Counter32,
  610. rdbmsSrvInfoHandledRequests Counter32,
  611. rdbmsSrvInfoRequestRecvs Counter32,
  612. rdbmsSrvInfoRequestSends Counter32,
  613. rdbmsSrvInfoHighwaterInboundAssociations Gauge32,
  614. rdbmsSrvInfoMaxInboundAssociations Gauge32
  615. }
  616. rdbmsSrvInfoStartupTime OBJECT-TYPE
  617. SYNTAX DateAndTime
  618. MAX-ACCESS read-only
  619. STATUS current
  620. DESCRIPTION
  621. "The date and time at which this server was last started."
  622. ::= { rdbmsSrvInfoEntry 1 }
  623. rdbmsSrvInfoFinishedTransactions OBJECT-TYPE
  624. SYNTAX Gauge32
  625. MAX-ACCESS read-only
  626. STATUS current
  627. DESCRIPTION
  628. "The number of transactions visible to this server that have
  629. been completed by either commit or abort. Some database
  630. operations, such as read-only queries, may not result in the
  631. creation of a transaction."
  632. ::= { rdbmsSrvInfoEntry 2 }
  633. rdbmsSrvInfoDiskReads OBJECT-TYPE
  634. SYNTAX Counter32
  635. MAX-ACCESS read-only
  636. STATUS current
  637. DESCRIPTION
  638. "The total number of reads of database files issued to the
  639. operating system by this server since startup. Numbers are
  640. not comparable between products. What constitutes a
  641. readand how it is accounted is product-specific."
  642. ::= { rdbmsSrvInfoEntry 3 }
  643. rdbmsSrvInfoLogicalReads OBJECT-TYPE
  644. SYNTAX Counter32
  645. MAX-ACCESS read-only
  646. STATUS current
  647. DESCRIPTION
  648. "The total number of logical reads of database files made
  649. internally by this server since startup. The values of this
  650. object and those of rdbmsSrvInfoDiskReads reveal the effect
  651. of caching on read operation. Numbers are not comparable
  652. between products, and may only be meaningful when aggregated
  653. across all servers sharing a common cache."
  654. ::= { rdbmsSrvInfoEntry 4 }
  655. rdbmsSrvInfoDiskWrites OBJECT-TYPE
  656. SYNTAX Counter32
  657. MAX-ACCESS read-only
  658. STATUS current
  659. DESCRIPTION
  660. "The total number of writes to database files issued to the
  661. operating system by this server since startup. Numbers are
  662. not comparable between products."
  663. ::= { rdbmsSrvInfoEntry 5 }
  664. rdbmsSrvInfoLogicalWrites OBJECT-TYPE
  665. SYNTAX Counter32
  666. MAX-ACCESS read-only
  667. STATUS current
  668. DESCRIPTION
  669. "The total number of times parts of the database files have
  670. been marked 'dirty' and in need of writing to the disk. This
  671. value and rdbmsSrvInfoDiskWrites give some indication of the
  672. effect of 'write-behind' strategies in reducing the number of
  673. disk writes compared to database operations. Because the
  674. writes may be done by servers other than those marking the
  675. parts of the database files dirty, these values may only be
  676. meaningful when aggregated across all servers sharing a
  677. common cache. Numbers are not comparable between products."
  678. ::= { rdbmsSrvInfoEntry 6 }
  679. rdbmsSrvInfoPageReads OBJECT-TYPE
  680. SYNTAX Counter32
  681. MAX-ACCESS read-only
  682. STATUS current
  683. DESCRIPTION
  684. "The total number of pages in database files read by this
  685. server since startup. 'Pages' are product specific units of
  686. disk i/o operations. This value, along with
  687. rdbmsSrvInfoDiskReads, reveals the effect of any grouping
  688. read-ahead that may be used to enhance performance of some
  689. queries, such as scans."
  690. ::= { rdbmsSrvInfoEntry 7}
  691. rdbmsSrvInfoPageWrites OBJECT-TYPE
  692. SYNTAX Counter32
  693. MAX-ACCESS read-only
  694. STATUS current
  695. DESCRIPTION
  696. "The total number of pages in database files written by this
  697. server since startup. Pages are product-specific units of
  698. disk I/O. This value, with rdbmsSrvInfoDiskWrites, shows the
  699. effect of write strategies that collapse logical writes of
  700. contiguous pages into single calls to the operating system."
  701. ::= { rdbmsSrvInfoEntry 8 }
  702. rdbmsSrvInfoDiskOutOfSpaces OBJECT-TYPE
  703. SYNTAX Counter32
  704. MAX-ACCESS read-only
  705. STATUS current
  706. DESCRIPTION
  707. "The total number of times the server has been unable to
  708. obtain disk space that it wanted, since server startup. This
  709. would be inspected by an agent on receipt of an
  710. rdbmsOutOfSpace trap."
  711. ::= { rdbmsSrvInfoEntry 9 }
  712. rdbmsSrvInfoHandledRequests OBJECT-TYPE
  713. SYNTAX Counter32
  714. MAX-ACCESS read-only
  715. STATUS current
  716. DESCRIPTION
  717. "The total number of requests made to the server on inbound
  718. associations. The meaning of 'requests' is product specific,
  719. and is not comparable between products.
  720. This is intended to encapsulate high level semantic
  721. operations between clients and servers, or between peers.
  722. For instance, one request might correspond to a 'select' or
  723. an 'insert' statement. It is not intended to capture disk
  724. i/o described in rdbmsSrvInfoDiskReads and
  725. rdbmsSrvInfoDiskWrites."
  726. ::= { rdbmsSrvInfoEntry 10 }
  727. rdbmsSrvInfoRequestRecvs OBJECT-TYPE
  728. SYNTAX Counter32
  729. MAX-ACCESS read-only
  730. STATUS current
  731. DESCRIPTION
  732. "The number of receive operations made processing any requests
  733. on inbound associations. The meaning of operations is product
  734. specific, and is not comparable between products.
  735. This is intended to capture lower-level i/o operations than
  736. shown by HandledRequests, between clients and servers, or
  737. between peers. For instance, it might roughly correspond to
  738. the amount of data given with an 'insert' statement. It is
  739. not intended to capture disk i/o described in
  740. rdbmsSrvInfoDiskReads and rdbmsSrvInfoDiskWrites."
  741. ::= { rdbmsSrvInfoEntry 11 }
  742. rdbmsSrvInfoRequestSends OBJECT-TYPE
  743. SYNTAX Counter32
  744. MAX-ACCESS read-only
  745. STATUS current
  746. DESCRIPTION
  747. "The number of send operations made processing requests
  748. handled on inbound associations. The meaning of operations
  749. is product specific, and is not comparable between products.
  750. This is intended to capture lower-level i/o operations than
  751. shown by HandledRequests, between between clients and
  752. servers, or between peers. It might roughly correspond to
  753. the number of rows returned by a 'select' statement. It is
  754. not intended to capture disk i/o described in DiskReads."
  755. ::= { rdbmsSrvInfoEntry 12 }
  756. rdbmsSrvInfoHighwaterInboundAssociations OBJECT-TYPE
  757. SYNTAX Gauge32
  758. MAX-ACCESS read-only
  759. STATUS current
  760. DESCRIPTION
  761. "The greatest number of inbound associations that have been
  762. simultaneously open to this server since startup."
  763. ::= { rdbmsSrvInfoEntry 13 }
  764. rdbmsSrvInfoMaxInboundAssociations OBJECT-TYPE
  765. SYNTAX Gauge32
  766. MAX-ACCESS read-write
  767. STATUS current
  768. DESCRIPTION
  769. "The greatest number of inbound associations that can be
  770. simultaneously open with this server. If there is no limit,
  771. then the value should be zero.
  772. Note that a compliant agent does not need to
  773. allow write access to this object."
  774. ::= { rdbmsSrvInfoEntry 14 }
  775. ----------------------------------------------------------------
  776. rdbmsSrvParamTable OBJECT-TYPE
  777. SYNTAX SEQUENCE OF RdbmsSrvParamEntry
  778. MAX-ACCESS not-accessible
  779. STATUS current
  780. DESCRIPTION
  781. "The table of configuration parameters for a server. Entries
  782. should be populated according to the following guidelines:
  783. (1) The value should be specified through administrative
  784. (human) intervention.
  785. (2) It should be configured on a per-server or a more global
  786. basis, with duplicate entries for each server sharing
  787. use of the parameter.
  788. (3) One of the following is true:
  789. (a) The parameter has a non-numeric value;
  790. (b) The current value is numeric, but it only changes due
  791. to human intervention;
  792. (c) The current value is numeric and dynamic, but the
  793. RDBMS does not track access/allocation failures
  794. related to the parameter;
  795. (d) The current value is numeric and dynamic, the
  796. RDBMS tracks changes in access/allocation failures
  797. related to the parameter, but the failure has no
  798. significant impact on RDBMS performance or
  799. availability.
  800. (e) The current value is numeric and dynamic, the
  801. RDBMS tracks changes in access/allocation failures
  802. related to the parameter, the failure has
  803. significant impact on RDBMS performance or
  804. availability, and is shown in the
  805. rdbmsSrvLimitedResource table."
  806. ::= { rdbmsObjects 7 }
  807. rdbmsSrvParamEntry OBJECT-TYPE
  808. SYNTAX RdbmsSrvParamEntry
  809. MAX-ACCESS not-accessible
  810. STATUS current
  811. DESCRIPTION
  812. "An entry for a single configuration parameter for a server.
  813. Parameters with single values have a subindex value of one.
  814. If the parameter is naturally considered to contain a
  815. variable number of members of a class, e.g. members of the
  816. DBA user group, or tracepoints active in the server, then it
  817. must be presented as a set of rows. If, on the other hand,
  818. the parameter represents a set of choices from a class,
  819. e.g. the permissions on a file or the options chosen out of
  820. the set of all options allowed, AND is guaranteed to always
  821. fit in the 255 character length of a DisplayString, then it
  822. may be presented as a comma separated list with a subindex
  823. value of one. Zero may not be used as a subindex value.
  824. Entries for a server must be present if the value of the
  825. corresponding applOperStatus object is up(1). If an instance
  826. of applOperStatus is not up(1), then attempts to access
  827. corresponding instances in this table may result in either
  828. noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned
  829. by the agent."
  830. INDEX { applIndex, rdbmsSrvParamName, rdbmsSrvParamSubIndex }
  831. ::= { rdbmsSrvParamTable 1 }
  832. RdbmsSrvParamEntry ::=
  833. SEQUENCE {
  834. rdbmsSrvParamName DisplayString,
  835. rdbmsSrvParamSubIndex INTEGER,
  836. rdbmsSrvParamID AutonomousType,
  837. rdbmsSrvParamCurrValue DisplayString,
  838. rdbmsSrvParamComment DisplayString
  839. }
  840. rdbmsSrvParamName OBJECT-TYPE
  841. SYNTAX DisplayString (SIZE (1..64))
  842. MAX-ACCESS not-accessible
  843. STATUS current
  844. DESCRIPTION
  845. "The name of a configuration parameter for a server. This
  846. name is product-specific. The length is limited to 64
  847. characters to constrain the number of sub-identifiers needed
  848. for instance identification (and to minimize network
  849. traffic)."
  850. ::= { rdbmsSrvParamEntry 1 }
  851. rdbmsSrvParamSubIndex OBJECT-TYPE
  852. SYNTAX INTEGER (1..2147483647)
  853. MAX-ACCESS not-accessible
  854. STATUS current
  855. DESCRIPTION
  856. "The subindex value for this parameter. If the parameter is
  857. naturally considered to contain a variable number of members
  858. of a class, e.g. members of the DBA user group, or files
  859. which are part of the database, then it must be presented as
  860. a set of rows. If, on the other hand, the parameter
  861. represents a set of choices from a class, e.g. the
  862. permissions on a file or the options chosen out of the set of
  863. all options allowed, AND is guaranteed to always fit in the
  864. 255 character length of a DisplayString, then it may be
  865. presented as a comma separated list with a subindex value of
  866. one. Zero may not be used as a value."
  867. ::= { rdbmsSrvParamEntry 2 }
  868. rdbmsSrvParamID OBJECT-TYPE
  869. SYNTAX AutonomousType
  870. MAX-ACCESS read-only
  871. STATUS current
  872. DESCRIPTION
  873. "The ID of the parameter which may be described in some
  874. other MIB. If there is no ID for this rdbmsSrvParamName,
  875. attempts to access this object will return noSuchName
  876. (SNMPv1) or noSuchInstance (SNMPv2)."
  877. ::= { rdbmsSrvParamEntry 3 }
  878. rdbmsSrvParamCurrValue OBJECT-TYPE
  879. SYNTAX DisplayString
  880. MAX-ACCESS read-write
  881. STATUS current
  882. DESCRIPTION
  883. "The value for a configuration parameter now in effect, the
  884. actual setting for the server. While there may multiple
  885. values in the temporal domain of interest (for instance, the
  886. value to take effect at the next restart), this is the
  887. current setting.
  888. Note that a compliant agent does not need to
  889. allow write access to this object."
  890. ::= { rdbmsSrvParamEntry 4 }
  891. rdbmsSrvParamComment OBJECT-TYPE
  892. SYNTAX DisplayString
  893. MAX-ACCESS read-write
  894. STATUS current
  895. DESCRIPTION
  896. "Annotation which describes the purpose of a configuration
  897. parameter or the reason for a particular parameter's
  898. setting.
  899. Note that a compliant agent does not need to
  900. allow write access to this object."
  901. ::= { rdbmsSrvParamEntry 5 }
  902. ----------------------------------------------------------------
  903. rdbmsSrvLimitedResourceTable OBJECT-TYPE
  904. SYNTAX SEQUENCE OF RdbmsSrvLimitedResourceEntry
  905. MAX-ACCESS not-accessible
  906. STATUS current
  907. DESCRIPTION
  908. "The table of limited resources relevant to a server."
  909. ::= { rdbmsObjects 8 }
  910. rdbmsSrvLimitedResourceEntry OBJECT-TYPE
  911. SYNTAX RdbmsSrvLimitedResourceEntry
  912. MAX-ACCESS not-accessible
  913. STATUS current
  914. DESCRIPTION
  915. "An entry for a single limited resource kept by the server.
  916. A limited resource has maximum use determined by a parameter
  917. that might or might not changeable at run time, or visible in
  918. the rbmsSrvParamTable. Examples would be the number of
  919. available locks, or number of concurrent executions allowed
  920. in a server. Arrays of resources are supported through an
  921. integer subindex, which should have the value of one for
  922. single-instance names.
  923. Limited resources that are shared across servers or databases
  924. are best duplicated in this table across
  925. all servers accessing the resource."
  926. INDEX { applIndex, rdbmsSrvLimitedResourceName }
  927. ::= { rdbmsSrvLimitedResourceTable 1 }
  928. RdbmsSrvLimitedResourceEntry ::=
  929. SEQUENCE {
  930. rdbmsSrvLimitedResourceName DisplayString,
  931. rdbmsSrvLimitedResourceID AutonomousType,
  932. rdbmsSrvLimitedResourceLimit INTEGER,
  933. rdbmsSrvLimitedResourceCurrent INTEGER,
  934. rdbmsSrvLimitedResourceHighwater INTEGER,
  935. rdbmsSrvLimitedResourceFailures Counter32,
  936. rdbmsSrvLimitedResourceDescription DisplayString
  937. }
  938. rdbmsSrvLimitedResourceName OBJECT-TYPE
  939. SYNTAX DisplayString
  940. MAX-ACCESS not-accessible
  941. STATUS current
  942. DESCRIPTION
  943. "The name of the resource, for instance 'threads' or
  944. 'semaphores', or 'buffer pages'"
  945. ::= { rdbmsSrvLimitedResourceEntry 1 }
  946. rdbmsSrvLimitedResourceID OBJECT-TYPE
  947. SYNTAX AutonomousType
  948. MAX-ACCESS read-only
  949. STATUS current
  950. DESCRIPTION
  951. "The ID of the resource which may be described in some other
  952. MIB. If there is no ID for this rdbmsSrvLimitedResourceName,
  953. attempts to access this object will return noSuchName
  954. (SNMPv1) or noSuchInstance (SNMPv2)."
  955. ::= { rdbmsSrvLimitedResourceEntry 2 }
  956. rdbmsSrvLimitedResourceLimit OBJECT-TYPE
  957. SYNTAX INTEGER (1..2147483647)
  958. MAX-ACCESS read-write
  959. STATUS current
  960. DESCRIPTION
  961. "The maximum value the resource use may attain.
  962. Note that a compliant agent does not need to
  963. allow write access to this object."
  964. ::= { rdbmsSrvLimitedResourceEntry 3 }
  965. rdbmsSrvLimitedResourceCurrent OBJECT-TYPE
  966. SYNTAX INTEGER (1..2147483647)
  967. MAX-ACCESS read-only
  968. STATUS current
  969. DESCRIPTION
  970. "The current value for the resource."
  971. ::= { rdbmsSrvLimitedResourceEntry 4 }
  972. rdbmsSrvLimitedResourceHighwater OBJECT-TYPE
  973. SYNTAX INTEGER (1..2147483647)
  974. MAX-ACCESS read-only
  975. STATUS current
  976. DESCRIPTION
  977. "The maximum value of the resource seen since applUpTime
  978. was reset."
  979. ::= { rdbmsSrvLimitedResourceEntry 5 }
  980. rdbmsSrvLimitedResourceFailures OBJECT-TYPE
  981. SYNTAX Counter32
  982. MAX-ACCESS read-only
  983. STATUS current
  984. DESCRIPTION
  985. "The number of times the system wanted to exceed the limit of
  986. the resource since applUpTime was reset."
  987. ::= { rdbmsSrvLimitedResourceEntry 6 }
  988. rdbmsSrvLimitedResourceDescription OBJECT-TYPE
  989. SYNTAX DisplayString
  990. MAX-ACCESS read-write
  991. STATUS current
  992. DESCRIPTION
  993. "A description of the resource and the meaning of the integer
  994. units used for Limit, Current, and Highwater.
  995. Note that a compliant agent does not need to
  996. allow write access to this object."
  997. ::= { rdbmsSrvLimitedResourceEntry 7 }
  998. ----------------------------------------------------------------
  999. rdbmsRelTable OBJECT-TYPE
  1000. SYNTAX SEQUENCE OF RdbmsRelEntry
  1001. MAX-ACCESS not-accessible
  1002. STATUS current
  1003. DESCRIPTION
  1004. "A table relating databases and servers present on a host."
  1005. ::= { rdbmsObjects 9 }
  1006. rdbmsRelEntry OBJECT-TYPE
  1007. SYNTAX RdbmsRelEntry
  1008. MAX-ACCESS not-accessible
  1009. STATUS current
  1010. DESCRIPTION
  1011. "An entry relating a single database server to a single
  1012. database to which it may provide access. The table is
  1013. indexed first by the index of rdbmsDbTable, and then
  1014. rdbmsSrvTable, so that all servers capable of providing
  1015. access to a given database may be found by SNMP traversal
  1016. operations (get-next and get-bulk). The makeup of this table
  1017. depends on the product's architecture, e.g. if it is one
  1018. server - many databases, then each server will appear n
  1019. times, where n is the number of databases it may access, and
  1020. each database will appear once. If the architecture is one
  1021. database - many servers, then each server will appear once
  1022. and each database will appear n times, where n is the number
  1023. of servers that may be accessing it."
  1024. INDEX { rdbmsDbIndex, applIndex }
  1025. ::= { rdbmsRelTable 1 }
  1026. RdbmsRelEntry ::=
  1027. SEQUENCE {
  1028. rdbmsRelState INTEGER,
  1029. rdbmsRelActiveTime DateAndTime
  1030. }
  1031. rdbmsRelState OBJECT-TYPE
  1032. SYNTAX INTEGER{
  1033. other(1),
  1034. active(2),
  1035. available(3),
  1036. restricted(4),
  1037. unavailable(5)
  1038. }
  1039. MAX-ACCESS read-only
  1040. STATUS current
  1041. DESCRIPTION
  1042. "The state of this server's access to this database.
  1043. Active(2) means the server is actively using the database.
  1044. Available(3) means the server could use the database if
  1045. necessary. Restricted(4) means the database is in some
  1046. administratively determined state of less-than-complete
  1047. availability. Unavailable(5) means the database is not
  1048. available through this server. Other(1) means the
  1049. database/server is in some other condition, possibly
  1050. described in the vendor private MIB."
  1051. ::= { rdbmsRelEntry 1 }
  1052. rdbmsRelActiveTime OBJECT-TYPE
  1053. SYNTAX DateAndTime
  1054. MAX-ACCESS read-only
  1055. STATUS current
  1056. DESCRIPTION
  1057. "The time the database was made active by the server. If an
  1058. instance of rdbmsRelState is not active(1), then attempts to
  1059. access the corresponding instance of this object may result
  1060. in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2)
  1061. being returned by the agent."
  1062. ::= { rdbmsRelEntry 2 }
  1063. ----------------------------------------------------------------
  1064. -- Well known resources for which limits, high water marks,
  1065. -- access or allocation failures, and current levels of use
  1066. -- are possibly available in either the rdbmsDbLimitedResources
  1067. -- or the rdbmsSrvLimitedResources tables.
  1068. rdbmsWellKnownLimitedResources OBJECT IDENTIFIER
  1069. ::= { rdbmsObjects 10 }
  1070. rdbmsLogSpace OBJECT-IDENTITY
  1071. STATUS current
  1072. DESCRIPTION
  1073. "Storage allocated for redo and undo logs."
  1074. ::= { rdbmsWellKnownLimitedResources 1}
  1075. ----------------------------------------------------------------
  1076. rdbmsTraps OBJECT IDENTIFIER ::= { rdbmsMIB 2 }
  1077. rdbmsStateChange NOTIFICATION-TYPE
  1078. OBJECTS { rdbmsRelState }
  1079. STATUS current
  1080. DESCRIPTION
  1081. "An rdbmsStateChange trap signifies that one of the database
  1082. server/databases managed by this agent has changed its
  1083. rdbmsRelState in a way that makes it less accessible for use.
  1084. For these purposes, both active(2) and available(3) are
  1085. considered fully accessible. The state sent with the trap is
  1086. the new, less accessible state."
  1087. ::= { rdbmsTraps 1 }
  1088. rdbmsOutOfSpace NOTIFICATION-TYPE
  1089. OBJECTS { rdbmsSrvInfoDiskOutOfSpaces }
  1090. STATUS current
  1091. DESCRIPTION
  1092. "An rdbmsOutOfSpace trap signifies that one of the database
  1093. servers managed by this agent has been unable to allocate
  1094. space for one of the databases managed by this agent. Care
  1095. should be taken to avoid flooding the network with these
  1096. traps."
  1097. ::= { rdbmsTraps 2 }
  1098. ----------------------------------------------------------------
  1099. -- compliance information
  1100. rdbmsConformance OBJECT IDENTIFIER ::= { rdbmsMIB 3 }
  1101. rdbmsCompliances OBJECT IDENTIFIER ::= { rdbmsConformance 1 }
  1102. rdbmsGroups OBJECT IDENTIFIER ::= { rdbmsConformance 2 }
  1103. -- compliance statements
  1104. rdbmsCompliance MODULE-COMPLIANCE
  1105. STATUS current
  1106. DESCRIPTION
  1107. "The compliance statement for SNMP entities which
  1108. implement the RDBMS MIB"
  1109. MODULE HOST-RESOURCES-MIB
  1110. MANDATORY-GROUPS { hrSystem }
  1111. MODULE NETWORK-SERVICES-MIB
  1112. MANDATORY-GROUPS { applGroups }
  1113. MODULE RDBMS-MIB
  1114. MANDATORY-GROUPS { rdbmsGroup }
  1115. GROUP rdbmsGroup
  1116. DESCRIPTION
  1117. "The rdbmsGroup is mandatory, but no write access
  1118. to objects is required for compliance."
  1119. OBJECT rdbmsDbContact
  1120. MIN-ACCESS read-only
  1121. DESCRIPTION
  1122. "A compliant system need not allow write-access to this
  1123. object."
  1124. OBJECT rdbmsDbParamCurrValue
  1125. MIN-ACCESS read-only
  1126. DESCRIPTION
  1127. "A compliant system need not allow write-access to this
  1128. object."
  1129. OBJECT rdbmsDbParamComment
  1130. MIN-ACCESS read-only
  1131. DESCRIPTION
  1132. "A compliant system need not allow write-access to this
  1133. object."
  1134. OBJECT rdbmsDbLimitedResourceLimit
  1135. MIN-ACCESS read-only
  1136. DESCRIPTION
  1137. "A compliant system need not allow write-access to this
  1138. object."
  1139. OBJECT rdbmsDbLimitedResourceDescription
  1140. MIN-ACCESS read-only
  1141. DESCRIPTION
  1142. "A compliant system need not allow write-access to this
  1143. object."
  1144. OBJECT rdbmsSrvContact
  1145. MIN-ACCESS read-only
  1146. DESCRIPTION
  1147. "A compliant system need not allow write-access to this
  1148. object."
  1149. OBJECT rdbmsSrvInfoMaxInboundAssociations
  1150. MIN-ACCESS read-only
  1151. DESCRIPTION
  1152. "A compliant system need not allow write-access to this
  1153. object."
  1154. OBJECT rdbmsSrvParamCurrValue
  1155. MIN-ACCESS read-only
  1156. DESCRIPTION
  1157. "A compliant system need not allow write-access to this
  1158. object."
  1159. OBJECT rdbmsSrvParamComment
  1160. MIN-ACCESS read-only
  1161. DESCRIPTION
  1162. "A compliant system need not allow write-access to this
  1163. object."
  1164. OBJECT rdbmsSrvLimitedResourceLimit
  1165. MIN-ACCESS read-only
  1166. DESCRIPTION
  1167. "A compliant system need not allow write-access to this
  1168. object."
  1169. OBJECT rdbmsSrvLimitedResourceDescription
  1170. MIN-ACCESS read-only
  1171. DESCRIPTION
  1172. "A compliant system need not allow write-access to this
  1173. object."
  1174. ::= { rdbmsCompliances 1 }
  1175. -- units of conformance
  1176. -- rdbmsStateChange and rdbmsOutOfSpace traps are omitted
  1177. -- intentionally. They are not required or part of any
  1178. -- conformance group.
  1179. rdbmsGroup OBJECT-GROUP
  1180. OBJECTS {
  1181. rdbmsDbPrivateMibOID, rdbmsDbVendorName,
  1182. rdbmsDbName, rdbmsDbContact,
  1183. rdbmsDbInfoProductName, rdbmsDbInfoVersion,
  1184. rdbmsDbInfoSizeUnits, rdbmsDbInfoSizeAllocated,
  1185. rdbmsDbInfoSizeUsed, rdbmsDbInfoLastBackup,
  1186. rdbmsDbParamCurrValue, rdbmsDbParamComment,
  1187. rdbmsDbLimitedResourceLimit,
  1188. rdbmsDbLimitedResourceCurrent,
  1189. rdbmsDbLimitedResourceHighwater,
  1190. rdbmsDbLimitedResourceFailures,
  1191. rdbmsDbLimitedResourceDescription,
  1192. rdbmsSrvPrivateMibOID, rdbmsSrvVendorName,
  1193. rdbmsSrvProductName, rdbmsSrvContact,
  1194. rdbmsSrvInfoStartupTime,
  1195. rdbmsSrvInfoFinishedTransactions,
  1196. rdbmsSrvInfoDiskReads, rdbmsSrvInfoDiskWrites,
  1197. rdbmsSrvInfoLogicalReads, rdbmsSrvInfoLogicalWrites,
  1198. rdbmsSrvInfoPageReads, rdbmsSrvInfoPageWrites,
  1199. rdbmsSrvInfoHandledRequests,
  1200. rdbmsSrvInfoRequestRecvs, rdbmsSrvInfoRequestSends,
  1201. rdbmsSrvInfoHighwaterInboundAssociations,
  1202. rdbmsSrvInfoMaxInboundAssociations,
  1203. rdbmsSrvParamCurrValue, rdbmsSrvParamComment,
  1204. rdbmsSrvLimitedResourceLimit,
  1205. rdbmsSrvLimitedResourceCurrent,
  1206. rdbmsSrvLimitedResourceHighwater,
  1207. rdbmsSrvLimitedResourceFailures,
  1208. rdbmsSrvLimitedResourceDescription,
  1209. rdbmsRelState, rdbmsRelActiveTime }
  1210. STATUS current
  1211. DESCRIPTION
  1212. "A collection of objects providing basic instrumentation of an
  1213. RDBMS entity."
  1214. ::= { rdbmsGroups 1 }
  1215. ----------------------------------------------------------------
  1216. END