The prime activity during the Bind process is determining the access path for SQL. Here’s a sample JCL explaining the other BIND activities. Here’re the terms decoded that popularly use in the BIND process.
Static SQL Access path will not change since it determines during the BIND process. The PLAN_TABLE store information on the access path.
EXPLAIN PACKAGE
It’s a newly introduced SQL query that updates package details in PLAN_TABLE.
EXPLAIN PACKAGE package-scope-specification
EXPLAIN PACKAGE COLLECTION 'APCMPCOB' PACKAGE 'APCMPCOB'
APCOMPARE and APREUSE
This option is now part of the BIND process. It compares the results of BIND PACKAGE and REBIND PACKAGE. The NO is the default. It means not for comparing. The scenario occurs when DB2 migrates to the new version and to decide whether REBIND is required or not, helpful to know.
The WARN option pops a warning message when the new access path differs. The ERROR option pops an error when the new access path mismatches and it will not BIND or REBIND.
APCOMPARE (Access path compare). APREUSE (Access path reuse).
- NO or NONE
- WARN
- ERROR
The APREUSE again has two options. The NO means no action. If it is the ERROR, and you set EXPLAIN(YES), then it replaces the stored access path with the new one.
- NO or NONE
- ERROR
Related
Srinimf 
You must be logged in to post a comment.