Verifying that installation or migration was successful with the sample applications

You can use the DB2® DB2 10 sample applications to verify either installation or migration to new-function mode. These sample applications are also called installation verification procedures (IVPs).

About this task

Attention: Do not run the DB2 10 IVP jobs unless your subsystems are in DB2 10 new-function mode.
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.
  • Start of changeAfter you designate a client and server subsystem, run all verification jobs on the same client and server subsystems. End of change
Start of change

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

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.