Hash File Migration

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
nvalia
Premium Member
Premium Member
Posts: 180
Joined: Thu May 26, 2005 6:44 am

Hash File Migration

Post by nvalia »

Hi All,
We are migrating from 7.5 (Windows) to 9.1 (Windows) on a new server.
We have 5 different projects and all are using only Server Jobs.

1. We have a lot of Hash files. Is there a way we can copy them from the 7.5 environment or do we need to create them as new ?

2. The Hash files are all in one project, but we reference them in other projects through VOC Q pointers. Can we still do that post migration?

Thanks and appreciate your response
NV
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

1. You can copy all the hashed files or FTP them in binary mode. I had to do the same thing years ago and it worked. There was some catch to it, such as pre-creating each one with a script then copying over top of what was created. Have you search this site on that topic?

2. Have you search this site?
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As Eric said the answer is yes but the gory details depend on the hashed file type - specifically if they were created as "pathed" hashed files or are associated with an "account" which would generally mean live in a project. For the former, you can simply migrate them. The latter are the ones mentioned that typically get created on the new server so the VOC record is setup correctly and then the (empty) contents can be overwritten with the contents from the old server.

And yes, if you are familiar with Q pointers you can simply set them up again on the new server once the hashed files have been migrated.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply