DSXchange

Make a test copy of the job and remove the 3 transform stages. Does it still take 4 hours to compile?

the number of bits (32 or 64) defines the largest addressable size, so the answer would be 2^^31 for 32 bit systems and 2^^63 for 64 bits systems; thus the answer is 9223372036854775808

Is the xDAC0 (part of the high surrogates, probably user-defined area) actually in your data stream? If so, the warning is valid as there is no defined mapping for that character.

Are both GRGR_ID and GRGR_SELL_OVER_DT marked as key columns in the reference link?

Try running "LIST DS_JOBS WITH JOBNO EQ 1982" to get the job associated with the error, then edit it, do a "SAVE AS" another name and compile that job. Delete the original and re-name the copy back to the original and re-schedule that job. The error should be gone.

While I'm not sure what the problem could be, it would be helpful if you were to change your charset to something else to see if the error messages persist. Is the MQ queue you are reading in another character set, i.e. coming from a host and in EBCDIC?

We had a similar requirement in the last project and, after much deliberation, it was decided that the only safe method was to increase the queue depth and ensure that the queue reading process worked faster. Putting a sleep or intentional slowdown in DataStage jobs is not usually a good idea. If yo...

Ummm.. what is wrong with using a DataStage "Sort" Stage?

Let's take this from step 1. Are these characters legal ones for the text strings you are reading from DB2 or not; i.e. are you reading and transferring them correctly to DataStage (ignore XML for the moment)?

Lots of people here share a less than favorable attitude towards Windows, this message illustrates one reason why.
Does it happen whenever you call up the Designer? Does the designer hang with this message? What fixpack level of the clients have you installed?

One suggestion would be to write to a different file name, then in the after-job subroutine call (which can be set to only execute when the job completes successfully) you execute a shell command to move the temporary file to the permanent file name and overwrite it.

I don't know if it is just me being tired, but I can't figure out your logic. Your source has 8 rows, reference has 13 and output 6. Your output key seems to come from the reference file, but the output makes it seems as if you are retrieving the "Feild1" <sic> value. Could you perhaps exp...

Nothing looks incorrect at first read. The hung job you listed seems to only have run for a couple of seconds - or was the job terminated at some later point in time than Sunday the 6th? If you change that one job to an array and commit size of 50 or 100, does the error persist? Is there a correlati...

What would speak against using a hashed file that is not pre-loaded to memory? Return multiple rows (I'm assuming that account limits the number of returned rows quite a bit) and filter out the remainder using a transform constraint querying the range.

1. Have you tried your SQL query directly in DB2 from the command line?
2. Check http://publib.boulder.ibm.com/infocente ... /n7008.htm