IBM Support

How to use orchadmin command on Windows OS to delete dataset

Troubleshooting


Problem

How to use command to delete dataset instead of using Dataset management option in designer

Resolving The Problem

1. Set APT_CONFIG_FILE to your configuration file
For example:
set APT_CONFIG_FILE=C:\IBM\InformationServer\Server\Configurations\default.apt
2. Set APT_ORCHHOME =C:\IBM\InformationServer\Server\PXEngine
3. From directory C:\IBM\InformationServer\Server\PXEngine\bin
enter
sh -c "orchadmin delete <Path>/Datasetname.ds"

If you would like to delete many files then below is an example:

sh -c "orchadmin delete `ls D:/My_Projects/Dataset/ABC*.ds`"

Note that the "\" (backslash) characters have to be replaced by "/"
(slash) characters. and that the command passed to the shell itself
need to be enclosed between quotes.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.3;8.5;8.7;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21961605