CMNDB2SL
Program CMNDB2SL runs at promote, demote, install, and backout to recycle stored procedures and user defined functions that have been changed. This program searches the Db2 catalog for procedures and functions defined on an external (load module) name. It uses the VARY WLM...REFRESH command to recycle these objects in the WLM-managed address space.
This table shows the skeletons that include program CMNDB2SL and where those skeletons are used.
| Skeleton | ...embedded in skeletons | Skeleton Description |
|---|---|---|
| CMN$$PST | CMN$$PRM | Perform promotion or demotion to local sites. |
| CMNIMPRM | IMS Option: Perform promotion or demotion to local sites. | |
| CMNRPMCR | Perform promotion or demotion to remote sites. | |
| CMN$$STP | CMN20/CMN20I | Used to perform Db2 binds and/or ddl processing for installation of packages into production libraries and Db2 catalogs. |
| CMN50/CMN50I | Used to perform Db2 binds and/or DDL processing for backout of packages from production libraries and Db2 catalogs. |
Keyword Options
This table describes the keyword options that control the behavior or program CMNDB2SL.
| Keyword | Description |
|---|---|
| TEST= | Program trace facility. Valid values: YES/NO Default: NO |
| DB2ID= | Db2 subsystem ID to which Db2 commands should be presented. The DB2ID keyword control statement must precede one or more MBR keyword control statements. |
| WLMENVMASK= | WLM application environment mask. |
| MBR= | External (load module) name of stored procedure or user defined function to be recycled. |
A new DB2ID control statement makes program CMNDB2SL disconnect from the current subsystem and connect to the new one. The number of MBR control statements that follow a DB2ID control statement is not limited.
Return Codes and Messages
| Return Code | Description |
|---|---|
| 00 | Success |
| 04 | Warnings Issued |
| 08 | Command errors |
| 12 | Parameter errors |
| 16 | Other unrecoverable errors |