The Package Utility offers four main functions:
The Unload, Reload, Rebind, and View Package Utilities all use DBSU to accomplish the desired process. For each function, Control Center generates a batch job, the appropriate DBSU commands, and includes the JCL to manage their execution. The Unload and Reload functions use LIBR, the VSE librarian, for storage and retrieval of unloaded packages. The View Package Utility uses a REXX/VSE program to produce a printed package report.
|For each of these functions, using information you supply on the |Package | | Utility menu (Figure 21), Control Center builds and submits a DBSU job.
|Control Center stores packages for this tool in a Librarian library, |SQLMSTR.PACKAGE. Periodically, you may want to delete packages |no longer needed in this library. Ask your System Programmer to do the |delete for you.
The job executes DBSU to unload the package to the VSE punch queue. It then catalogs the punch file containing the package into |SQLMSTR.PACKAGE, where it can be accessed for reloading.
The job punches the package to the VSE reader queue from |SQLMSTR.PACKAGE. It then executes DBSU to reload the package from the VSE reader queue. Options such as whether an existing package is to be replaced and whether to keep or revoke existing run privileges are supported. Optionally, you may specify a server name other than the one that is displayed.
| Note: | This function can only be used to reload packages that Control Center has unloaded. |
Optionally, you may specify that the package is only to be rebound if it is already marked as invalid. The job executes DBSU to rebind the package.
You identify the package to be viewed by specifying an owner and package name. You may specify a server name other than the one that is displayed.
In the job, the package messages are copied to a SAM file where they are accessible to the REXX/VSE package report program. Next, the package is unloaded to a SAM file, followed by the execution of a REXX/VSE program to produce the package report.
For package migration, both the Unload and Reload Package functions previously described are used. Be sure to specify the Server name field (Figure 21) when invoking the Reload function. During the job submission step, the parameter DEST must be specified. See Package Utility Parameters and Package Utility Job Submit Parameters.