You start the monitor kernel from the Monitor Menu. The Monitor Menu is invoked by selecting Option 09 Monitor Utilities from the Control Center Main Menu, and then Option 1. It is shown in Figure 34. You must have defined (Add a Monitor) at least one monitor in order to use this function. Once started, the monitor kernel runs until you execute the Stop Monitor command.
Figure 34. Monitor Menu
+--------------------------------------------------------------------------------+
| mm/dd/yyyy CONTROL CENTER hh:mm:ss |
|*--------------------------- MONITOR UTILITY ---------------------------* |
|| | |
|| DATABASE => SQLDBA | |
|| | |
|| *************************************************************************** | |
|| | |
|| OPTION => 01 START KERNEL 02 STOP KERNEL | |
|| 03 LIST MONITORS 04 ADD MONITOR | |
|| 05 MODIFY MONITOR 06 DELETE MONITOR | |
|| 07 DISPLAY MONITOR 08 VIEW DATA | |
|| 09 RESET DATA 10 PRINT REPORT | |
|| | |
|| *************************************************************************** | |
|| | |
|| MONITOR => 01 SHOW ACTIVE 02 SHOW LOCK | |
|| 03 SHOW DBEXTENT 04 SHOW LOG | |
|| 05 SHOW CONNECT 06 SHOW DBSPACE 00001 | |
|| 07 COUNTER * | |
|| | |
|*------------------------------------------------------------------ SQC40 ----* |
| |
|PRESS ENTER TO PROCESS |
|ENTER F1=HELP F3=EXIT |
+--------------------------------------------------------------------------------+
Lets you end the execution of all active monitors, once monitors currently executing have been completed. When you stop the Monitor Kernel, you stop all the monitors.
Lists all the monitors defined for the specified database on your terminal. Figure 35 shows the monitors belonging to the SQLDBA database.
Figure 35. Monitor List
+--------------------------------------------------------------------------------+
| mm/dd/yyyy CONTROL CENTER hh:mm:ss |
|*--------------------------- MONITOR LIST ----------------------------* |
|| DATABASE => SQLDBA | |
|| | |
|| MONITOR_____ DESCRIPTION_______________________________________ | |
|| ACTIVITY SHOW ACTIVE | |
|| LOCKING SHOW LOCK ACTIVE | |
|| COUNTERS COUNTER * | |
|| LOG SHOW LOG | |
|| POOL SHOW POOL | |
|| DBEXTENT SHOW DBEXTENT | |
|| DBSPACE00001 SHOW DBSPACE 1 | |
|| DBSPACE00002 SHOW DBSPACE 2 | |
|| DBSPACE00003 SHOW DBSPACE 3 | |
|| DBSPACE00004 SHOW DBSPACE 4 | |
|| DBSPACE00005 SHOW DBSPACE 5 | |
|| DBSPACE00006 SHOW DBSPACE 6 | |
|| DBSPACE00007 SHOW DBSPACE 7 | |
|| DBSPACE00010 SHOW DBSPACE 10 | |
|| DBSPACE00022 SHOW DBSPACE 22 | |
|*------------------------------------------------------------------ SQC43 ----* |
|F1=HELP F3=EXIT F4=TOP F5=BOT F7=BWD F8=FWD F12=CANCEL |
+--------------------------------------------------------------------------------+
Lets you define a monitor, the first step in using one. You specify the database you want to monitor, the type of monitor, the frequency, and the start and stop times. You also define the threshold at which notification will occur.
Lets you view the monitor definition information. You can choose to update the frequency, start and stop times, and the monitor thresholds, and to activate or deactivate a monitor.
Lets you delete a monitor. To delete the SHOW LOG monitor from the SQLDBA database, for example, select Option 06. Next select Monitor 04 and press ENTER.
Note that you can press PF3 to cancel deleting the monitor.
Lets you view the definition of a monitor.
Lets you view the data the monitor has collected. With this option, you can analyze the output and watch for significant database use or trends.
Deletes all rows of data collected by the monitor from the associated monitor table. Data keeps accumulating until the monitor is reset.
Generates a monitor report and places it directly on the VSE/POWER List queue. The monitor report includes all the data that the monitor has captured. To Print a Monitor Report, select Option 10 from the main Monitor Menu, together with the desired monitor ID.
The figure that follows is where you include appropriate job submission parameters. The RESET DATA? option keeps the data or deletes it from the related monitor table when the job executes. Specify "1" to refresh the table, or "2" to show cumulative data.
Figure 36. Monitor Report Option
+--------------------------------------------------------------------------------+
| mm/dd/yyyy CONTROL CENTER hh:mm:ss |
|*---------------------------- MONITOR REPORT ---------------------------* |
|| | |
|| DATABASE => SQLDBA____________ MONITOR => DBSPACE00001 | |
|| | |
|| *********************** REPORT PARAMETERS *********************** | |
|| | |
|| REPORT NAME => ________ | |
|| | |
|| CLASS => A | |
|| | |
|| PRI => 3 | |
|| | |
|| DISP => D (D,H,L,K) | |
|| | |
|| *************************************************************************** | |
|| | |
|| RESET DATA? => 1 (1=YES/2=NO) | |
|| | |
|| | |
|*------------------------------------------------------------------ SQC26 ----* |
| |
|PRESS ENTER TO PROCESS |
|ENTER F1=HELP F3=EXIT F12=CANCEL |
+--------------------------------------------------------------------------------+