Page 1 of 1

Unable to connect DB2 through DB2 UDB

Posted: Wed Apr 16, 2008 4:16 am
by RudreshEswarappa
Hi all,

I am trying to populate data to DB2 table through DB2 UDB stage. I should load bulk data, so i choosed the same stage. In the properties, i have given user-id, password, tablename and so on. But somewhere, i am missing the actual connection. Actual connection is not happening. It is showing the error as, Invalid pointer to stage user data. The log is telling:

Internal Error: Function 'get_stage_prop' failed.

Error opening file in 'Directory for Data and Command Files'

Can you please tell what additional settings i need to make.

Thanks in Advance...

Rudresh

Re: Unable to connect DB2 through DB2 UDB

Posted: Wed Apr 16, 2008 7:27 am
by Klaus Schaefer
The DB2 UDB stage does not do bulk loading - please refere to the manual. For bulk loading you have to use the separate db2 bulk load stage.

Best regards
Klaus

Posted: Thu Apr 17, 2008 4:25 am
by RudreshEswarappa
Thanks a Lot


Regards
Rudresh