DSXchange

The table is RT_LOGnnn. Where in nnn is the job number. There is no DS_LOG file. Do a search there tons of posts on this topic. The way to dscribe a table in the repository is LIST DICT tablename or LIST.DICT tablename like LIST DICT RT_LOG25 There is also RT_STATUSnnn which keeps the instance ids a...

It should work then.

You need to upgrade to get this to work properly. Ds7.0 has issues. Ds7.1 was the first version where it worked correctly.

Most of these are only on the latest version and not all Ds7.x. So Ds7.5.1 I think is the latest.

Why not use a shell script or a batch file?

If you restart a sequence more than once then it gets confused and does not remember if it has run a step successfully or not. Otherwise it works as advertised.

What version of DataStage are you on? There are bugs in this in anything before Ds7.1.

It think Roy's solution makes sense. Also changing 3 seconds to 5 or 10 makes sense. I cannot image that these all have to run in the fewest seconds as possible. If so then change your design. If you are processing log files and need to do it as fast as possible then you need rotate the log file and...

Try running this command on a job that is running. Post the new results and ask us again what you do not understand because some of these should become clear as to their meaning.

You usually do not get the files corrupted because of anything but a full filesystem. "Failed to open RT_CONFIG***" "Failed to open RT_STATUS***" This sometimes can fix itself because some temp file gets removed. What usaully happens is the VOC entry gets created but the UNIX or DOS file does not. I...

How many jobs are you are starting at the same time?

We had 7.5.1 and NLS was not enabled. So I do not think this is true.

If you are on a Windows server then you can execute any exe with DSExecute including a compiled VB program. You can do the same from UNIX with a remote execute command like rsh or rexec.

Most of the files I backed up in this shell script are overwritten. So I copy them to the home directory of dsadm. It is easy to restore them back. Always when changing dsenv or one of these files then back it up in the directory with date stamp on the end. cp dsenv dsenv.20050624 The parameters are...

Here is a shell script to backup the critical UNIX files. I know this poster is on Windows but should still help. #!/bin/ksh # run as dsadm # this runs on Sun Solaris # may not work on other UNIX ## # may need to delete sudo lines ## set -x cd mkdir $HOME/SavedFiles cp .profile SavedFiles DSHOME=`ca...

1. a. Backup at OS level b. Export all jobs in all projects. c. Backup all critical DataStage files i. dsenv ii. uvconfig iii. uvodbc iv. odbc.ini 2. Do a root install Don't do a dsadm install. 3. If you have PX or other IBM products then back them up too. PX requires a database so have the Oracle c...