DSXchange

Tell them Kumar man.

The message file is empty because the db2 load utility was never invoked. It gave you the Temp error before it could even get to the db2 load utility. The datastage db2 load stage is nothing but a wrapper to the db2's load utility. And the message file contains logs from the db2 load utility. Since ...

Try to search for the error message/db2 bulk loader. Every one of us who used the bulk loader for the first time had one issue or the other with it in fixing permissions, getting the directories paths properly stated, getting all the properties right. Do a search and you will get the solution to all...

Load immediate and load from client, both these properties need to be set to Yes.

If you absolutely have to use the hashed files, then you can use a server job which is not advisable unless the job is small. The other way is to build a lookup file set just the way you built the hashed file. You can also load the contents of the hashed file into a sequential file in a server job a...

There is no specific document to maintain datastage. You need to be aware of the architecture that your application is running on and benchmark the jobs to see the performance. As far as maintaining the jobs is concerned, you can do that on a monthly basis. Bottom line. There are no guidelines writt...

As pointed out, Aggregator cannot aggregate accross columns. For that you need a transformer. The only other option that i can think of right now is to do it in the sql itself if your source is a database by writing your own sql.

Ray, i get the first aggregator which is to do normal aggregations based on the grouped keys.
I get the transformer to get the aggregations of the columns across. But whats the purpose of the last aggregator?

Ofcourse its possible. First do a normal aggregation with the aggregator grouped on the keys. This will leave you with all unique combinations of the keys. Then you can add the columns in the transformer itself into just one column. There you go. Its done.

Build a routine that executes a TCL command with sequence_name as a variable. Have all the sequence names in a sequential file and feed them to the routine in a transformer.

Or, you can also get the max value from job1, load it into a hashed file with a dummy key and access that hashed file with the dummy key in your second job.

Increase the array size to about 250. See how does that effect the performance.

You cannot compile them. Only reset them. and the command to do it is
dsjob -reset Project JobName

Do an exact search on "add_to_heap() - Unable to allocate memory" and you will find several posts regarding your query.

Congratulations Ray. Yet again, you accomplished another milestone. Hats off to you mate.