Hash File Size

[DSRajesh]

Hi All,

The windows os is 32 bit type.

Hash Files are of 32 bit dynamic hash files.

If the size of the file is more than 2 gb ,is it possible to change to 64 bit in datastage even on 32 bit windows OS?

[ArndW]

Yes, it is possible to do so.

[DSRajesh]

Hi Arndw,

How can we change from 32 bit to 64 bit in hash files when os is of 32 bit?

[ArndW]

One way to change all new dynamic files to 64bit is to set "64BIT_FILES" in the config file. This is a very bad idea and I recommend not doing this, since ALL new files will be 64bit and have an increase in storage and decrease in performance.
From the UV command line you can do a

Code: Select all

RESIZE {filename}  * * * 64BIT

[ray.wurlod]

Note that the RESIZE syntax Arnd gave relates to hashed files for which a VOC entry exists, and can be improved upon. Assuming that there is a VOC entry, prefer

Code: Select all

 RESIZE {filename} * * * 64BIT USING {pathname}

where pathname is a directory on a separate file system that has sufficient space to make a temporary copy of the hashed file. With this keyword the RESIZE will finish in about half the time of not using it.

[venkateshrupineni]

Hi Ray,

can you please explain about VOC entry.

Thanks in advance

[ray.wurlod]

Hashed files can be created in the project or in any other directory. If they are created in a project, that project's vocabulary (stored in the project's VOC file) includes an entry that records the name and location of the hashed file and its dictionary.
Hashed files that are created elsewhere can have a VOC entry created in the project so that various utilities can be used on them. Typically that would be effected using the SETFILE command. You can search DSXchange for details about how to use that command.