Installing DB2-supplied routines during installation

The DSNTIJRT and DSNTIJRV jobs install and validate the installation of DB2®-supplied routines. These jobs are configured with the options that you specified on installation panel DSNTIPR1 and panels DSNTIPRA through DSNTIPRP.

Before you begin

If the RACF® facility class is active and a profile was defined for MVSADMIN.WLM.POLICY, the user that runs the DSNTIJRV job requires READ access. To grant READ access to a user, an administrator must submit the following command:

PERMIT MVSADMIN.WLM.POLICY CLASS(FACILITY) ID(user) ACCESS(READ)

If the RACF OPERCMDS class is active and a profile was defined for MVS™.MCSOPER.*, the user ID that runs the DSNTIJRV job requires READ access. Alternatively, you can add a discrete profile for the DSNTRVFY console that is used in this job. To add a discrete profile for the DSNTRVFY console, an administrator must complete the following steps:

1. Establish a discrete profile for MVS.MCSOPER.DSNTRVFY by issuing the following command:

   RDEFINE OPERCMDS MVS.MCSOPER.DSNTRVFY UACC(NONE)

2. Grant READ access to the user that runs the DSNTIJRV job by issuing the following command:

   PERMIT MVS.MCSOPER.DSNTRVFY CLASS(OPERCMDS) ID(user) ACCESS(READ)

3. Refresh the OPERCMDS class by issuing the following command:

   SETROPTS RACLIST(OPERCMDS)REFRESH

Resource Recovery Services (RRS) is also required for these jobs.

To install the DB2-supplied routines:

1. Run job DSNTIJRT to install and configure all DB2-supplied routines.
2. After DSNTIJRT successfully completes, run job DSNTIJRV to validate the installation of the routines.
3. Authorize the appropriate users to use one or more of these stored procedures by issuing the GRANT EXECUTE statement.

   As part of the installation process, job DSNTIJRT defines, binds, and grants access to the stored procedures and user-defined functions. Job DSNTIJRT grants EXECUTE authority to the authorization IDs that are specified for the GRANT EXECUTE fields on installation panels DSNTIPRB through DSNTIPRP. The default setting for GRANT EXECUTE is PUBLIC, meaning that anyone who can access DB2 can use these stored procedures.

   Recommendation: When you run the installation CLIST, use the GRANT EXECUTE fields on panels DSNTIPRB through DSNTIPRP to specify different access lists.
   Important: DSNAEXP can execute the EXPLAIN statement on any explainable SQL statement that is valid on the system, and the EXPLAIN output can reveal potentially sensitive information. The privileges to run DSNAEXP should therefore be granted with consideration. For example, you should avoid granting access for DSNAEXP to PUBLIC.
4. Complete additional setup steps for any of the following routines that you plan to use.
   • The stored procedures for XML schema support
   • The administrative task scheduler routines and administrative enablement routines
   • The CICS® transaction invocation procedure
   • The DSNAEXP EXPLAIN stored procedure
   • The common SQL API stored procedures
   • The WebSphere® MQ user-defined functions
   • The web service user-defined functions