The DSNTIJRT and DSNTIJRV jobs install and validate the installation of routines that are
supplied with DB2®. 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:
- Establish a discrete profile for MVS.MCSOPER.DSNTRVFY by issuing the following command:
RDEFINE OPERCMDS MVS.MCSOPER.DSNTRVFY UACC(NONE)
- 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)
- Refresh the OPERCMDS class by issuing the following command:
SETROPTS RACLIST(OPERCMDS)REFRESH
Resource
Recovery Services (RRS) is also required for these jobs.
Important: Job DSNTIJRT defines, binds, and grants access to stored procedures and user-defined functions. The default setting for GRANT EXECUTE is PUBLIC, meaning that anyone who can access DB2 can use these stored procedures. Use the GRANT EXECUTE fields on panels DSNTIPRB through DSNTIPRP to specify different access lists when you run the installation CLISTS.
Before running job DSNTIRT, review the configuration statements under the CFIGIN DD statement to
verify the settings of the WLMENV, GRANTTO, and optional PKGOWNER parameters.
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.
Procedure
To install the DB2-supplied
routines:
- Run job DSNTIJRT to
install and configure all DB2-supplied
routines.
- After DSNTIJRT successfully completes, run job DSNTIJRV
to validate the installation of the routines.
- If you used the SYSPROC.XSR_COMPLETE stored procedure in DB2 9, then ensure that the WLM environment that is
used for running XSR_COMPLETE is updated to use the DB2 10 code paths. The following parameters in the Java
Language Environment® (JAVAENV) data set for
the WLM environment are affected:
- DB2_BASE
- JCC_HOME
- JAVA_HOME
- If you
did not perform any of the following steps when you originally installed the DB2 subsystem, complete additional setup steps for
any of the following routines that you plan to use.
What to do next
After installing the DB2-supplied
routines, you can choose to disable any of the routines that are unnecessary or unusable on your
subsystem.