Control Center Operations Guide for VSE

DBSPACE Analysis Submit Screen

Figure 12 shows the DBSPACE Analysis SUBMIT screen.

Figure 12. DBSPACE Analysis Submit Screen

+--------------------------------------------------------------------------------+
|     mm/dd/yyyy                 CONTROL CENTER                         hh:mm:ss |
|*-------------------------- DBSPACE ANALYSIS SUBMIT --------------------------* |
||                                                                             | |
|| ********************      VSE/POWER JOB PARAMETERS      ******************* | |
||                                                                             | |
|| JOBNAME   => ________  CLASS ===> A   PRI => 3   DISP ====> D   (D,H,L,K)   | |
||                                                                             | |
|| FROM      => VS02      DUETIME => ____ (HHMM)    DUEDATE => ______ (AABBYY) | |
||                                                                             | |
|| DUEDAY    => __________________________________________                     | |
||                                                                             | |
|| OTHER     => ______________________________________________________________ | |
||                                                                             | |
|| **************************      JOB OPTIONS      ************************** | |
||                                                                             | |
|| UPDATE ALL STATISTICS => 2 (1=YES/2=NO)          REBIND PACKAGES => 1 (1/2) | |
||                                                                             | |
|| COMMITCOUNT           => __________                                         | |
||                                                                             | |
|| TLBL FILE-ID          => _________________       FILE #          => 2 (1-3) | |
|*------------------------------------------------------------------ SQC10 ----* |
|                                                                                |
|PRESS ENTER TO SUBMIT                                                           |
|ENTER F1=HELP F3=EXIT F12=CANCEL                                                |
+--------------------------------------------------------------------------------+

Refer to the IBM VSE/POWER Installation and Operations Guide for use of the job submit parameters. The parameters in the JOB OPTIONS section are for use by the individual Update Statistics or reorganization jobs. These are explained below. Note that only the UPDATE ALL STATISTICS parameter is applicable to the Update Statistics function.

Parameter

Description

JOBNAME

Specifies the name by which the DBSPACE ANALYSIS job and its associated queue entries is to be known.

CLASS

Specifies the class or partition in which you want this job to run. Class defaults to A.

PRI

Specifies the priority that is to be assigned to the job. Specify a number from 0 to 9 where 9 is the highest priority. Default priority is 3.

DISP

Specifies how the job is to be handled in the reader queue. Disposition may be specified as:

• D - Delete after processing
• H - Hold until released
• K - Keep after processing
• L - Leave in the queue

Disposition defaults to D.

FROM

Specifies the ID of the user being allowed to manipulate or retrieve the job. Defaults to the CICS user ID.

DUETIME

Specifies the processing start time using hh for hour and mm for minute in 24-hour clock time.

DUEDATE

Specifies the processing date using YY for year. Depending on the format defined for your system, AA is month and BB is day, or AA is day and BB is month.

DUEDAY

Specifies the day(s) the job is to be scheduled. You may enter a day name abbreviation such as MON for Monday, or a list separated by commas and enclosed in single quotes (apostrophes). You may also enter the day of the month or a list of day numbers separated by commas and enclosed in quotes. You may also specify DAILY to schedule the job every day of the year.

OTHER

The VSE/POWER * $$ JOB card offers many parameters that do not appear on the DBSPACE ANALYSIS SUBMIT screen. Use this field to have Control Center include those parameters when the job is submitted.

VSE/POWER Job Parameters

DBSPACE Analysis Job Options

Parameter

Description

UPDATE ALL STATISTICS

Specifies whether an UPDATE ALL STATISTICS command should be executed instead of merely an UPDATE STATISTICS. It applies to Update Statistics jobs as well as the reorganization jobs. The default value is 2 (NO).

REBIND PACKAGES

Specifies by 2 (NO) that the DBSPACE Reorganization tool should

not rebind packages as part of a DBSPACE reorganization. The default is 1 (YES), which means rebinding will occur.

TAPE FILE NAME

Identifies a tape file name that is to receive the output of the UNLOAD, rather than a disk file. The file name should have been defined to Control Center using the Work File Label Definition function. See Chapter 6, Work File Label Definition Tool.

FILE #

Defines which of the previously defined data and DDL files (See How the Work File Label Definition Tool Works ) is to be used for the unloaded data and DDL. Valid values are 1, 2, or 3.