DSXchange

In Server jobs use an Aggregator stage for grouping and aggregate functions.

Sort the input data for best performance.

Welcome aboard. :D

Are you using DataStage TX, or DataStage server or parallel jobs?

I am unfamiliar with TX but in the other scenarios you can import the table definition from the COBOL FD and use a Complex Flat File stage to process it.

Silly as it may sound, check also that your process has read permission to /dsadm/Ascential/DataStage/Configurations/GlxDB2ETL_Large.apt
(the parallel configuration file).

shivakumar wrote:I can not use the temporary datasets and the Temporary tables in between the Stages.

In a single job this is the case.

shivakumar wrote:I want to achieve this in a single job.

For what reason? If two jobs is the right answer, then two jobs is the right answer.

Welcome aboard. :D Try using the DataStage Repository Manager client to import the table definition through the GUI for Orchestrate, choosing the third of the three options (database). This will allow you to specify the property values in the wizard, and give you access to on-line help. It will beco...

One job in a sequence (processing 0 rows) to create the table, a second job to populate it? That would allow you to use the DB2 Enterprise stage to take full advantage of parallelism.

To expand the point ever so briefly, most email servers allow you to configure a mobile phone gateway such that an address of the form kumar_s indicated will be redirected to a pager or a mobile/cell/hand phone. As far as DataStage is concerned, it's just an email address. The clever part is done wi...

It's almost certain that internal politics will mean that the mainframe folks won't want you doing this, and insist that they push the files to your server or to some place where you can pick them up without touching their precious mainframe. DataStage server jobs can not read mainframe files direct...

You can do that with my approach too. Just re-use the invocation IDs. Keep a list of them in memory (that is, in a variable or an array), grab the first unused slot.

Or don't write it at all. Set the Transformer stage output link constraint to @FALSE, so the job is purely reading. I would expect (given that your row size is not over-large) thousands of rows per second. There are quite a few speed-ups in the functions used to access sequential files. The throughp...

You might also like to set the 64BIT_FILES configuration parameter to true (or get the support engineers to test this theory on your behalf, so as not to interrupt other things on your system) so that the intermediate table created by DataStage/SQL is also created with 64-bit pointers. Problem is th...

If you don't have DataStage installed on your system then there is no convenient way for you to receive any DataStage jobs, simple or otherwise.

There are many versions of what "Julian" means. If you mean the ordinal number of the day in the year, then the "DJ" conversion code in Oconv() will yield it. For example Oconv(InternalDate, "D4/JY") will return something like 287/2006. If you mean something else then please specify it. Perhaps look...

You can invoke UtilityRunJob from the Transformer stage. This routine is in the SDK branch. Inspect its code, it's reasonably well documented. Just don't expect fantastic performance.

In 7.0 you have to type in the name of the activity, a "." character then the name of the activity variable, for example $JobStatus or $UserStatus. There is no point-and-click available in version 7.0 alas.