1 a.dunfey 1.1 // ===================================================================
  2              // Title: Database_Statistics
  3              // $State: Exp $
  4              // $Date: 2004/11/29 18:31:42 $
  5              // $RCSfile: Database_Statistics.mof,v $
  6              // $Revision: 1.3.2.3 $
  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              // ==================================================================
 54              // DatabaseServiceStatistics
 55              // ==================================================================
 56                 [Version ( "2.7.0" ), Description (
 57                     "The CIM_DatabaseServiceStatistics class contains the current "
 58                     "statistics for a database service. These are counters that are "
 59                     "relative to the start of the service or from the time when a "
 60                     "reset was issued.")]
 61              class CIM_DatabaseServiceStatistics : CIM_StatisticalData {
 62              
 63                    [Description (
 64 a.dunfey 1.1           "The date and time when the most recent inbound activity was "
 65                        "observed for the database service. A value of all zeros "
 66                        "indicates that no inbound activity has taken place since "
 67                        "the service was started."), 
 68                     MappingStrings { 
 69                        "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoLastInboundActivity" }]
 70                 datetime LastActivity;
 71              
 72                    [Description (
 73                        "The number of active inbound connections that are currently "
 74                        "using the service."), 
 75                     Counter, 
 76                     MappingStrings { 
 77                        "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoapplInboundAssociation" }]
 78                 uint64 ActiveConnections;
 79              
 80                    [Description (
 81                        "The total number of inbound connections to the service "
 82                        "since it was started."), 
 83                     Counter, 
 84                     MappingStrings { 
 85 a.dunfey 1.1           "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoapplAccumulated" 
 86                        "InboundAssociations" }]
 87                 uint64 CumulativeConnections;
 88              
 89                    [Description (
 90                        "The total number of inbound connections that were rejected "
 91                        "by the service since it was started."), 
 92                     Counter, 
 93                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoapplRejected" 
 94                        "InboundAssociations" }]
 95                 uint64 RejectedConnections;
 96              
 97                    [Description (
 98                        "The total number of transactions that have been completed "
 99                        "by a commit or abort. Some database operations, such as "
100                        "read-only queries, may not create a transaction."), 
101                     Counter, 
102                     MappingStrings { 
103                        "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoFinishedTransactions" }]
104                 uint64 CompletedTransactions;
105              
106 a.dunfey 1.1       [Description (
107                        "The total number of database file reads that were issued by "
108                        "the service since it was started."), 
109                     Counter, 
110                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoDiskReads" }]
111                 uint64 DiskReads;
112              
113                    [Description (
114                        "The total number of database file writes that were issued "
115                        "by the service since it was started."), 
116                     Counter, 
117                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoDiskWrites" }]
118                 uint64 DiskWrites;
119              
120                    [Description (
121                        "The total number of logical database file reads that were "
122                        "issued by the service since it was started."), 
123                     Counter, 
124                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoLogicalReads" }]
125                 uint64 LogicalReads;
126              
127 a.dunfey 1.1       [Description (
128                        "The total number of logical database file writes that were "
129                        "issued by the service since it was started. A logical write "
130                        "is a count of the number of times that parts of database "
131                        "files have been marked dirty to indicate that they need to "
132                        "be written to disk."), 
133                     Counter, 
134                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoLogicalWrites" 
135                        }]
136                 uint64 LogicalWrites;
137              
138                    [Description (
139                        "The total number of database pages that have been read by "
140                        "the service since it was started."), 
141                     Counter, 
142                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoPageReads" }]
143                 uint64 PageReads;
144              
145                    [Description (
146                        "The total number of database pages that have been written "
147                        "by the service since it was started."), 
148 a.dunfey 1.1        Counter, 
149                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoPageWrites" }]
150                 uint64 PageWrites;
151              
152                    [Description (
153                        "The total number of times the database requested disk space "
154                        "and it was not available since the service was started."), 
155                     Counter, 
156                     MappingStrings { 
157                        "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoDiskOutOfSpaces" }]
158                 uint64 DiskSpaceUnavailable;
159              
160                    [Description (
161                        "The total number of requests that have been received by the "
162                        "service since it was started."), 
163                     Counter, 
164                     MappingStrings { 
165                        "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoHandledRequests" }]
166                 uint64 RequestsHandled;
167              
168                    [Description (
169 a.dunfey 1.1           "The total number of receive operations made by the service "
170                        "during request processing since it was started."), 
171                     Counter, 
172                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoRequestRecvs" }]
173                 uint64 RequestsReceived;
174              
175                    [Description (
176                        "The total number of send operations made by the service "
177                        "during request processing since it was started."), 
178                     Counter, 
179                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoRequestsSent" }]
180                 uint64 RequestsSent;
181              
182                    [Description (
183                        "The maximum number of active inbound connections that have "
184                        "been concurrently using the service since it was started."), 
185                     Counter, 
186                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsSrvInfoHighwater" 
187                        "InboundAssociations" }]
188                 uint64 HighwaterConnections;
189              };
190 a.dunfey 1.1 
191              
192              // ==================================================================
193              // CommonDatabaseStatistics
194              // ==================================================================
195                 [Version ( "2.7.0" ), Description (
196                     "The CIM_CommonDatabaseStatistics class contains the current "
197                     "statistics for a database.")]
198              class CIM_CommonDatabaseStatistics : CIM_StatisticalData {
199              
200                    [Description (
201                        "The estimated amount of disk space (in units) that is "
202                        "currently used by the database."), 
203                     MappingStrings { "MIB.IETF|RDBMS-MIB.rdbmsDbInfoSizeUsed" }]
204                 uint32 SizeUsed;
205              };
206              
207              
208              // ==================================================================
209              // DatabaseResourceStatistics
210              // ==================================================================
211 a.dunfey 1.1    [Version ( "2.7.0" ), Description (
212                     "The CIM_DatabaseServiceStatistics class contains the current "
213                     "statistics for a database resource. This class maps to the "
214                     "database and server limited resource tables in the SNMP RDBMS "
215                     "MIB as defined in RFC 1697.")]
216              class CIM_DatabaseResourceStatistics : CIM_StatisticalData {
217              
218                    [Description (
219                        "The current value of a limited database resource."), 
220                     Counter, 
221                     MappingStrings { 
222                        "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceCurrent" }]
223                 uint64 Current;
224              
225                    [Description (
226                        "The maximum value that the database resource can attain."), 
227                     MappingStrings { 
228                        "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceLimit" }]
229                 uint64 Limit;
230              
231                    [Description (
232 a.dunfey 1.1           "The number of database resources used measured from the "
233                        "time when the first service was started for the database. "
234                        "Other external factors, such as an explicit reset of the "
235                        "statistics may cause this measurement to begin at a later "
236                        "point in time."), 
237                     Counter, 
238                     MappingStrings { 
239                        "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceHighwater" }]
240                 uint64 Highwater;
241              
242                    [Description (
243                        "The number of times that the system wanted to exceed the "
244                        "database resource limit measured from the time when the "
245                        "first service was started for the database."), 
246                     Counter, 
247                     MappingStrings { 
248                        "MIB.IETF|RDBMS-MIB.rdbmsDbLimitedResourceFailures" }]
249                 uint32 Failures;
250              };