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: February 8, 2013 20:43:1