Verify DDM access paths

Verify that the DB2® access paths for the DDMs are correct. To generate the PLAN_TABLE data in DB2 , you specify EXPLAIN YES in the BIND model in SVIDSAMP field as shown in Figure 1 . Alternatively, you can rebind the DDM package and add the parameter EXPLAIN YES. The PLAN_TABLE rows should be as follows: You might have to refer to the output from the PRECOMP step in automated mapping job 2 to get the statement numbers referred to in the PLAN_TABLE.

Information Information

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtug_verify_ddmaccess.html