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:
- All DELETE statements should have an ACCESSTYPE of R.
- All INSERT statements should have an unspecified ACCESSTYPE.
- All other rows should have an ACCESSTYPE of I.
- There should be no sort activity.
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.