Control Center Operations Guide for VSE

Update Statistics Analysis Tool

The Update Statistics Analysis tool can be selected from the DBSPACE ANALYSIS UTILITIES screen by choosing Option 2 (Update Statistics Candidates).

The purpose of this tool is to list the DBSPACEs that need to have their statistics updated and to optionally submit batch jobs to update them.

An example of the list generated by the Update Statistics Analysis Tool is shown in Figure 10. The list was created by specifying:

|+--------------------------------------------------------------------------------+
||OPTION ===> 2                                                                   |
||                                                                                |
||OWNER ===> PUBLIC                                                               |
||                                                                                |
||PAGES: MINIMUM ==> 0                  MAXIMUM ========> 9999999                 |
||                                                                                |
||DAYS SINCE ======> 4                                                            |
|+--------------------------------------------------------------------------------+

Figure 10. Update Statistics Analysis List Screen

|

|+--------------------------------------------------------------------------------+
||     mm/dd/yyyy                 CONTROL CENTER                        hh:mm:ss  |
||*------------------------   UPDATE STATISTICS LIST --------------------------*  |
||| DATABASE => SQLDBA                                                         |  |
|||                                                                            |  |
|||   OWNER    DBSPACENAME        LAST DATE   ELAPSED   NPAGES                 |  |
|||                                                                            |  |
||| _ PUBLIC   ANDY               1996-11-19  00:01:00     128                 |  |
||| _ PUBLIC   CONNIE             1996-11-18  00:02:30     128                 |  |
||| _ PUBLIC   FRED               1996-10-30  00:01:05     128                 |  |
||| _ PUBLIC   MARTIN             1996-11-19  00:00:50     128                 |  |
||| _ PUBLIC   SMITH              1996-11-17  00:03:14     256                 |  |
||| _ PUBLIC   RAY                1996-11-17  00:02:45     512                 |  |
||| _ PUBLIC   TAYLOR             1996-11-18  00:01:30     512                 |  |
||| _ PUBLIC   SQLMSTR            1996-11-18  00:00:45     128                 |  |
||| _ PUBLIC   SQMHELP            1996-10-29  00:01:20     256                 |  |
|||                                                                            |  |
|||                                                                            |  |
|||                                                                            |  |
|||                                                                            |  |
|||                                                                            |  |
|||                                                                            |  |
||*----------------------------------------------------------------- SQC09 ----*  |
||                                                                                |
||USE 'X' TO SELECT DBSPACE(S); PRESS ENTER TO SUBMIT                             |
||ENTER F1=HELP F3=EXIT F12=CANCEL                                                |
|+--------------------------------------------------------------------------------+

Note that on this screen the following are displayed:

1. The DBSPACE OWNER and NAME.
2. The DATE of the last Update Statistics for this DBSPACE.
3. The ELAPSED time (in hours:minutes:seconds) of the most recent Update Statistics job for this DBSPACE.
4. The size of the DBSPACE.

From this screen, you can enter an "X" next to the DBSPACE(s) for which an UPDATE STATISTICS job is desired. Then, by pressing ENTER, the DBSPACE ANALYSIS SUBMIT screen is displayed and a job can be scheduled for execution. When multiple DBSPACEs are selected, multiple jobs are submitted, each having the same job name and parameters. (See DBSPACE Analysis Submit Screen).

Pressing F12 will take you back to the previous screen (DBSPACE Analysis Utilities). Pressing F3 will take you back to the Control Center main menu.