Issue in reading dataset in other environment

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bart12872
Participant
Posts: 82
Joined: Fri Jan 19, 2007 5:38 pm

Post by bart12872 »

Dataset shouldn't be read in another environment and you can't easily do that. You should read directly in production if you have access.
Anyway, I don't know the reason why you want to see production data, but if you want to debug a job, you should create a set of data in dev independently of production data.
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

IBM's recommended methodologies:

Tutorial on how to move a dataset:
http://publib.boulder.ibm.com/infocente ... ataset.pdf

Alternative: copy via sequential file:
http://www-01.ibm.com/support/docview.w ... wg21392477

On a related note - How to move a dataset to a new directory:
http://www-01.ibm.com/support/docview.w ... wg21404123
Last edited by asorrell on Tue Dec 03, 2013 1:28 pm, edited 2 times in total.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
bart12872
Participant
Posts: 82
Joined: Fri Jan 19, 2007 5:38 pm

Post by bart12872 »

Interesting, but this guy want to transfer a dataset from prod to dev.
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

From the title page of the tutorial...
This presentation will discuss how to manually copy a dataset from one server to another

The only way to move a dataset is manually. There is no automated process.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
jagadam
Premium Member
Premium Member
Posts: 107
Joined: Wed Jul 01, 2009 4:55 pm
Location: Phili

Post by jagadam »

Can't we read the datasets which are ftp'd from one environment to other environment using Orchadmin command..?

Thanks
NJ
pavi
Premium Member
Premium Member
Posts: 34
Joined: Mon Jun 03, 2013 2:34 pm

Post by pavi »

To my knowledge, Dataset cannot be ftped from one server to another server.Dataset is not a single file like a flat file.descriptor file is internally connected to datafiles which are located as per config file
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

jagadam wrote:Can't we read the datasets which are ftp'd from one environment to other environment using Orchadmin command..?
In general no. The descriptor file contains information about the hostname, the configuration and the segment file locations from the original system. These will not be the same on the target system.
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