CICS VSAM Transparency for z/OS, Version 1.2


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.




Last updated: December 6, 2013 20:43:18

Information Information

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


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