I know there are similar posts ,but pl have a look at this one.
these are 50 warngings
PT_RPOS_Lookup.LdLookup: ds_uvput() - Write failed for record id '92612921'
PT_RPOS_Lookup.LdLookup: ds_uvput() - Write failed for record id '92453581'
and the below is the message after
Attempting to Cleanup after ABORT raised in stage
DataStage Job 482 Phantom 11440
Program "DSD.StageRun": Line 571, Internal data error.
Program "DSD.StageRun": Line 571, Internal data error.
PT_RPOS_Lookup2003andup/DATA.30':
Computed blink of 0x830 does not match expected blink of 0x0!
Detected within group starting at address 0x90603000!
PT_RPOS_Lookup2003andup/DATA.30':
Computed blink of 0x830 does not match expected blink of 0x0!
Detected within group starting at address 0x89C27800!
does any one has advise for me like what's happend here.
error writing into hash file..
Moderators: chulett, rschirm, roy
You've corrupted the hash file, probably because you exceeded 2.2 gigabytes on a 32bit file. You could have also ran out of disk space.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
First of all, are you attempting to put 500 million rows into a hash file? If so, you better contemplate a better solution. Just figure out how much raw character storage is required: 500 million rows of 20 characters per row puts you at 1 TB.
Hash files can hold that, but is it the solution I think you're looking to find? Based on your other post, I believe you are working on your data correction problem.
To directly answer your question, search the forum for "64BIT" hash files. That should get you past the 32BIT limitation. But, you'll be loading that hash file for days or weeks.
Hash files can hold that, but is it the solution I think you're looking to find? Based on your other post, I believe you are working on your data correction problem.
To directly answer your question, search the forum for "64BIT" hash files. That should get you past the 32BIT limitation. But, you'll be loading that hash file for days or weeks.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
You are attempting to fit 11 pounds of apples into a 10 pound apple box. Either remove unnecessary columns from the hash file to relieve the amount of data going into the file, or switch to creating it as 64BIT. There is a hard ceiling on 32BIT files, there's no way to squeeze more into that container. 2.2 gigabytes is it.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle