Control Center Operations Guide for VSE

DBSPACE Reorganization Submit Screen

Figure 6 shows the DBSPACE Reorganization Submit screen.

Figure 6. DBSPACE REORGANIZATION SUBMIT screen

+--------------------------------------------------------------------------------+
|     mm/dd/yyyy                 CONTROL CENTER                         hh:mm:ss |
|*------------------------     DBSPACE REORG SUBMIT   -------------------------* |
|| *******************       VSE/POWER JOB PARAMETERS       ****************** | |
||                                                                             | |
|| JOBNAME   => ________  CLASS ===> A   PRI => 3   DISP ====> D   (D,H,L,K)   | |
||                                                                             | |
|| FROM      => ________  DUETIME => ____ (HHMM)    DUEDATE => ______ (AABBYY) | |
||                                                                             | |
|| DUEDAY    => __________________________________________ (DAY NAMES/NUMBERS) | |
||                                                                             | |
|| OTHER     => ______________________________________________________________ | |
||                                                                             | |
||                                                                             | |
||                                                                             | |
|| ----------------        SINGLE USER MODE PARAMETERS       ----------------- | |
||                                                                             | |
|| SUM?    => 2 (1=YES/2=NO)            DATABASE DEFINITION PROC => ________   | |
||                                                                             | |
|| LOGMODE => _ (L,A,Y,N)     NDIRBUF => ______          NPAGBUF => ______     | |
||                                                                             | |
|*------------------------------------------------------------------ SQC06 ----* |
|                                                                                |
|PRESS ENTER TO SUBMIT                                                           |
|ENTER F1=HELP F3=EXIT F12=CANCEL                                                |
+--------------------------------------------------------------------------------+

To reach this screen, press ENTER from the Control Center DBSPACE REORGANIZATION screen.

The first parameter, JOBNAME, is the only one that is required.

VSE/POWER Parameters

Parameter

Description

JOBNAME

Specifies the name by which the DBSPACE REORGANIZATION job and its associated VSE/POWER 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 (OPTIONAL). |This can only be 0001 through 2359.

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 (OPTIONAL). |No check is made for invalid leap days nor passed dates.

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 (OPTIONAL).

OTHER

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

After entering the desired submit parameters, press ENTER to submit the job to VSE/POWER. For more information on VSE/POWER jobs, refer to the VSE/POWER Installation and Operations Guide.

Figure 7 is a sample of the DBREORG Report.

Figure 7. DBSPACE Reorganization Report

SQB02 CONTROL CENTER FOR VSE hh:mm:ss DBSPACE REORGANIZATION REPORT mm/dd/yyyy DBSPACE 1 DBSPACE 2 ------------------ ------------------ DATABASE: SQLDBA SQLDBA OWNER: PUBLIC PUBLIC DBSPACENAME: SQMHELP SQMHELP BEFORE REORG STATISTICS AFTER REORG STATISTICS ----------------------------------- ----------------------------------- DBSPACENO: 12 12 POOL: 1 1 NPAGES: 128 128 NRHEADER: 1 1 PCTINDX: 33 33 FREEPCT: 0 0 LOCKMODE: PAGE PAGE NACTIVE: 39 39 NTABS: 1 1 ELAPSED TIMES IN MINUTES ------------------------------------ UNLOAD DBSPACE: 00:00:07 RELOAD DBSPACE: 00:00:08 TOTAL ELAPSED TIME: 00:00:15 SQLMAINT TABLE HAS BEEN SUCCESSFULLY UPDATED.