Control Center Operations Guide for VSE

Invocation

There are two ways to invoke the Package Utility:

From the main menu, by selecting Option 7 (PACKAGE UTILITY), or
Directly from CICS, by typing

the Package Utility transaction ID, SQPM.

+--------------------------------------------------------------------------------+
|     mm/dd/yyyy                 CONTROL CENTER                         hh:mm:ss |
|*--------------------------     PACKAGE UTILITY     --------------------------* |
||                                                                             | |
|| DATABASE    => SQLDBA                                                       | |
||                                                                             | |
|| OWNER       => ________                 PACKAGE-NAME => ________            | |
||                                                                             | |
|| OPTION      => _ (1=UNLOAD PACKAGE            2=RELOAD PACKAGE)             | |
||                  (3=REBIND PACKAGE            4=VIEW PACKAGE)               | |
||                                                                             | |
|| **********************      OPTIONAL PARAMETERS      ********************** | |
||                                                                             | |
|| INVALID ONLY?        => 2 (1=YES/2=NO)                                      | |
||                                                                             | |
|| TO SERVER-NAME       => __________________                                  | |
||                                                                             | |
|| REPLACE/NEW          => 1 (1=REPLACE/2=NEW)                                 | |
||                                                                             | |
|| KEEP/REVOKE          => 1 (1=KEEP/2=REVOKE)                                 | |
||                                                                             | |
|*------------------------------------------------------------------ SQC16 ----* |
|                                                                                |
|PRESS ENTER TO PROCESS                                                          |
|ENTER F1=HELP F3=EXIT                                                           |
+--------------------------------------------------------------------------------+

Package Utility Parameters

The Package Utility parameters are:

Entry Field: Description
DATABASE: the name of the default or last used application server. If you enter the name of another server, you will be connected to it before proceeding.
OWNER: the ID of the person who created this package or preprocessed the program associated with it.
PACKAGE-NAME: the name of the package.
OPTION: specifies the function to be executed
INVALID ONLY?: You may want to not rebind a package that is already valid. If so, specify YES. The Package Utility will check to make sure the package is invalid before allowing a rebind job to be submitted. The default value is NO (2).
TO SERVER-NAME: Use this parameter to reload a package to a different application server. DBSU will connect to the application server and reload the package. This parameter applies only to RELOAD PACKAGE.
REPLACE/NEW: Specify REPLACE if an existing package is to be replaced by the reload. If the package does not exist, a new package will be created. NEW causes the reload to fail if a package already exists. REPLACE is the default.
KEEP/REVOKE: KEEP specifies that run authorizations are to remain in effect when the package is reloaded. REVOKE causes all existing run authorizations to be revoked. KEEP/REVOKE are only allowed with REPLACE. KEEP is the default.

Using the Package Utility

The examples below illustrate how to use the Unload and View Package functions.

To Unload a package, select Option 1 on the Package Utility screen (Figure 21). Identify the package to be unloaded by specifying the owner and package name. Optionally, you may specify a server name other than the one that is displayed. If the package does not exist, you will receive a message in the lower left hand corner of menu.

After you press ENTER while viewing the Package Utility screen, the Package Job Submit screen, Figure 22, is displayed. This is where you specify the parameters for job submission to the VSE/POWER queue.

Figure 22. Package Job Submit Screen

+--------------------------------------------------------------------------------+
|     mm/dd/yyyy                 CONTROL CENTER                         hh:mm:ss |
|*------------------------- PACKAGE JOB SUBMIT SCREEN -------------------------* |
||                                                                             | |
|| JOBNAME   => ________                CLASS   => A                           | |
||                                                                             | |
|| PRI       => 3                       DISP    => D (D,H,L,K)                 | |
||                                                                             | |
|| FROM      => ________                                                       | |
||                                                                             | |
|| DUETIME   => ____ (HHMM)             DUEDATE => ______ (AABBYY)             | |
||                                                                             | |
|| DUEDAY    => __________________________________________                     | |
||                                                                             | |
||                                                                             | |
|| OTHER     => ______________________________________________________________ | |
||                                                                             | |
|| LST CLASS => A                                                              | |
||                                                                             | |
|| DEST      => ________                                                       | |
||                                                                             | |
||                                                                             | |
|*------------------------------------------------------------------ SQC17 ----* |
|                                                                                |
|PRESS ENTER TO PROCESS                                                          |
|ENTER F1=HELP F3=EXIT                                                           |
+--------------------------------------------------------------------------------+

Package Utility Job Submit Parameters

The job submission parameters are:

Parameter

Description

JOBNAME

Specifies the name by which the DBSPACE REORGANIZATION 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 (OPTIONAL).

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

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

LST CLASS

defines the class to be assigned to printed output. Specify any letter of the alphabet, or any number 0 through 9.

DEST

specifies the node-id where VSE/POWER is to route the RELOAD PACKAGE job for processing. Specify the name of an applicable node as defined to VSE/POWER with the PNODE macro. This parameter allows you to migrate a package from a local application server to an application server running on a remote system.

How to View a Package

To view a package, specify the OWNER and PACKAGE_NAME fields on the Package Utility screen (Figure 21), and select Option 4. Provide appropriate parameters on the Package Job Submit screen. The View Package tool executes DBSU to unload the desired package to a SAM file. It then generates a package report that lets you view the package contents which include:

Preprocessing Information
Each SQL statement used in the associated program
Information about its corresponding host variables

This data is quite helpful and can be used to analyze performance problems.

Figure 23 shows a report generated from the View Package option.

Figure 23. Example Output from View Package Option

Date: dd Mmm yyyy Page: 1 Control Center Package Report _____________________________ Package: SQLMSTR.SQC05 Database: SQLDBA First Create Release: 7.1 Last Create Release: 7.1 Charname: INTERNATIONAL Sections: 6 Preprocessing Characteristics: _______________________________ NOGRAPHIC, BLOCK, NOMODIFY, NODESCRIBE Options Specified at Prep time: ________________________________ BLock ISOLation(RR) DEFAULT Options at Prep time: ______________________________ RELease(COMMIT), EXPLAIN(NO), KEEP, REPLACE, NOEXIST NOCHECK, PERiod, APOST PREPname=SQC05, CTOKEN(NO), LABEL( ) Static SQL Statements in Package: __________________________________ SELECT NPAGES, POOL INTO :H, :H FROM SYSTEM.SYSDBSPACES WHERE OWNER :H AND DBSPACENAME = :H SELECT OWNER FROM SYSTEM.SYSDBSPACES WHERE OWNER = :H AND DBSPACETYPE = :H AND NPAGES = :H AND POOL IN (:H,:H) SELECT OWNER INTO :H FROM SYSTEM.SYSDBSPACES WHERE OWNER = :H AND DBSPACENAME = :H SELECT VALUE INTO :H FROM SYSTEM.SYSOPTIONS WHERE SQLOPTION = 'RELEASE' SELECT CURRENT SERVER INTO :H FROM SYSTEM.SYSOPTIONS WHERE SQLOPTION = 'RELEASE'