DB2 UDB Stage connection problems
Posted: Thu Aug 07, 2008 6:34 am
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:
At the moment I'm at a loss to figure out what I have done wrong and would appreciate any pointers.
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.