DSXchange

Shared containers may have their own parameters. Local containers do not have parameters, since they are part of the job rather than being a stored-alone component.

Before killing the process, you might like to check (with an lsof command) that it is a DataStage process. Also use ipcs -m | grep ade to make sure that there are no DataStage processes after you've shut DataStage down, then a restart should be fine. Did you search? There are 65 hits on netstat alon...

You are right that server jobs must run on a single machine, however this can have lots of CPUs and it is possible to implement both pipeline and partition parallelism in server jobs. However, this must be designed, and does not automatically scale if, for example, one desires to assign more process...

It's exactly what I described earlier. Now search for netstat and how to free those processes so that dsrpcd can bind to port number 31538.

That is incomplete advice. After starting DataStage you should check that the dsrpcd process is running. ps -ef | grep dsrpcd | grep -v grep If it is not, then you must find out why. Usually this involved the netstat command, to determine whether there are any connected DataStage processes preventin...

Just add the timestamp into the wildcard.

Have you searched for 81016 on the forum? You might also search for ways to debug why the RPC daemon may not be starting ("-d9" will help, so might "netstat", so might "BOMBED").

You claim to be using the mainframe version of DataStage. You can view the generated COBOL and JCL after generating them via the view menu. Their location is configurable via options in the Designer client. However, you have posted on the DataStage TX forum, which has nothing whatsoever to do with D...

Shelfware?

The Transformer stage is in the job design posted. You haven't really contributed anything beneficial.

Use Code tags for formatting job designs, it's so much neater. If you're going to update hashed files in "real time", then you need not only to disable read cache but also to lock for updates and to disable write cache in the other Hashed File stage. This has been discussed before. Search, perhaps, ...

Unless you have version 8 (which has not been released yet) your Repository is NOT in DB2. Your original post specified version 6.x; our answers are based on that. There is one Repository per project. It exists on the same machine as the DataStage server, and uses DataStage as its database. You can ...

Either of the above ls commands will give you the latest, whatever it is. Learn some UNIX. The -t option for ls sorts by date/time (by default date/time modified, but you can change the default with -c or -u options). If you want to filter further on date/time, you could use the find command.

Please explain how a data collector is supposed to help execute the SQL in an Oracle Enterprise stage? The whole rationale of the Enterprise stage types is to operate in parallel with partitioned tables. I believe that the advice you have given is at best misleading, but more probably totally incorr...

I trust that you don't omit quote characters from string literals when someone is paying for your services! As well as being syntactically incorrect, your "solution" does not address the original poster's requirement for "/" as the delimiter character in the date. Your additional 4 (in "D4") is redu...