How to execute orchadmin commands

yousuff1710 · Post by **yousuff1710** » Wed Nov 04, 2009 5:10 am

Hi all,

I would like to know how to execute orchadmin commands from command line?
To employ this, is any configurations required or is it available after installing Information Server.
The environment we are using is:-
Server : UNIX/ AIX 5.3
Datastage Edition: IBM Information Server 8.0.1

I have used dsjob commands from command line, but I have no idea on how to use orchadmin commands.

Any inputs are greatly appreciated.

Thanks in advance,
Yusuf.

chulett · Post by **chulett** » Wed Nov 04, 2009 7:47 am

What do you mean by 'how to use'? You execute orchadmin just like any other command line function, including dsjob. Do you have a more specific question?

ray.wurlod · Post by **ray.wurlod** » Wed Nov 04, 2009 2:55 pm

... except that orchadmin requires APT_ORCHHOME to be set, in addition to the requirements for dsjob.

mbsiddu · Post by **mbsiddu** » Thu Nov 05, 2009 5:59 am

Try this....

$DSHOME/bin/Orchadmin rm datasetname

mbsiddu · Post by **mbsiddu** » Thu Nov 05, 2009 6:08 am

As ray suggested, you need to set APT_ORCHHOME......

confirm with for these setting also.....

. /appl/Ascential/DataStage/DSEngine/dsenv

PATH=$PATH:/appl/Ascential/DataStage/PXEngine/bin

export PATH

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/appl/Ascential/DataStage/PXEngine/lib

export LD_LIBRARY_PATH

APT_CONFIG_FILE=/appl/Ascential/DataStage/Configurations/default.apt

export APT_CONFIG_FILE

yousuff1710 · Post by **yousuff1710** » Fri Nov 06, 2009 12:15 am

Hi Ray/mbsiddu,

How to set APT_ORCHHOME?

We have included
APT_ORCHHOME = /opt/IBM/InformationServer/Server/PXEngine in the dsenv file.
But what exactly do you mean by set APT_ORCHHOME?

Sorry, if I am asking silly queries, but I never used these orchadmin commands. I am not finding any way to check it on server.

Thanks for all your inputs, I greatly appreciate it.

chulett · Post by **chulett** » Fri Nov 06, 2009 12:23 am

Then you've "set" it and it will be properly in your environment if you source the dsenv file in your .profile or manually before executing the orchadmin commands.

Code: Select all

cd $DSHOME
. ./dsenv

ray.wurlod · Post by **ray.wurlod** » Fri Nov 06, 2009 2:01 pm

There are no spaces either side of the "=" when setting environment variable values. You also need to export the variable if you are using a Bourne shell or similar. Find examples in your dsenv script.

yousuff1710 · Post by **yousuff1710** » Mon Nov 09, 2009 1:58 am

Hi Ray,

You are right, there are no spaces before & after '='. It was my mistake while posting.

Now, as Hulett said, I sourced the dsenv file - . ./dsenv, then ran orchadmin command, its giving below error:-
# orchadmin -d items_compress.ds
##E IIS-DSEE-TFPA-00021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F IIS-DSEE-TFCF-00009 Fatal Error: Cannot continue without a configuration file.

Here it says, $APT_CONFIG_FILE not set.
In our dsenv file, there's no entry for $APT_CONFIG_FILE, this might be the reason.
Also, the error says config.apt not found in $APT_ORCHHOME/etc.

What is this config.apt?
Actually, we have default.apt configuration file in /opt/IBM/InformationServer/Server/Configurations path.

Do we need to copy this default.apt to $APT_ORCHHOME/etc by the name config.apt.

ArndW · Post by **ArndW** » Mon Nov 09, 2009 2:38 am

Set the $APT_CONFIG_FILE in your user's .profile, e.g.:

Code: Select all

export APT_CONFIG_FILE=/opt/IBM/InformationServer/Server/Configurations/default.apt

yousuff1710 · Post by **yousuff1710** » Mon Nov 09, 2009 7:54 am

Thanks ArndW & everybody....

Its worked......after setting APT_CONFIG_FILE, the command ran successfully, I ran the command to delete a dataset in the directory where dataset exists.......we should set APT_CONFIG_FILE also in that directory before running the command.

Thanks for all your precious time....