Start of change

Installing DB2-supplied routines during migration

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.
Start of change

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

Start of changeResource Recovery Services (RRS) is also required for these jobs.End of change

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.
End of change

Procedure

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. Begin DB2 9 to DB2 10 migration informationIf 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
    End DB2 9 migration information
  4. Start of changeIf 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.End of change

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.
End of change