Making the orchadmin commands work

sshettar · Post by **sshettar** » Wed Aug 26, 2009 9:35 am

Hi All,

I am having the issue in executing the orchadmin commands ,whenever i execute the orchadmin commands i get the following message " ksh: orchadmin: not found" .

i have figured out that we need to set few paths before making orchadmin commands work ie set the APT_ORCHHOME and set the APT_CONFIG_FILE .
i did do a search on how to set these variables in the .profile file
that is by typing the below commands
like
export APT_ORCHHOME="PATH"

export APT_CONFIG_FILE="PATH"

since i have never delt with modifying the .profile file before , i have this one doubt which might be a stupid one though
does the "PATH" here means writing the path of APT_ORCHHOME and path of APT_CONFIG_FILE in place of "PATH" here and should the path be within double quotes("")

I am also aware that we need to execute the ./dsenv file as well,
so does that mean add the line below into the .profile file?
. /opt/IBM/InformationServer/Server/DSEngine/dsenv

Thanks in advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 26, 2009 9:41 am

You need to set PATH to make orchadmin work.

export PATH=$PATH:$APT_ORCHHOME/bin

Other paths need not be in quotes.

sshettar · Post by **sshettar** » Wed Aug 26, 2009 9:46 am

Thanks Srinivas,

with You need to set PATH to make orchadmin work.

export PATH=$PATH:$APT_ORCHHOME/bin do you mean to say i need to add this one command in addition to the rest that i have already mentioned?
and should my export APT_ORCHHOME="PATH" coomand be written before the export PATH=$PATH:$APT_ORCHHOME/bin?

and also the commnad you have given should that be in the .profile file as it is or is there anything i need to change based on my env?

Thanks in advance

sshettar · Post by **sshettar** » Wed Aug 26, 2009 2:33 pm

Hi

I tried setting all the variables and also tried to execute the dsenv file
but when i log into the session i get the information as
ksh: /home/sshettar/.profile 36]: ./opt/IBM/dstage/Ascential/DataStage/DSEngine/ dsenv: not found

this is how i have defined in my .profile file

export APT_ORCHHOME=/opt/IBM/dstage/Ascential/DataStage/PXEngine
export PATH=$PATH:$APT_ORCHHOME/bin
export APT_CONFIG_FILE=/opt/IBM/dstage/Ascential/DataStage/Configurations
export DSHOME=/opt/IBM/dstage/Ascential/DataStage/DSEngine
.$DSHOME/dsenv

Could somebody help me as to where am i going wrong

any help is highly appreciated

Thanks in advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 26, 2009 2:37 pm

Leave a blank space after the dot in your "dsenv" line.

sshettar · Post by **sshettar** » Wed Aug 26, 2009 2:42 pm

Thanks Sai ,
that removed the coment

but now when i tried to delete one of my dataset using orchadmin delete command i get the following error message

orchadmin: error while loading shared libraries: liborchgenerali686.so: cannot open shared object file: No such file or directory

where do you think i am going wrong?

Any help is highly appreciated

Thanks in advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 26, 2009 3:28 pm

Library path.

Can you cut-and-paste your dsenv. I am sure these entries must be in dsenv.

sshettar · Post by **sshettar** » Thu Aug 27, 2009 7:25 am

Here is the copy of the dsenv file i'm using. i see that the PATH is in a different location than what i have specified in mine but was not sure if i had to change it .

Any guidance on how to change will be of great help

.....

# PLATFORM SPECIFIC SECTION

set +u
# added 2006-03-06
umask 002

if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi

if [ -z "$DSHOME" ]
then
DSHOME=/opt/IBM/dstage/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/opt/IBM/dstage/Ascential/DataStage/PXEngine; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/opt/IBM/dstage/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/opt/IBM/dstage/Ascential/DataStage/ud41/bin; export UDTBIN
fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then

DB2DIR=/opt/IBM/db2/V8.1; export DB2DIR
DB2INSTANCE=db2lxcon; export DB2INSTANCE
INSTHOME=/home/db2lxcon; export INSTHOME
THREADS_FLAG=native; export THREADS_FLAG

ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME

#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES

PATH=$PATH:$DSHOME/bin:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm: export PATH

LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/i386/client:$DSHOME/java/jre/lib/i386:$INSTHOME/sqllib/lib:$DB2DIR/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
fi
#Netzza environment variables #)
NZ_ODBC_INI_PATH=$DSHOME; export NZ_ODBC_INI_PATH
NETEZZA=/usr/local/nz; export NETEZZA
PATH=$PATH:$NETEZZA/bin; export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$NETEZZA/bin; export LD_LIBRARY_PATH

Thanks in advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 27, 2009 7:35 am

Your dsenv appears more oriented towards server edition. Is this the first time you are using PX?

Include a line

Code: Select all

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$APT_ORCHHOME/lib

Also include the PATH previously discussed at the end of your dsenv.

sshettar · Post by **sshettar** » Fri Oct 02, 2009 7:20 am

Hi ,

I have included the path you discussed into my dsenv file . but still when i execute the orchadmin commands i'm getting the following error

orchadmin: error while loading shared libraries: liborchgenerali686.so: cannot open shared object file: No such file or directory

could somebody shed some light as to why i'm getting such and error

Thanks in advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Oct 02, 2009 8:53 am

Did you attempt to locate the library object ?

sshettar · Post by **sshettar** » Fri Oct 02, 2009 9:40 am

i did and looks like the library object it is looking for exists in the different path than specified for $APT_ORCHHOME

we have different PXEngine directpries out here
like

PXEngine
PXEngine.751.1
PXEngine.752.1

this library object is present in this directory PXEngine.752.1

now my question is
is it possible to point $APT_ORCHHOME to PXEngine
but the LD library path to PXEngine.752.1

or do we have to point the APT_ORCHHOME to the same path as for library path?

Thanks in advance

chulett · Post by **chulett** » Sat Oct 03, 2009 9:04 am

Do a "long listing" in that directory, you should find that your "PXEngine" directory is actually a link to the current version. Something like:

Code: Select all

$ pwd
/appl/Ascential/DataStage
$ ls -ld PX*
lrwxrwxrwx   1 dsadm dstage    40 Jul 23  2007 PXEngine -> /appl/Ascential/DataStage/PXEngine.752.1
drwxrws---  12 dsadm dstage  4096 Jul 23  2007 PXEngine.752.1

sshettar · Post by **sshettar** » Mon Oct 05, 2009 9:33 am

Yes PXEngine does point to PXEngine.752.1

the orchadmin commands are working right now .
Thanks everyone for all your help and guidance.

Thanks