Control Center Operations Guide for VSE

Invocation

There are two ways to invoke the Table Utility:

1. on the Control Center Main Menu - select option 10 (TABLE UTILITY) and press ENTER.
2. directly from CICS, by typing the Table Utility transaction ID "SQTU"

   and pressing ENTER.

When either of these is done, the Table Utility main menu is displayed.

Figure 44. Table Utility Main Menu

+--------------------------------------------------------------------------------+
|     mm/dd/yyyy                 CONTROL CENTER                         hh:mm:ss |
|*------------------------------- TABLE UTILITY -------------------------------* |
||                                                                             | |
|| DATABASE     => SQLDBA                                                      | |
||                                                                             | |
|| ***********************************************************************     | |
||                                                                             | |
|| OPTION       => _ 1 LIST TABLES                                             | |
||                   2 DROP TABLE                                              | |
||                   3 REORGANIZE TABLE                                        | |
||                   4 CREATE TABLE                                            | |
||                   5 UPDATE STATISTICS                                       | |
||                                                                             | |
|| ***********************************************************************     | |
||                                                                             | |
||                                                                             | |
|| CREATOR      => ________                                                    | |
||                                                                             | |
|| TABLE        => __________________                                          | |
||                                                                             | |
|*------------------------------------------------------------------ SQC60 ----* |
|                                                                                |
|PRESS ENTER TO SELECT FUNCTION                                                  |
|ENTER F1=HELP F3=EXIT                                                           |
+--------------------------------------------------------------------------------+

There are 5 major functions you can select from this menu. They are described in:

LIST TABLES

DROP TABLE

REORGANIZE TABLE

CREATE TABLE

UPDATE STATISTICS

If Option 1 is selected, several choices exist:

• If CREATOR and TABLE are left blank, then all tables in the database will be listed.
• If one of the CREATOR or TABLE fields is blank or specified as "ALL", all tables with the matching other field will be listed.

  Both, or each of the CREATOR and TABLE field values can have a trailing percent sign (%) to represent a string of zero or more characters in the same way you can use the LIKE predicate in an SQL statement.

If Option 2, 3, or 5, is selected, an existing database table name (TABLE) and creator (CREATOR) must be entered (or have been selected by using Option 1, List TABLES).

If Option 4 is selected, then a CREATOR and non-existing TABLE name must be entered.

Pressing PF12, RETURN, when available, returns control to the invoking screen. Pressing PF3, EXIT, returns control to the point from where the Table Utility was started, the Control Center main menu or CICS.

|Functions 2 through 5 produce a job that is submitted to VSE/POWER |for execution. If you code DISP=H on the job submission screens, then |you can view, and if necessary, alter the job for your particular |environment.