DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
patricksfxc
Participant



Joined: 16 Apr 2020
Posts: 1

Points: 18

Post Posted: Thu Apr 16, 2020 10:39 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: IBM Datastage Designer run in WM Player
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



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1310

Points: 8608

Post Posted: Thu Apr 16, 2020 4:31 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours