DSXchange

There are only certain rightmost nybbles that you can get for a signed packed decimal number. That's why I suggested using BitAnd() function - to identify whether these are present.

Two nodes each executing the same query? Is your DB2 stage executing in parallel or sequential mode?

In a phrase, "better management".

Moderator: please move to server forum

Option 1 can be done, but Option 2 will give better throughput particularly if inter-process row buffering is enabled.

No, unless you timestamp or otherwise identify the run, and count the table beforehand and afterwards. In DataStage you can only count the number of rows SENT to the database server - whether they get inserted successfully or not is a different question. Download ETLstats, which already exists and w...

Yes, it's easy. All you have to do is to ensure that all 80 tables have identical structure, and set up a query that is the UNION of all 80. You will need RCP enabled, too.

Otherwise it's not possible within a single parallel job. Resist stupid requirements!

No.

Because you have not advised how you attempted to effect compilation.

Hmm. Are your logs in the unified repository for Information Server or in the local repository (you do have that choice)? Does double-click on the entry in Status view provide any more information? Maybe the job didn't get far enough through starting to log any entries. Are you looking at the log fo...

"Certain queries", eh? That's not very informative - could it be the ten way full outer join query from hell? How long does the same query take if DataStage is not in the mix? You will not be able to do anything in DataStage to improve this time. Parallel execution is a possibility but, in...

You can mask the final byte with the BitAnd() function.

IBM advise to upgrade to 7.5 before going to 8.x when your start point is earlier than version 6.

Is the hashed file created/populated in the same job or in a different job? If it's created in the same job then rows/sec is meaningless because it includes the wait time while the hashed file is populated. Populate the hashed file in a separate job and be prepared to be amazed.

No, not there. There is one in each project directory on the server.

In any case I have provided the decoding for you, as well as advising where to find the error codes.

Control Panel > System > Environment

However, DataStage is just another client application as far as Oracle is concerned, so you WILL need Oracle client software installed on the DataStage server.

Talk to IBM about the services they offer for grid-based high availability. There may be something there to lighten your wallet.