Unable to delete ds files

[ramabbm]

Hi,

We are getting the following error, when we are trying to delete *.ds files using orchadmin command.

0509-150 Dependent module liborchgeneralaix3.so could not be loaded.
0509-022 Cannot load module liborchgeneralaix3.so.
0509-026 System error: A file or directory in the path name does not exist.

Could someone help us to resolve the above error.

Thanks
RK

[aesguerra]

hi,

make sure all paths (i.e. LIB_PATH, etc) required by orchestrate have been defined.

HTH.

[ray.wurlod]

The shared library path may be defined (in $DSHOME/dsenv) for DataStage processes. But, if you log in as an interactive user, does your .profile file set them for you? Possibly not. You should execute the dsenv script.

Code: Select all

cd $DSHOME
. ./dsenv

[Kirtikumar]

Ray,

I am trying to delete the DataSet through script which uses from orchadmin.
I am getting the mentioned error. I have done

cd $DSHOME
. ./dsenv

But still getting the same error

What can be the reason?

[bcarlson]

When Unix script starts, it spawns its own session. That is, it runs in its own environment. It will adopt some of the existing environment (that is accessible at the command line), but only the stuff that is exported.

For example, if I have 2 aliases (or variables or functions) - 1 is export, and 1 is not. The first will be available in the script, but the second will not.

You will need to source in the dsenv file within the script that calls orchadmin, as in the (very simple) example below:

Code: Select all

#!/usr/bin/ksh
. /opt/myAscentialDir/dsenv

ds_to_delete=$1

orchadmin rm -f ${ds_to_delete}
rc=$?

exit $rc

Please note, if $DSHOME is defined and exported in your .profile, then you could change the 2nd line of code to

Code: Select all

. ${DSHOME}/dsenv

Hope this helps,

Brad.