Deleting Datasets

[somu_june]

Hi,

I need to create a script to delete datasets that was previously created by jobs. I read in posts that I have to use orchadmin command to do it. Iam trying that command for first time can some body tell what orchadmin command do I need to use to delete the file.



Thanks,
Somaraju.

[crouse]

orchadmin -help

[attu]

pls set your configuration file and datastage environment and then you have to use orchadmin rm <datasetname>

[somu_june]

Hi,


when I did orchadmin -help it is saying orchadmin not found




Thanks,
Somaraju

[ray.wurlod]

Use your Data Set Management utility in the Manager client. You can much more easily delete data sets from there.

[crouse]

That's the first step.
You need to find the actual executable.
It is in you $DSHOME/bin directory.
The directory has to be in your path or you need to specify the path.

[attu]

Hi,


when I did orchadmin -help it is saying orchadmin not found




Thanks,
Somaraju

from DSHOME source your dsenv

from APT_ORCHHOME/bin

export LIBPATH=$LIBPATH:$APT_ORCHHOME/lib
export PATH=$PATH:$APT_ORCHHOME/bin
APT_ORCHHOME=/px; ( where you have your PXEngine)
export APT_CONFIG_FILE=/dsadm/Ascential/DataStage/Configurations/default.apt

Now run

orchadmin -help

[crouse]

Ray, the poster needs to delete datasets from a script.

[chrisjones]

Steps to delete DS.
1.Login into DS Manager
2.Goto Toosl->Dataste Management
3.Select the DataSet that you want to delete
4.Once the Dataset is selected then press delete button.


Cheers,
Chrisjones

[keshav0307]

cd $DSHOME ; ./dsenv ; cd ../PXEngine/bin ; export APT_CONFIG_FILE= <Config file name with Path>; orchadmin rm <dataset name>

[Kris123]

To delete dataset at command line you need to invoke the osh shell (environment) and then use the Orchadmin rm <dataset> command.
Review Orchadmin -help to see all the available options.