Load failure for TNMCDB2I

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

 

Introduction:

Import a Table from the DB2 Catalog, into the Telon Design Facility. 

Question:

When I try and Import a DB2 Table from the DB2 catalog, using a CA D2 command in Option 2 Data Administration when within the Telon Design Facility, I am getting a Load Failure with an abend S806(member not in indicated library).

Environment: 

Any version of DB2 with a supported version/release of Telon
 

 

Answer: 

After you have made your source changes to # DB2ICOB, that are shop specfic, and then recompiling your #DB2ICOB, and creating an executable of TNMCDB2I using:
 
LINKAGE EDITOR CONTROL CARDS
  INCLUDE SYSLIB(DSNELI)    
  ENTRY TNMCDB2I            
  NAME TNMCDB2I(R)          
 
do a bind of the Package and a Bind of the Plan.
Copy your new TNMCDB2I module into your CAWLOAD, as when you do a CA D2 in the TDF, it will search your TNSYSLIB file at runtime.
Or if you created a separate Loadlib, you can concatenate your new loadlib to the ALLOC F(TNSYSLIB) 

 

Additional Information:

CREATE A PLAN USING THE DBRM FROM THIS MODULE          
                                                       
 THIS PLAN CAN BE ANY NAME, AND MUST BE AUTHORIZED FOR 
 EXECUTION (NOT FOR MODIFICATION) BY ANY TELON USER WHO
 MAY USE OPTION 2 OF THE TDF TO ACCESS THE DB2 CATALOG.
                                                       
                                                       
MODIFY THE TDF CLIST TO EXECUTE THE TDF UNDER THE DSN  
COMMAND PROCESSOR USING THE ABOVE PLAN