DSXchange

Did you use the schema from the table definition as found on that Oracle box or did you hand code it? I doubt any properly defined date column on Oracle would reflect a 00 month/day value.

Did you source your dsenv settings?


$DSHOME/bin/dsjob -logdetail proj jobname.invocation

You'll save yourself a TON of headaches if you make it login.

You will find that you will sometimes need to SSH into that ID from your admin id. (Assuming that you are talking about a PROJECT specific user id and not an administrative ID like dsadm.)

Are you an admin for your DataStage setup? There are a bunch of standard maintenance activities to be proactive. There are things unique to your company that need to be identified. There are technical and political activities that need to be monitored. It's funny that you mention this topic because ...

Your admin will make a recommendation after he talks to your application team and understands their log needs.

IF this is the issue of course.

Ask your datastage admin to look at the log purging setting in your project. Under the Administrator tool, have him log in and tell you how the logs are purged. There are two different settings. 1 is age based. Deleting log files or entries older than X amount of days. The other is iteration based. ...

How is a manual cut and paste and a file edit an "Automatic" activity? My 2 cents: To automate the activity as the OP (back in 2012) originally asked, I would modify the job to output a 1 row dataset. I would then write an after job routine to use the orchadmin command to dump the schema o...

Good luck on your new gig Ernie!

It was always nice running into you at the IBM conference and occasional visit to whichever company I was working for at the time.

More is not always better. Look to see how you are accessing that target Oracle system. Are you doing updates? Are you using bulk load? Is the table truncated before you are loading it? Is your data pre-sorted based upon the keys of your table? Any locks on that table during your load time? Have you...

If a person wanted to track the scratch disk usage... they could set up a before and after job script to basically do a "df /themount >>/path/jobname_themount.log"; sleep 30; repeat. Make it a background task with a file watcher to terminate the job if that file is present. In your after j...

well... why not make a protected project and only have a very limited quantity of user ids that can deploy code to that project.

If you automate the deployment via shell scripting, you can do away with the need to "lock" jobs, because the project is protected.

When adding the Oracle paths to your DSENV setup, please be aware that you need to make sure that you append the oracle client paths to PATH and not to stick them in the front of PATH. export PATH=$PATH:/yourOraclePathHere and not export PATH=/yourOraclePathHere:$PATH Oracle client has a binary call...

2) installing DataStage does not install any C compilers.

Your issues are complex enough to reach out to IBM support rather than armchair quarterbacks on DSXchange.

I swear they were not there last week.

HA

Thanks

Undraleu By Coeurdata. We have started using it. Trying to integrate it into our Jenkins CICD flow. Their upcoming release next week should have a Jenkins plugin. It scans xmeta for a Rules Based generic standards check. It can't obviously check for any business logic errors. Web based URL UI. Outpu...