Hi,
i have a problem with the Hash File.
Sometime go i posted a problem about the limit of the dimension (over 2GB) and someone told to use the HFC application in the DataStage CD.
I tried to set this parameters:
File name: FILE
key pattern: No discernable pattern
Average record(byte): 500
Number of record: 10000000
Separation: 4
Addressing: 64 bit
Modulo Style: Prime number
Structure: Static Hashed
Commnad: mkdbfile
The application result this command:
/app/Ascential/DataStage/DSEngine/bin/mkdbfile FILE 18 2578133 4 64-bit
When i execute the command the answer is:
mkdbfile: unable to create a 32-bit file greater than 2 gigabytes.
but i set 64 bit file.
Why?
Can anyone help me?
thanks in advance.
Mario Loreti
mkdbfile: unable to create a 32-bit file greater t
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The command should be:
mkdbfile FILE 18 2578133 4 -64bit
The HFC on my DataStage CD generated this correctly, not "64-bit".
Looks like you may have made the error in transcribing the command. (HFC does have Edit > Copy, which places the generated command on your Clipboard.)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
mkdbfile FILE 18 2578133 4 -64bit
The HFC on my DataStage CD generated this correctly, not "64-bit".
Looks like you may have made the error in transcribing the command. (HFC does have Edit > Copy, which places the generated command on your Clipboard.)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518