rdbmsV2.mib 56 KB

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