How to execute orchadmin commands
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
How to execute orchadmin commands
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
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.
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
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
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.
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
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
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....