Testing Db2 Programs

Testing a Db2 program is not different from testing other programs. For a Db2 program, the Db2 Subsystem ID and Db2 plan to be used must be setup in the repository. The DB2 Subsystem ID and DB2 plan can be setup at the Environment, at a System and at the Component itself. The values defined at the Component will override the values from the System that will override the values from the Environment.

When the Db2 Subsystem ID and plan has been defined in one or more of the above, test scenarios can be created and executed for the program without considering Db2 settings. Below we see the Db2 settings for a Component where the default values from the Environment or System has been overridden by the component itself.

image2021-8-17_22-10-29.png

Important

When using the CALL Attach Facility, do not supply a value for the DB2 Subsystem ID and DB2 plan fields. This will make the component run using the component programs directly. Make sure to include the Db2 load libraries in the Load Libraries under the Runtime parameters section of the component setup.

This section provides information about the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*