Unable to connect DB2 through DB2 UDB

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
RudreshEswarappa
Participant
Posts: 21
Joined: Wed Aug 29, 2007 1:33 am
Location: Bangalore
Contact:

Unable to connect DB2 through DB2 UDB

Post 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
Klaus Schaefer
Participant
Posts: 94
Joined: Wed May 08, 2002 8:44 am
Location: Germany
Contact:

Re: Unable to connect DB2 through DB2 UDB

Post 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
RudreshEswarappa
Participant
Posts: 21
Joined: Wed Aug 29, 2007 1:33 am
Location: Bangalore
Contact:

Post by RudreshEswarappa »

Thanks a Lot


Regards
Rudresh
Rudresh Eswarappa
Post Reply