DB2 UDB Stage connection problems

[ArndW]

I am trying to connect from an AIX box to a DB2 instance on a remote AIX box. I can successfully connect from the command line using "db2 connect to WCCINST1 using ...". I've added and modified the $DSHOME/.odbc.ini entry for WCCINST1 and also changed the "uvodbc.config" file to add this entry. From the UniVerse TCL prompt I can do a "CONNECT WCCINST1..." and execute queries.

But from the DataStage Designer DB2 UDB stage view data command, I get the following error message:

Code: Select all

Input_WCC_KDNR_DB2..DB2_WCC_Native_Key_KDNR: SQLAllocHandle: Failed to allocate environment handle 'ENV'. 
Input_WCC_KDNR_DB2..DB2_WCC_Native_Key_KDNR.DSLink1: DSP.Open GCI $DSP.Open error -100.

At the moment I'm at a loss to figure out what I have done wrong and would appreciate any pointers.