Job DSNTIJRT

Job DSNTIJRT installs and configures DB2®-supplied routines by executing program DSNTRIN.

DSNTIJRT provides a configuration control statement for each DB2-supplied routine and the mode for processing those statements. The configuration control statement specifies the WLM environment, list of authorization IDs that are allowed to execute the routine, and optional package owner for the routine. DSNTRIN reads and validates those statements and uses them to create and customize routines and supporting objects.

Format

DSNTRIN accepts the following parameters:

DB2SSN

Identifies the DB2 subsystem on which to install and configure the DB2-supplied routines.

MODE

During SQL processing, DSNTRIN configures each routine with the WLM environment specified in the configuration control statement for that routine. Processing behavior depends on the DSNTRIN run mode, the DB2 catalog mode, and which objects already exist.

INSTALL: This is the normal operating mode. Use it when installing or migrating to DB2.; Create, bind, and grant access to the DB2-supplied routine according to the WLMENV and GRANTTO parameters of the configuration control statement. If the routine already exists, it is updated, if necessary, to use the WLM environment specified in the configuration control statement for that routine. If the package for a routine already exists, it is not bound again unless the DBRM has been updated or the package has been invalidated. Create, initialize, and grant access to any related objects required by the routine, such as a database or created global temporary table. If a supporting object is used by more than one routine, the object is created when one of those routines is first created.
REINSTALL: This mode behaves like INSTALL mode, except that existing DB2-supplied routines and created global temporary tables are dropped ahead of other processing. Existing related databases, table spaces, tables, and indexes are not dropped, except as discussed in the special notices section of the DSNTIJRT job prolog.; Use REINSTALL mode only if you have a specific need to drop and re-create all DB2-supplied routines. Before running the job, verify that each GRANTTO statement in DSNTIJRT specifies all users who are authorized to use that routine.; In particular, use this mode to create, bind, and grant access to the DB2-supplied routine according to the WLMENV and GRANTTO parameters of the configuration control statement. If the package for a routine already exists, it is not rebound unless the DBRM has been updated or the package has been invalidated. Create, initialize, and grant access to any related objects required by the routine, such as a database or created global temporary table. Existing routines and any related created global temporary tables are first dropped before they are re-created. Related databases are not dropped if they already exist, but they are created if they do not exist. If a supporting object is used by more than one routine, the object is created when one of those routines is first created. Drop processing of routines and related objects that do not exist is bypassed.
REINITIALIZE: This mode behaves like REINSTALL mode, except that existing databases, table spaces, tables, and indexes used by the DB2-supplied routines are also dropped ahead of other processing.; REINITIALIZE mode drops and reinitializes databases such as the XSR database that may contain information needed by DB2 for other processing. Therefore, use REINITIALIZE mode only when advised to do so by IBM® Software Support. Before running the job, verify that each GRANTTO statement in DSNTIJRT specifies all users who are authorized to use that routine.; In particular, use this mode to create, bind, and grant access to the DB2-supplied routine according to the WLMENV and GRANTTO parameters of the configuration control statement. If the package for a routine already exists, it is not rebound unless the DBRM has been updated or the package has been invalidated. Create, initialize, and grant access to any related objects required by the routine, such as a database or created global temporary table. Existing routines, existing related created global temporary tables, and existing related databases are first dropped before they are re-created. After each SQL statement, a COMMIT statement is issued. If a supporting object is used by more than one routine, the object is created when one of those routines is first created.
INSTALL-PREVIEW: Simulate INSTALL mode without updating the system. Generated JCL with embedded DDL and bind statements is outputted to the JCLOUT DD statement.
REINSTALL-PREVIEW: Simulate REINSTALL mode without updating the system. Generated JCL with embedded DDL and bind statements is outputted to the JCLOUT DD statement.
REINITIALIZE-PREVIEW: Simulate REINITIALIZE mode without updating the system. Generated JCL with embedded DDL and bind statements is outputted to the JCLOUT DD statement.

AUTHID

DSNTRIN uses this value as the CURRENT SQLID for creating and configuring most DB2-supplied routines. DSNTRIN also uses this value as the default OWNER for binding packages for the DB2-supplied routines that do not have the PKGOWNER specified in the configuration control statement.

SECDEFID

DSNTRIN uses this value as the CURRENT SQLID setting when creating and configuring DB2-supplied routines that are defined with the SECURITY DEFINER option.

Start of change The ID that you specify for SECDEFID must be an ID that can be used as a logon ID, because WLM uses the ID to execute DB2-supplied routines that are defined with SECURITY DEFINER. End of change

Input

DSNTRIN allocates the following DD statements for input:

DBRMLIB

Location of the DBRMs for DB2-supplied routines. This is typically the prefix.SDSNDBRM target library.

SYSUT1

Internal work file for the DB2 installation bind interface (DSNTRBI).

CFIGIN

Location of the configuration control statements for DB2-supplied routines.

DB2OPT

This required DD can contain the following optional parameters:

STOGROUP: Specifies a storage group to use for creating databases and table spaces that are used by the routines that are supplied with DB2. If this parameter is not specified, the default SYSDEFLT storage group is used.
INDEXSTOG: Specifies a storage group to use for creating indexes instead of the default SYSDEFLT storage group.
BP4K: Specifies an alternate 4-KB buffer pool for base table spaces that are created by DSNTRIN. The default 4-KB buffer pool is BP0.
BP8K: Specifies an alternate 8-KB buffer pool for base table spaces that are created by DSNTRIN. The default 8-KB buffer pool is BP8K0.
BP16K: Specifies an alternate 16-KB buffer pool for base table spaces that are created by DSNTRIN. The default 16-KB buffer pool is BP16K0.
BP32K: Specifies an alternate 32-KB buffer pool for base table spaces that are created by DSNTRIN. The default 32-KB buffer pool is BP32K.
LOBBP8K: Specifies an alternate 8-KB buffer pool for LOB table spaces that are created by DSNTRIN. The default 8-KB buffer pool is BP8K0.
LOBBP16K: Specifies an alternate 16-KB buffer pool for LOB table spaces that are created by DSNTRIN. The default 16-KB buffer pool is BP16K0.

Note: DSNTRIN does not create or activate this storage group or any of these buffer pools.

Output

DSNTRIN allocates the following DD statements for output:

SYSPRINT: Destination for echo of configuration control statements that are read and for messages that are generated during processing. Each processed routine generates at least one status message.
SYSTSPRT: Internal message file for the DB2 installation bind interface (DSNTRBI).
CFIGOUT: Destination for configuration control statements that are read by DSNTRIN. This output is useful for diagnostic purposes when DSNTRIN reports an error in a configuration control statement.
SQLOUT: Destination for DDL statements that are generated and processed by DSNTRIN. These statements are useful for diagnostic purposes.
BINDOUT: Destination for bind statements that are generated and processed by DSNTRIN. These statements are useful for diagnostic purposes.
JCLOUT: Destination for a generated sample job that is generated when one of the PREVIEW modes is specified. The job contains steps that process inline DDL and bind statements that are needed to install and configure missing, downlevel, or incorrectly configured DB2-supplied routines. This DD is required if you specify a PREVIEW mode.

Example of executing DSNTRIN in INSTALL mode:

//DSNTRIN  EXEC PGM=DSNTRIN
//         PARM=('DB2SSN(VA1A) MODE(INSTALL) AUTHID(AUTHID) SECDEFI-
           D(ADMF001)')
//DBRMLIB  DD DISP=SHR,DSN=DSN!!0.SDSNDBRM
//SYSUT1   DD UNIT=SYSDA,SPACE=(27930,(10,5)),
//            DCB=(RECFM=FB,LRECL=133)
//SYSPRINT DD SYSOUT=*,DCB=(RECFM=FB,LRECL=133)
//SYSTSPRT DD SYSOUT=*
//CFIGOUT  DD SYSOUT=*
//SQLOUT   DD SYSOUT=*
//BINDOUT  DD SYSOUT=*
//DB2OPT   DD *
 STOGROUP(DB2_ROUTINES_GROUP)
 INDEXSTOG(DB2_INDEX_GROUP)
 BP4K(BP0)
 BP8K(BP8K0)
 BP16K(BP16K0)
 BP32K(BP32K) 
 LOBBP8K(BP8K0)
 LOBBP16K(BP16K0)
 LOBBP32K(BP32K0)
/*
//CFIGIN   DD *
  ...
SYSPROC.DSNWSPM 
WLMENV(DSNWLM_NUMTCB1)
GRANTTO(PUBLIC) 

SYSPROC.DSNWZP
WLMENV(DSNWLM_NUMTCB1)
GRANTTO(PUBLIC)
  ...
//*

Example of executing DSNTRIN in INSTALL-PREVIEW mode:

//DSNTRIN  EXEC PGM=DSNTRIN
//         PARM='DB2SSN(VA1A) MODE(INSTALL-PREVIEW) AUTHID(AUTHID)'
//DBRMLIB  DD DISP=SHR,DSN=DSN!!0.SDSNDBRM
//SYSUT1   DD UNIT=SYSDA,SPACE=(27930,(10,5)),
//            DCB=(RECFM=FB,LRECL=133)
//SYSPRINT DD SYSOUT=*,DCB=(RECFM=FB,LRECL=133)
//SYSTSPRT DD SYSOUT=*
//CFIGOUT  DD SYSOUT=*
//SQLOUT   DD SYSOUT=*
//BINDOUT  DD SYSOUT=*
//JCLOUT   DD DSN=USER.JCLLIB(DB2INST),DISP=SHR  
//DB2OPT   DD *
 STOGROUP(DB2_ROUTINES_GROUP)
 INDEXSTOG(DB2_INDEX_GROUP)
 BP4K(BP0)
 BP8K(BP8K0)
 BP16K(BP16K0)
 BP32K(BP32K) 
 LOBBP8K(BP8K0)
 LOBBP16K(BP16K0)
 LOBBP32K(BP32K0)  
/*
//CFIGIN   DD *
  ...
SYSPROC.DSNWSPM 
WLMENV(DSNWLM_NUMTCB1)
GRANTTO(PUBLIC) 

SYSPROC.DSNWZP
WLMENV(DSNWLM_NUMTCB1)
GRANTTO(PUBLIC)
  ...
//*