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