1 tony  1.1 // ===================================================================
  2           // Title:       Database MOF Specification 2.8
  3           // Filename:    Database28_Statistics.mof
  4           // Version:     2.8
  5           // Release:     Final
  6           // Date:        Jan 26, 2004
  7           // ===================================================================
  8           // Copyright 1998-2004 Distributed Management Task Force, Inc. (DMTF).
  9           // All rights reserved.
 10           // DMTF is a not-for-profit association of industry members dedicated
 11           // to promoting enterprise and systems management and interoperability.
 12           // DMTF specifications and documents may be reproduced for uses
 13           // consistent with this purpose by members and non-members,
 14           // provided that correct attribution is given.
 15           // As DMTF specifications may be revised from time to time,
 16           // the particular version and release date should always be noted.
 17           // 
 18           // Implementation of certain elements of this standard or proposed
 19           // standard may be subject to third party patent rights, including
 20           // provisional patent rights (herein "patent rights"). DMTF makes
 21           // no representations to users of the standard as to the existence
 22 tony  1.1 // of such rights, and is not responsible to recognize, disclose, or
 23           // identify any or all such third party patent right, owners or
 24           // claimants, nor for any incomplete or inaccurate identification or
 25           // disclosure of such rights, owners or claimants. DMTF shall have no
 26           // liability to any party, in any manner or circumstance, under any
 27           // legal theory whatsoever, for failure to recognize, disclose, or
 28           // identify any such third party patent rights, or for such party's
 29           // reliance on the standard or incorporation thereof in its product,
 30           // protocols or testing procedures. DMTF shall have no liability to
 31           // any party implementing such standard, whether such implementation
 32           // is foreseeable or not, nor to any patent owner or claimant, and shall
 33           // have no liability or responsibility for costs or losses incurred if
 34           // a standard is withdrawn or modified after publication, and shall be
 35           // indemnified and held harmless by any party implementing the
 36           // standard from any and all claims of infringement by a patent owner
 37           // for such implementations.
 38           // 
 39           // For information about patents held by third-parties which have
 40           // notified the DMTF that, in their opinion, such patent may relate to
 41           // or impact implementations of DMTF standards, visit
 42           // http://www.dmtf.org/about/policies/disclosures.php.
 43 tony  1.1 // ===================================================================
 44           // Description:
 45           //       This file contains the classes and associations that define
 46           //       the statistics used to manage a database.
 47           // ===================================================================
 48           // Change Log for V2.8 - None
 49           // ==================================================================
 50           
 51           // ==================================================================
 52           // DatabaseServiceStatistics
 53           // ==================================================================
 54              [Version ( "2.7.0" ), Description (
 55                  "The CIM_DatabaseServiceStatistics class contains the current "
 56                  "statistics for a database service. These are counters that are "
 57                  "relative to the start of the service or from the time when a "
 58                  "reset was issued.")]
 59           class CIM_DatabaseServiceStatistics : CIM_StatisticalData {
 60           
 61                 [Description (
 62                     "The date and time when the most recent inbound activity was "
 63                     "observed for the database service. A value of all zeros "
 64 tony  1.1           "indicates that no inbound activity has taken place since "
 65                     "the service was started."), 
 66                  MappingStrings { 
 67                     "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoLastInboundActivity" }]
 68              datetime LastActivity;
 69           
 70                 [Description (
 71                     "The number of active inbound connections that are currently "
 72                     "using the service."), 
 73                  Counter, 
 74                  MappingStrings { 
 75                     "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoapplInboundAssociation" }]
 76              uint64 ActiveConnections;
 77           
 78                 [Description (
 79                     "The total number of inbound connections to the service "
 80                     "since it was started."), 
 81                  Counter, 
 82                  MappingStrings { 
 83                     "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoapplAccumulated" 
 84                     "InboundAssociations" }]
 85 tony  1.1    uint64 CumulativeConnections;
 86           
 87                 [Description (
 88                     "The total number of inbound connections that were rejected "
 89                     "by the service since it was started."), 
 90                  Counter, 
 91                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoapplRejected" 
 92                     "InboundAssociations" }]
 93              uint64 RejectedConnections;
 94           
 95                 [Description (
 96                     "The total number of transactions that have been completed "
 97                     "by a commit or abort. Some database operations, such as "
 98                     "read-only queries, may not create a transaction."), 
 99                  Counter, 
100                  MappingStrings { 
101                     "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoFinishedTransactions" }]
102              uint64 CompletedTransactions;
103           
104                 [Description (
105                     "The total number of database file reads that were issued by "
106 tony  1.1           "the service since it was started."), 
107                  Counter, 
108                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoDiskReads" }]
109              uint64 DiskReads;
110           
111                 [Description (
112                     "The total number of database file writes that were issued "
113                     "by the service since it was started."), 
114                  Counter, 
115                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoDiskWrites" }]
116              uint64 DiskWrites;
117           
118                 [Description (
119                     "The total number of logical database file reads that were "
120                     "issued by the service since it was started."), 
121                  Counter, 
122                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoLogicalReads" }]
123              uint64 LogicalReads;
124           
125                 [Description (
126                     "The total number of logical database file writes that were "
127 tony  1.1           "issued by the service since it was started. A logical write "
128                     "is a count of the number of times that parts of database "
129                     "files have been marked dirty to indicate that they need to "
130                     "be written to disk."), 
131                  Counter, 
132                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoLogicalWrites" 
133                     }]
134              uint64 LogicalWrites;
135           
136                 [Description (
137                     "The total number of database pages that have been read by "
138                     "the service since it was started."), 
139                  Counter, 
140                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoPageReads" }]
141              uint64 PageReads;
142           
143                 [Description (
144                     "The total number of database pages that have been written "
145                     "by the service since it was started."), 
146                  Counter, 
147                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoPageWrites" }]
148 tony  1.1    uint64 PageWrites;
149           
150                 [Description (
151                     "The total number of times the database requested disk space "
152                     "and it was not available since the service was started."), 
153                  Counter, 
154                  MappingStrings { 
155                     "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoDiskOutOfSpaces" }]
156              uint64 DiskSpaceUnavailable;
157           
158                 [Description (
159                     "The total number of requests that have been received by the "
160                     "service since it was started."), 
161                  Counter, 
162                  MappingStrings { 
163                     "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoHandledRequests" }]
164              uint64 RequestsHandled;
165           
166                 [Description (
167                     "The total number of receive operations made by the service "
168                     "during request processing since it was started."), 
169 tony  1.1        Counter, 
170                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoRequestRecvs" }]
171              uint64 RequestsReceived;
172           
173                 [Description (
174                     "The total number of send operations made by the service "
175                     "during request processing since it was started."), 
176                  Counter, 
177                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoRequestsSent" }]
178              uint64 RequestsSent;
179           
180                 [Description (
181                     "The maximum number of active inbound connections that have "
182                     "been concurrently using the service since it was started."), 
183                  Counter, 
184                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoHighwater" 
185                     "InboundAssociations" }]
186              uint64 HighwaterConnections;
187           };
188           
189           
190 tony  1.1 // ==================================================================
191           // CommonDatabaseStatistics
192           // ==================================================================
193              [Version ( "2.7.0" ), Description (
194                  "The CIM_CommonDatabaseStatistics class contains the current "
195                  "statistics for a database.")]
196           class CIM_CommonDatabaseStatistics : CIM_StatisticalData {
197           
198                 [Description (
199                     "The estimated amount of disk space (in units) that is "
200                     "currently used by the database."), 
201                  MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsDbInfoSizeUsed" }]
202              uint32 SizeUsed;
203           };
204           
205           
206           // ==================================================================
207           // DatabaseResourceStatistics
208           // ==================================================================
209              [Version ( "2.7.0" ), Description (
210                  "The CIM_DatabaseServiceStatistics class contains the current "
211 tony  1.1        "statistics for a database resource. This class maps to the "
212                  "database and server limited resource tables in the SNMP RDBMS "
213                  "MIB as defined in RFC 1697.")]
214           class CIM_DatabaseResourceStatistics : CIM_StatisticalData {
215           
216                 [Description (
217                     "The current value of a limited database resource."), 
218                  Counter, 
219                  MappingStrings { 
220                     "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceCurrent" }]
221              uint64 Current;
222           
223                 [Description (
224                     "The maximum value that the database resource can attain."), 
225                  MappingStrings { 
226                     "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceLimit" }]
227              uint64 Limit;
228           
229                 [Description (
230                     "The number of database resources used measured from the "
231                     "time when the first service was started for the database. "
232 tony  1.1           "Other external factors, such as an explicit reset of the "
233                     "statistics may cause this measurement to begin at a later "
234                     "point in time."), 
235                  Counter, 
236                  MappingStrings { 
237                     "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceHighwater" }]
238              uint64 Highwater;
239           
240                 [Description (
241                     "The number of times that the system wanted to exceed the "
242                     "database resource limit measured from the time when the "
243                     "first service was started for the database."), 
244                  Counter, 
245                  MappingStrings { 
246                     "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceFailures" }]
247              uint32 Failures;
248           };