DSXchange

I'm sure you mean "cron", ram.m; and one still needs to execute the "dsjob" from the cron scheduler.

Why don't you use the suggestion that Kumar had? I use the filter stage to tar / gzip / compress / sort all the time? The filter uses a pipe, so doesn't add unnecesary disk I/O or even a lot of overhead to the job.

Santosh,

that's the way I've used it before in the past, as far as I know IBM/Ascential don't have any other method to do this from a web server.

Ravi, no, I can't comment. The samples are still far too small to make any sort of an analysis. If you have just one transform stage have you looked at the %CPU usage (in the job's log)? If you are testing on a system that isn't overloaded, you will only get a performance benefit by using parallel s...

You should open up the BASIC pdf handbook to get the description of the functions used. They are OPENSEQ , CREATE , WEOFSEQ and CLOSESEQ . The code as you pasted will not compile, for example the compiler won't accept "<FileName>", perhaps you made that change before posting it here? Basically, the ...

I don't think you've quite understood what the link partitioner is there to achieve. I will split your data stream into 1 or more processes that run in parallel. Your example used a link partitioner to split a single stream into.... a single stream. So effectively this partitioner has done nothing t...

The dsenv file is located in the DataStage master directory. If you have DSENV set you can "cd $DSENV" or you can issue a "cd `cat /.dshome`" UNIX command to attach there.

dev, welcome to DSXchange! You really need to supply some more information on what is happening in your case - you've done the car equivalent of driving into a car repair shop, walking to the mechanic and pointing at your saying "It sometimes doesn't run well, can you fix it?" Do you have an NLS ins...

You should look at the DataStage Administrator Guide starting on page 3-2 to get an idea of how user roles work in DataStage. It shouldn't be necessary to work with changing UNIX level permissions unless you have had an incorrect umask setting or have changed groups around. I haven't seen the repeat...

Since you are on Windows you probably MS Query installed (or can install it if you don't); can you access your DB2 tables on the AS400 using your ODBC connection and MS Query? If not, you should re-check your system DSN setting and ODBC configuration; if you can access the database then perhaps you ...

Anil, have you tried using the IP address? Please give the exact error message you are getting, it will help narrow down the problem.

Also, can you ping the hostname or ip address from you Windows client using the DOS window?

Ravi, I have two main points to make: 1. Your runtime of 3-4 seconds is far too short to get any meaningful speeds for performance measurement. The startup and finish times are a large chunk of this and small differences in system load will make huge differences in measurement times. Use a job runti...

Are you using the same UserId on both? As loveojha2 has already pointed out, the DSParams file entries might be part of the reason - especially since the job compiles & runs as this file is used to get the valid command list for the designer. Do any of the other @ mnemonics also show up red (i.e...

I would expect the DSParams setting to be the same across all client sessions - that is an odd error. Have you been applying different IBM/Ascential or Microsoft fix packs to the workstations?