mkdbfile: unable to create a 32-bit file greater t

eoyylo · Post by **eoyylo** » Mon May 26, 2003 11:09 am

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

ariear · Post by **ariear** » Mon May 26, 2003 3:51 pm

If you're running on Windows - it's a 32bit OS (until the ITANIUM is fully GA) .. So Hash files >2GB can be only on 64bit UNIX OS (AIX 5.1, HP11i,Solaris 7, Solaris

ray.wurlod · Post by **ray.wurlod** » Tue May 27, 2003 4:18 am

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