Using SUF (also known as XBM) to view and dynamically control the log apply process
Utility Monitor
The SUF (also known as XBM) ISPF interface provides a Utility Monitor. You can use this monitor to display statistics and information about the SHRLEVEL CHANGE reorganization jobs that are currently running. You can also use the Utility Monitor to change the log apply control options (as discussed in Log-apply-control-options) for any of those jobs.
Monitor a job
You can use the SUF (also known as XBM) ISPF interface for a menu-driven approach to monitoring and changing a log apply reorganization. After you select the Utility Monitor function and a specific reorganization, the SUF (also known as XBM) REORG PLUS Online panel displays information about that reorganization job. The panel displays the job name, step name, start date, start time, and execution phase that is currently processing. The panel also displays the current values for the log apply control options, as well as information about the data sets that have been registered with SUF (also known as XBM).
After REORG PLUS enters the LOGAPPLY phase, the REORG PLUS Online panel replaces the registered data set information with statistics about the log records for both the index and the table space. These statistics include the number of records that have been applied, the number that have been queued, the arrival rate, and the application rate.
You can also enter the REORG PLUS DISPLAY option, described in this section, from the SUF (also known as XBM) Send New command panel to get additional information about processing of the log records.
For detailed information about the REORG PLUS Online panel, see the EXTENDED BUFFER MANAGER for Db2 documentation.
Change the log apply process
You can use the following methods to change the log apply process:
Type over the values that are displayed for any of the log apply control options on the REORG PLUS Online panel.
You can type over any value until the LOGFINAL phase begins. After the LOGFINAL phase begins, REORG PLUS ignores any changes that you make to these values.
Use the Send New command from the Command menu to send a new value for an option to REORG PLUS.
You can enter only one option and value on each Send New command. Use the format option value, as in the following example:
MAXRO 300
Display information about a job
The REORG PLUS DISPLAY option displays information about the selected log apply job. The syntax of the DISPLAY option follows:
You can display information about log record processing before and during the LOGAPPLY phase, or you can get detailed information about each log apply task. To do so, enter the DISPLAY option with a value of TERSE or VERBOSE on the Utility Monitor Send New Command panel:
- DISPLAY TERSE displays a summary of information for all of the log apply tasks for this job, including the table space and index space.
- DISPLAY VERBOSE displays information and status for each log apply task that is associated with this job.
Value | Description |
|---|---|
DISPLAY TERSE output | The following figures show an example of the output from the DISPLAY TERSE command. DISPLAY TERSE output File View Command Options Console Monitor Help -------------------------------------------------------------------------- .---------------------------------------------------------------------------. | View Last Command Row 1 to 5 of 6 | | | | Job name . . : ARUAVR$E | | Utility name : REORG PLUS Online | | | | Command . . : display terse | | | | | | | | Following response received return code : 0 | | | | BMC50803 LOG APPLY DISPLAY AT 05/30/2005 09:17:17.974617 | | BMC50822 CURRENT PHASE: LOGAPPLY, STARTED: 05/30/2005 08:58:35.938569 | | BMC50804 LOG APPLY TASKS : 1 TASKS, 1 STARTED, 0 FINISHED | | BMC50805 0 RECORDS QUEUED, 9984 RECORDS APPLIED | | BMC50806 INDEX APPLY TASKS: 3 TASKS, 3 STARTED, 0 FINISHED | | | | Command ===> ____________________________________________________________ | | F1=Help F2=Split F3=Exit F7=Bkwd F8=Fwd F9=Swap | | F10=Actions F12=Cancel | '---------------------------------------------------------------------------' File View Command Options Console Monitor Help -------------------------------------------------------------------------- .---------------------------------------------------------------------------. | View Last Command Row 6 to 6 of 6 | | | | Job name . . : ARUAVR$E | | Utility name : REORG PLUS Online | | | | Command . . : display terse | | | | | | | | Following response received return code : 0 | | | | BMC50805 0 RECORDS QUEUED, 29952 RECORDS APPLIED | | **************************** Bottom of data ***************************** | | | | | | | | | | Command ===> ____________________________________________________________ | | F1=Help F2=Split F3=Exit F7=Bkwd F8=Fwd F9=Swap | | F10=Actions F12=Cancel | '---------------------------------------------------------------------------' |
DISPLAY VERBOSE output | The following figures show an example of the output from the DISPLAY VERBOSE command. DISPLAY VERBOSE output File View Command Options Console Monitor Help -------------------------------------------------------------------------- .---------------------------------------------------------------------------. | View Last Command Row 1 to 5 of 17 | | | | Job name . . : ARUAVR$E | | Utility name : REORG PLUS Online | | | | Command . . : display verbose | | | | | | | | Following response received return code : 0 | | | | BMC50803 LOG APPLY DISPLAY AT 05/30/2005 09:12:10.920206 | | BMC50822 CURRENT PHASE: LOGAPPLY, STARTED: 05/30/2005 08:58:35.938569 | | BMC50804 LOG APPLY TASKS : 1 TASKS, 1 STARTED, 0 FINISHED | | BMC50805 0 RECORDS QUEUED, 9984 RECORDS APPLIED | | BMC50807 TASK 102: STARTED | | | | Command ===> ____________________________________________________________ | | F1=Help F2=Split F3=Exit F7=Bkwd F8=Fwd F9=Swap | | F10=Actions F12=Cancel | '---------------------------------------------------------------------------' File View Command Options Console Monitor Help -------------------------------------------------------------------------- .---------------------------------------------------------------------------. | View Last Command Row 6 to 10 of 17 | | | | Job name . . : ARUAVR$E | | Utility name : REORG PLUS Online | | | | Command . . : display verbose | | | | | | | | Following response received return code : 0 | | | | BMC50805 0 RECORDS QUEUED, 9984 RECORDS APPLIED | | BMC50806 INDEX APPLY TASKS: 3 TASKS, 3 STARTED, 0 FINISHED | | BMC50805 0 RECORDS QUEUED, 29952 RECORDS APPLIED | | BMC50807 TASK 103: STARTED | | BMC50810 INDEX R$EAA5CB.LARX005C | | | | Command ===> ____________________________________________________________ | | F1=Help F2=Split F3=Exit F7=Bkwd F8=Fwd F9=Swap | | F10=Actions F12=Cancel | '---------------------------------------------------------------------------' File View Command Options Console Monitor Help -------------------------------------------------------------------------- .---------------------------------------------------------------------------. | View Last Command Row 11 to 15 of 17 | | | | Job name . . : ARUAVR$E | | Utility name :REORG PLUS Online | | | | Command . . : display verbose | | | | | | | | Following response received return code : 0 | | | | BMC50805 0 RECORDS QUEUED, 9984 RECORDS APPLIED | | BMC50807 TASK 104: STARTED | | BMC50810 INDEX R$EAA5CB.LARX005B | | BMC50805 0 RECORDS QUEUED, 9984 RECORDS APPLIED | | BMC50807 TASK 105: STARTED | | | | Command ===> ____________________________________________________________ | | F1=Help F2=Split F3=Exit F7=Bkwd F8=Fwd F9=Swap | | F10=Actions F12=Cancel | '---------------------------------------------------------------------------' File View Command Options Console Monitor Help -------------------------------------------------------------------------- .---------------------------------------------------------------------------. | View Last Command Row 16 to 17 of 17 | | | | Job name . . : ARUAVR$E | | Utility name : REORG PLUS Online | | | | Command . . : display verbose | | | | | | | | Following response received return code : 0 | | | | BMC50810 INDEX R$EAA5CB.LARX005A | | BMC50805 0 RECORDS QUEUED, 9984 RECORDS APPLIED | | **************************** Bottom of data ***************************** | | | | | | | | Command ===> ____________________________________________________________ | | F1=Help F2=Split F3=Exit F7=Bkwd F8=Fwd F9=Swap | | F10=Actions F12=Cancel | '---------------------------------------------------------------------------' |
MVS console
You can use the MVS console to issue commands to an SUF (also known as XBM) subsystem, and to view and respond to write-to-operator (WTO) notifications.
Issuing commands to an SUF (also known as XBM) subsystem
Instead of using the SUF (also known as XBM) Utility Monitor menu interface, you can issue commands at the MVS console to a particular SUF (also known as XBM) subsystem, which then routes the commands to REORG PLUS for the specified job. You can also use a batch program to send the commands to the MVS console. To send a command from the MVS console, use the following format, where ssid represents the SUF (also known as XBM) subsystem ID:
ssid SEND jobName option value
For example, to set the MAXRO value to 300 for job ARUAVR$A that is running on XBM0, issue the following command:
The valid options and values are the same as those for the SUF (also known as XBM) Send New command, which you can issue from the Command menu option within the Utility Monitor. The only difference is that you must supply the SSID and job name, whereas the Utility Monitor appends that information for you.
WTO notifications
When REORG PLUS detects a longlog condition, it sends an action WTO notification. The ROUTCDE and DESCCDE installation options determine which console receives the WTO and how it is formatted. REORG PLUS deletes the WTO when the longlog condition ends or the LOGFINAL phase begins.