Skip to content

Skeleton changes (overview)

There are 3 main functional skeletons related to Native SQL stored procedures. These are the ones already in use for general Db2 object management, viz:

CMN$$PSQ Local promote/demote
CMN$$RSQ Remote promote/demote
CMN$$SQL Install

These have been changed to add new sections dedicated to the management of Native SQL SPs. Existing facilities have been left in place and are selected via \&DB2SUBT NE N, the new sections require \&DB2SUBT EQ N.

Additional sysin parameters are specified for the CMNDB2DD step which relate specifically to Native SQL SP management. Some of these are driven by the admin settings for the target logical subsystem and some are simply hardcoded in the skeleton.

If SP version management is required (driven via admin and the ISPF variable \&SQACTV EQ YES) then a job is submitted from this process which will activate the required version of the SP. The job makes use of the CMN$$D2J jobcard skeleton, which is filled out with information related to the physical Db2 subsystem hosting the target logical subsystem (from Global Db2 option admin). A facility is in place whereby, if not already present, a TYPRUN=HOLD parameter will be added to the jobcard (given sufficient room on the last active jobcard line). This is done by setting ISPF variable \&D2TYPR to a value of HOLD prior to imbedding CMN$$D2J, this is how the skeleton is delivered.

Use of the CMN$$SQL skeleton has been moved from CMN20 (general install) and CMN50 (general backout) to CMN21 (Db2 specific install) and CMN49 (Db2 specific backout).