Monitor DB2 Activities Captured Snapshot Data
|
|
Posted On :
Oct-16-2011
| seen (376) times |
Article Word Count :
519
|
|
Database system monitor Database monitoring is an important activity, hence as the implementation of the daily activities
|
|
Database system monitor Database monitoring is an important activity, hence as the implementation of the daily activities, to provide the feedback health status of the database system continuously. Precisely because the database monitor is an integral part of database administration, DB2 9 provides a feature called System Monitor to monitor database utilities. Despite its name, "Database system monitor" that only seems to provide a monitoring tool, but in fact, the database system monitor by two different tools that can be used to capture and return system monitoring information: a snapshot monitor and one or more event monitors. Snapshot Monitor allows you to capture a specific point in time the database state diagram, and monitor events when the event occurs in a particular database to capture and record data. These two tools are stored in the data collected as control elements (or data elements) of the entity. Elements used in the monitoring identified by unique names, and are designed to accommodate specific types of information. The following types of elements used to store monitoring data:
Counter (Counter). Save the active or the counter number of events have occurred. In the monitor throughout the life cycle, the counter value is increased gradually; typically, the counter surveillance elements to be reset (equipment security). To execute a database SQL statement is the total number of elements of a counter example. Meter (Gauge). Meter kept in place a specific point in time the number of activities or events. And counter values are different, the value meter increase can also be reduced, measuring point at a given time usually depends on the value of database activity level. Currently it connected to a database application that gauges the number of elements in a sample. Water mark (Watermark). Water mark since the beginning of that self-monitoring observed the highest (maximum) or lowest (minimum) value. Update the maximum number of rows affected by the water level is the standard elements of an example. As the name suggests, the information element provides all the monitoring activities performed by reference to the type of detail. Examples of information elements including buffer pool name, database name and aliases, paths and other details. Timestamp (Timestamp). Timestamp activity or event that the date and time. Timestamp value after 1 January 1970, the number of microsecond’s elapsed seconds and form. The first connection with the database creation date and time is an example of a timestamp element (security equipment supply). Time. Time element performs an activity or event to save the time spent. Time value from the activities or events after the start of the number of elapsed seconds and microseconds form, some time elements to be reset. Perform a sort operation takes a time element is an example. Database system monitor can use any combination of these elements to capture monitoring data, once collected, can use some method for the snapshot monitor and event monitor shows the elements used to store data, you can choose to collect All data is stored in a file or database table, view on screen or use a custom application for processing.from: security system equipment
|
|
|
|
Article Source :
http://www.articleseen.com/Article_Monitor DB2 Activities Captured Snapshot Data _78562.aspx
|
|
Author Resource :
security equipment supply, equipment security, security system equipment
|
|
Keywords :
counter surveillance elements, system monitor, security system equipment,
Category :
Business
:
Sales
|
|
|
|
