Hi,
I am using the DB2 Stage as source to connect to DB2 tables. I am hitting two errors. First when I try to import the tables and second time when I try viewing the data.
I try importing the tables through "Import Plug-in Meta Data" I get this error: Unable to obtain list of available tables in server 'EMAILP2'.
I am able to connect fine on my development environment. Hence I imported the table metadata from the development enviornment and tried connecting to the tables in PROD and hit view data I get the message below. This is only happening in Prod and Test. I am able to import data and view data from Prod and Test.
OPTOut..DB2_UDB_API_10: [IBM][CLI Driver][DB2/6000] SQL0805N Package "NULLID.SYSSH200" was not found. SQLSTATE=51002
SQLExecDirect: Error executing statement 'SELECT PERMISSIONID,PERMISSIONNAMEID,EMAILADDRESSID FROM PERMISSION'. See following DB2 message for details.
OPTOut..DB2_UDB_API_10.DSLink1: DSP.Open GCI $DSP.Open error -100.
I will really appreciate any help and advice in this regards.
Thanks
Error on DB2 Stage
Moderators: chulett, rschirm, roy