Export Hashfile

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
avenki77
Participant
Posts: 25
Joined: Wed Jul 07, 2004 2:55 pm

Export Hashfile

Post by avenki77 »

Hi,

I have a set of hashfiles with live data in a UNIX box. I want to move this live data to testing server. Is there any utility to do this?

Thanks
Venkatesh
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Use the normal unix commands - rcp, tar etc.

But if you are performing SQL against it, you may have to create the files first in the new server before moving the data.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The best (safe) utilities to use are:
  • format.conv -export (then format.conv -import) if the hashed files are SQL tables

    uvbackup (then uvrestore) only if the hashed files aren't SQL tables
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply