Page 1 of 1

Enable orachadmin

Posted: Tue Jun 12, 2007 6:23 am
by tusharzade
I am using Datastage 7.5.1 on AIX server. I need to delete .ds file using unix command.

When I give the command
orachmin delete $Path/xxx.ds

it gives me an error as "ksh: orchadmin: not found".

Can you help me out in enabling the Orchadmin?

Regards,
Tushar

Posted: Tue Jun 12, 2007 6:55 am
by chulett
There's nothing to 'enable', you just need to ensure it is in your $PATH. Try setting your environment to the DataStage environment by 'sourcing' dsenv first:

Code: Select all

cd $DSHOME
. ./dsenv
Then run your command again.

Posted: Tue Jun 12, 2007 7:06 am
by DSguru2B
Your dsenv file should have the path of shared library set to $APT_ORCHHOME/lib.
Then you need to run the orchadmin command by running the following

Code: Select all

cd $APT_ORCHHOME/bin
orchadmin delete $Path/xxx.ds 

Posted: Tue Jun 12, 2007 7:47 am
by chulett
Ok. Or just this then:

Code: Select all

$APT_ORCHHOME/bin/orchadmin delete $Path/xxx.ds
I'd still make sure this bin directory is in your PATH somewhere.

Posted: Tue Jun 12, 2007 3:10 pm
by ray.wurlod
As well as havingAPT_ORCHHOME set and PATH including $APT_ORCHHOME/bin you must have APT_CONFIG_FILE set (pointing to the same configuration file that was used to create the Data Set), and your shared library search path must include $APT_ORCHHOME/lib.