DSXchange

Hi all,

I'm trying to write a hashed file with 123 millions from DB2. At some point, I have the error:

Program "DSD.StageRun": Line 631, Internal data error.
File '/opt/IBM/software/DataStage/InformationServer/DS_HASH/HASH/DATA.30':
Computed blink of 0x870 does not match expected blink of 0x0!
Detected within group starting at address 0x80000000!

I've searched the forum, but the suggestions are only to clear the log file, and run it again, I've tried several times by cleaning up the hash and create the file again.

The data system has about 112 free GB, I don't know what else could be the mystake.

Thanks!

Ismael

A job's "log file" is a hashed file and a blink error in a hashed file is a blink error, even if it's not a log. You've corrupted the hashed file by trying to write more than 2.2GB of data to it, you'll need to switch it to 64BIT.

Thanks chulett, unfortunately I can't see what suggestions you have because of the Premium Content. How I can turnaround this issue?, I'm thinking using several hashed files on different jobs. Is this logical?

Thanks chulett, unfortunately I can't see what suggestions you have because of the Premium Content. How I can turnaround this issue?, I'm thinking using several hashed files on different jobs. Is this logical?

Search the forums for "64BIT", that should turn up quite a number of conversations on the subject of large hashed files.

Get a premium membership.

Premium membership is one of the mechanisms through which the hosting and bandwidth charges incurred by DSXchange are defrayed. It's not expensive, at less than 30c per day.