Need to rebind Telon DBRM as a package

Document ID : KB000011653
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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?

Answer:

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

Additional Information:

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.