How delete Datasets

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
siva7143
Participant
Posts: 35
Joined: Wed Aug 09, 2006 12:20 am

How delete Datasets

Post by siva7143 »

Hi all,

For deleting Datasets i am using
orchadmin rm <Dataset Name>
But if i execute this through Unix box its giving "orchadmin not found'

Can u pl help me....
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Your dsenv file should have the path of shared library set to $APT_ORCHHOME/lib and also you must have APT_CONFIG_FILE set (Pointing to the same configuration file you used to create the Data Set). Then run the orchadmin command
cd $APT_ORCHHOME/bin
orchadmin rm $Path/FileName.ds
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

The configuration file name used to create dataset should be set to APT_CONFIG_FILE while deleting the dataset with orchadmin command.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Raghavendra - Even though you can do that, you don't need to. The descriptor file contains a copy of the configuration file used to create that dataset, and it can be used to locate the appropriate directories for the part files.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The parent directory of the orchadmin command must be findable in your command search path (PATH environment variable) or have its complete pathname specified - for example $APT_ORCHHOME/bin/orchadmin

Others have posted about the need to have the APT_CONFIG_FILE environment variable set correctly.
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