How can I copy hash files from UNIX command line?

ankita · Post by **ankita** » Wed Aug 01, 2007 8:08 pm

Hi All,
Is it possible to copy hash files from unix command line ?
If yes, then can anyone please help me with the exact command ?

Thanks in advance !
Ankita

ArndW · Post by **ArndW** » Wed Aug 01, 2007 8:52 pm

Yes, hashed files can be copied - but they might not be useable afterwards. If you reference hashed files using a VOC entry the files cannot be copied unless you know how to change the VOC pointers. If you access the hashed file using an absolute path then you can copy it. A dynamic hashed file is a subdirectory with 3 files, a DATA.30, an OVER.30 and a hidden file .Type30 and all 3 must be copied. If you use secondary indices on the hashed file it also becomes complex to copy and you should avoid doing so.

sweety123 · Post by **sweety123** » Fri Aug 27, 2010 3:29 am

Hi,

I want to copy a hashed file from one directory to another for different projects. I am able to copy the hashed file, but when I use the copied file in my job, I get the error:

Hashed_File_0.DSLink3: DSD.UVOpen Unable to open file HF_test.

Can anybody tell me how to overcome this issue?

Thanks in advance.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Aug 27, 2010 3:42 am

Assuming you have NOT created a 'local' hashed file, you can do the following.

Note - better test with a sample before moving files around. Because partial files may result in corruption.

Locate a file and directory with the name "D_<hashed file>" and "<hashed file>" in the place you created from DataStage.

Copy these two into your new location. Ensure that both goes on the same level.

Now it is ready to use.

sweety123 · Post by **sweety123** » Fri Aug 27, 2010 3:58 am

Hi Sainath,

Thanks for your response. But since I am not a premium user, I am unable to view your complete answer. Is there any way that you can share the complete answer with me again?

ray.wurlod · Post by **ray.wurlod** » Fri Aug 27, 2010 6:12 am

Note: the following WILL NOT WORK if the hashed file was created by a UniVerse stage or using a CREATE TABLE statement.

Code: Select all

cp -ipr HashedFileName targetdirectory ; cp -ip D_HashedFileName targetdirectory

If the hashed file has any indexes, things get a bit more complex - it's probably easier to build the index afresh in the new hashed file.

sweety123 · Post by **sweety123** » Fri Aug 27, 2010 6:46 am

Thanks Ray, I can use the hashed file now.

What if I have to copy the hashed file to a different server. Is there any command like 'scp' (works for other files) for this purpose?

chulett · Post by **chulett** » Fri Aug 27, 2010 6:50 am

I typically tar or zip up all of the appropriate files, transfer the archive to the new server and then unzip/untar them over there.

kduke · Post by **kduke** » Fri Aug 27, 2010 8:56 am

If the other server is not the same type of server like AIX to AIX then you may have to use fnuxi.

The rule of thumb is hashed files are for temporary storage. They should always be recreated during a load. If you are using hashed files for permanent storage meaning you use data from previous ETL runs then you need to rethink your strategy. You may need staging tables created in your target database.