Page 1 of 1
Hash File Size
Posted: Tue Sep 04, 2012 9:44 pm
by 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?
Posted: Wed Sep 05, 2012 1:15 am
by ArndW
Yes, it is possible to do so.
Posted: Wed Sep 05, 2012 4:43 am
by DSRajesh
Hi Arndw,
How can we change from 32 bit to 64 bit in hash files when os is of 32 bit?
Posted: Wed Sep 05, 2012 5:01 am
by 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
Posted: Wed Sep 05, 2012 5:55 am
by 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.
req:more ingformation about VOC
Posted: Thu Oct 18, 2012 1:59 am
by venkateshrupineni
Hi Ray,
can you please explain about VOC entry.
Thanks in advance
Posted: Thu Oct 18, 2012 3:26 am
by 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.