Hashed file size

satya99 · Post by **satya99** » Tue Jul 24, 2007 11:08 am

Hi,

Is there any Universe query to find out Hashed file size in terms of GB.

Thanks in advance.

DSguru2B · Post by **DSguru2B** » Tue Jul 24, 2007 1:45 pm

ANALYZE.FILE <<Hashed File Name>>
The above command will give you all sorts of info about the file, including size.

crystal_pup · Post by **crystal_pup** » Fri Jul 27, 2007 4:25 am

Could u pls throw some more light on the above command...Is it run on Windows machine or unix server?

Thanks,
KD

georgesebastian · Post by **georgesebastian** » Fri Jul 27, 2007 4:46 am

Hi

ANALYZE.FILE <<Hashed File Name>>

use it in administrator command box.

Thanks
George

crystal_pup · Post by **crystal_pup** » Fri Jul 27, 2007 5:31 am

A bit problem with tht...Actually i dont hav administrator rights to the folder wherein the command can be run...Any other way to have it done?
When i tried to find the required command it took me to the folders titled CAT and VCOMM within datastage home directory on UNIX server...When i tried to get into the folders i was thrown an error regarding access permissions...Dats y i want to knw any other way to get it done...

Thanks,
KD

chulett · Post by **chulett** » Fri Jul 27, 2007 7:15 am

If you are unwilling to use the Administrator client:

Code: Select all

cd `cat /.dshome`
. ./dsenv
dssh
LOGTO <your project>
ANALYZE.FILE <your hashed file>

Note: this will not work for 'pathed' hashed files. Are yours account based or were they created in specific directories?

Post here as you would communicate with your professional colleagues at work. English is not everyone's first language, "Dats y" SMS / text message crappola is not appropriate here.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 27, 2007 3:17 pm

You can execute ANALYZE.FILE (from within a DataStage environment) in any project. You can use it from the Administrator client's Command window. You may need to use SETFILE to create a VOC pointer to a pathed hashed file.