Installation and migration jobs that the CLIST tailors

When SYSINSTL is specified on panel DSNTIPG, the installation CLIST performs the following additional changes:

• All BIND statements specify the package owner as entered in the INSTALL PKG OWNER field.
• All dynamic SQL streams begin with the SET CURRENT SQLID 'SYSINSTL' statement.
• All CREATE TABLE and CREATE INDEX statements are stripped of the creator name and preceded (as a group) by a SET CURRENT SCHEMA statement to indicate the creator.
• The following notice is added to the prolog of each affected job. Itemized statements are individually included or excluded, as applicable:

//* NOTICE: This job must be run by a user ID with DB2 Installation  
//*         System Operator authority because it has been customized 
//*         as follows for performing DB2 installation or migration  
//*         without DB2 System Administrator authority:              
//*         - Dynamic SQL processing is performed with the current   
//*           SQL ID set to SYSINSTL                                 
//*         - DSNTIAD runs with PLAN(DSNTIAIN)                       
//*         - Creator IDs are removed from create statements for     
//*           tables and indexes                                     
//*         - SET CURRENT SCHEMA statements are added to provide     
//*           the necessary creator IDs for these objects            
//*

Additional tailoring is performed on job DSNTIJTM for SYSINSTL. For example, the job prepares and binds DSNTIAD, a program for processing executable dynamic SQL statements. It uses a version-specific naming convention of DSNTIAnn, where nn is 12, 11, or 10, to bind a package and plan for DSNTIAD. When configured for SYSINSTL, job DSNTIJTM binds an additional DSNTIAD package and plan, both named DSNTIAIN. No access is granted on the DSNTIAIN package or plan.