DSXchange

I've modified the DB2 connection settings in PX to communicate with encrpted streams, but I am fairly certain that this won't work for the V8 repository. This is a good question to direct towards your support provider.

Can you connect to WAS using the webconsole? Is this error a new one, and if so, what has changed since the time things worked? Have you re-booted the Windows server?

Google told me this about the error.

If you have defined it with binary24 the hex values should be in the MSGID variable. Are you performing an explicit conversion to character representation?

I have witnesses that place me elsewhere at that time. I am innocent

I don't see how the job performance can be influenced by setting APT_DUMP_SCORE. That just writes a one-time log entry. Have you confirmed that changing only that one parameter makes a performance difference?

Better a VOC record than a criminal one

The schema is still there, this could be the result of a partial delete, i.e. someone trying it from the (undocumented) commands in DS. Open up an admin or TCL prompt, then enter "LIST UV.ACCOUNT", does the project show up? Then do a "LIST UV_SCHEMA" and see if the schema exists.

After a run and with data in the file, go to the TCL prompt in UNIX or via the administrator and do a "ANALYZE.FILE {YourHashedFileNameGoesHere}", use the MODULO you see plus 10%, then enter "PRIME {calculatednumber}" and choose the higher value as your MINIMUM.MODULUS value. Thi...

INT(In.MyNumericColumn*10)/10

Inserts into an empty file are faster than inserts into a large (and perhaps badly hashed) file. What file type and settings are used to create this file? It might behoove you to choose a specific file type and modulo if you know the sizes beforehand, or at least to pre-size the hashing size for a d...

What is the corresponding value that the field "0x01 0x00 0x26 0x51 0x00 " should have? DataStage has no problem reading binary values.

A NULL (0x00) can be stored, as can an SQL NULL (0x80). Both are stored as-is in hashed files.

sachinnilose wrote:...When I check the file on unix machine in hex format i can see the values like:

0100265100
0107313300
and so on....

Is this Hex 0x01 0x00 0x26 0x51 0x00 for the first row? If so, something is wrong. Do you have the actual COBOL picture definition for this column?

How should a JOIN stage know where the data comes from? It just joins 2 or more links together and the source makes no difference.