View Data from a DB2 Connector

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
patricksfxc
Participant
Posts: 1
Joined: Thu Apr 16, 2020 10:20 am

View Data from a DB2 Connector

Post by patricksfxc »

Dear all,

I have finished a intesive course in Datastage from scratch in 4 days. There is a technical problem when I was working with the DB2 Connector. Whenever I want to view the data from the database, the following message shows up and I couldn't view data at all. Any ideas why this message always shows up?

Thank you all in advanced!


https://www.dropbox.com/s/n8zjb3tjs59yssz/error.JPG
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Well, that does not give us a lot to go on.

Here is what happens (roughly) under the covers.

The datastage engine submits a dummy job to connect to that data repository. it also dumps a temp file or two to a path defined by APT_VIEWDATA_TEMP_DIR or if that is not set, then it defaults to your project path.

So, your user id needs to have access to the project (which you do since you can see the job), but you also need write access to that project path, and the ability to execute a job. Or write access to that view data temp dir path.
Post Reply