Our company is moving to DB2 v10 NFM, and I am being told that the plan associated with CA Telon must be rebound as a package. Can you provide instructions?
We do not provide specific JCL for the TNMCDB2I program. We do recommend asking your DBA for assistance as the best way to go in regards to binding a package and then a plan.
But, this is just a regular BIND package/plan… with granting access to it.
It’s described in the CA Telon Installation Guide (chapter 6, starting on page 192: Installing DB2 Catalog Access Interface).
You can also do it right in DB2 (option: package -> bind/ plan -> bind).
If you want JCL, then you may create one with IKJEFT01 in PGM and using these commands as specified in the IBM documentation here (it’s like regular CLIST commands):
http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/comref/src/tpc/db2z_cmd_bindpackage.html
http://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/comref/src/tpc/db2z_cmd_bindplan.html
We do not provide specific JCL for the TNMCDB2I program. We do have some BIND PLAN in *.CAWLINST(SQD2GEN*), which is for the training program.
But, please note: It uses MEMBER option, which is not recommended, and bind package should be used instead.