Verifying successful Db2 12 installation or migration with sample applications

Start of changeYou can use the Db2 Db2 12 sample applications to verify the operation of Db2 after installation or new function activation. These sample applications are also called installation verification procedures (IVPs).End of change

Start of change

Before you begin

Attention:

When migrating from Db2 11, do not run the Db2 12 IVP jobs before activating new function as described in Activating Db2 12 new function at migration. Start of changeThat is, activate function level V12R1M500 or V12R1M501 before running the Db2 12 IVP jobs.End of change

Until you complete this task, continue to use sample applications such as DSNTIAUL, DSNTEP2, and DSNTEP4 from Db2 11.

End of change

About this task

Recommendations:
  • During verification, run all sample applications under the same user ID. This user ID must have SYSADM authority. Otherwise, errors might occur.
  • Run the IVP jobs with Db2 started in unrestricted mode because restricted mode (ACCESS(MAINT)) does not allow use of stored procedures and user-defined functions.
  • If you are installing a data sharing group, run the IVP jobs after you install or migrate the originating system. You do not need to run the IVP jobs after you enable the originating system or after you install a new data sharing member.
  • You must use the same compiler for each job. For example, if you use IBMCOB for DSNTEJ2C, you must use IBMCOB for all COBOL verification programs.
  • After you designate a client and server subsystem, run all verification jobs on the same client and server subsystems.

Procedure

To verify a successful installation or migration:

  1. For testing purposes, identify one local subsystem to act as the client and one remote subsystem to act as the server. Both subsystems must be at Db2 12.
    Although not recommended, the client and server subsystem can be the same if a remote subsystem is not available for testing.
  2. Ensure that the client subsystem is specified in the Db2 LOCATION NAME field of installation panel DSNTIPR.
  3. Ensure that the server subsystem is specified in the REMOTE LOCATION field of installation panel DSNTIPY.
  4. Identify the IVP jobs that you need to run based on the attachment facilities you installed, the languages you use, and whether the sample objects exist.
  5. Edit the sample jobs as necessary based on the information that is provided for the jobs.
  6. Run the necessary IVP jobs.

What to do next

When you complete the verification procedure, save the verification objects. You will need them when you migrate to the next release of Db2.