Topic
  • 10 replies
  • Latest Post - ‏2013-03-05T15:50:44Z by SystemAdmin
Jaime_Santos
Jaime_Santos
3 Posts

Pinned topic Problems with $orchadmin dump

‏2012-09-24T15:50:59Z |
Hello everyone and thanks in advance for the help and your time.
I have created a dataset (look "dataset.JPG" inside attached file) with:
a) A variable number of columns extracted from a source db2 table(in this example 6 columns, from ID_CLIENTE to ID_PROVINCIA)
b) The rest of them always appear (from ID_TABLA_ORIGEN to ID_ORIGEN). They have metadata data (in this case integrity relationship)

I need to check reference integrity between field CAMPO_ORIGEN and CAMPO_LKP of table ID_TABLA_ORIGEN and ID_TABLA_LKP respectively. In my example I need to check that ID_PROVINCIA = 1 (OF THE CLIENT ID_CLIENTE=1) is in table DWH_PROVINCIA, and the same for PROVINCE=2 of client=2.

My idea is to call another job via Transformer stage whose arguments are the arguments of section "b)".

Looking for a solution on internet, I read that I should do the next:

cd /opt/IBM/InformationServer/PXEngine/bin/
$orchadmin dump /home/dsadm/TargetFiles/ISUCRE/ResultData/PlantaInterna/DSresultadoDemo2.ds

but I obtain the next error:
bash: dump: command not found

The problem is that I can execute other OS commands via ORCHADMIN and they work (If instead of using "dump" I use "rm" to delete the file, it works).

Could anyone tell me why it is not working and what I should do to fix this issue?

If you need further information, do not hesitate to ask me, :).

Thanks & kind regards.
Updated on 2013-03-05T15:50:44Z at 2013-03-05T15:50:44Z by SystemAdmin
  • WalkerDean
    WalkerDean
    28 Posts

    Re: Problems with $orchadmin dump

    ‏2012-09-24T16:32:13Z  
    $orchadmin evaluates to an empty string if you have not set that as an environment variable,
    hence the shell uses 'dump' as the name of the command to run. you don't have a command called dump.
    remove the $, run orchadmin dump ... and report back :)
  • Jaime_Santos
    Jaime_Santos
    3 Posts

    Re: Problems with $orchadmin dump

    ‏2012-09-25T07:29:29Z  
    $orchadmin evaluates to an empty string if you have not set that as an environment variable,
    hence the shell uses 'dump' as the name of the command to run. you don't have a command called dump.
    remove the $, run orchadmin dump ... and report back :)
    Hi Walker, how are you?
    First of all, thanks for your quick answer.
    Answering your proposal, I paste the results of th diferents commands ("$orchadmin" works but "orchadmin" doesn`t as you can see in attachd file "orchadmin.jpg").
    Do you have any idea?
    Thanks & kind regards.
  • WalkerDean
    WalkerDean
    28 Posts

    Re: Problems with $orchadmin dump

    ‏2012-09-25T08:44:51Z  
    Hi Walker, how are you?
    First of all, thanks for your quick answer.
    Answering your proposal, I paste the results of th diferents commands ("$orchadmin" works but "orchadmin" doesn`t as you can see in attachd file "orchadmin.jpg").
    Do you have any idea?
    Thanks & kind regards.
    Jaime,
    You do not have orchadmin in your path, you should either:

    add /opt/IBM/InformationServer/PXEngine/bin to your PATH

    or use ./orchadmin ...

    You may also need to source dsenv before executing DataStage
    command-line tools so that dependent libraries are added to LIBPATH:
    . ./dsenv

    -Dean.
  • Jaime_Santos
    Jaime_Santos
    3 Posts

    Re: Problems with $orchadmin dump

    ‏2012-09-25T10:58:42Z  
    Jaime,
    You do not have orchadmin in your path, you should either:

    add /opt/IBM/InformationServer/PXEngine/bin to your PATH

    or use ./orchadmin ...

    You may also need to source dsenv before executing DataStage
    command-line tools so that dependent libraries are added to LIBPATH:
    . ./dsenv

    -Dean.
    Hello Dean, how are you?
    I have just tried to use "./orchadmin" instead of "orchadmin" or "$orchadmin" and I obtain the next issue:

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

    Could you specify exactly which commands do I have to use to solve this issue?

    Thanks for all your help & kind regards.
  • WalkerDean
    WalkerDean
    28 Posts

    Re: Problems with $orchadmin dump

    ‏2012-09-25T15:15:30Z  
    Hello Dean, how are you?
    I have just tried to use "./orchadmin" instead of "orchadmin" or "$orchadmin" and I obtain the next issue:

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

    Could you specify exactly which commands do I have to use to solve this issue?

    Thanks for all your help & kind regards.
    Jaime,
    You may also need to source dsenv before executing DataStage
    command-line tools so that dependent libraries are added to LIBPATH:
    . ./dsenv
    -Dean
  • WalkerDean
    WalkerDean
    28 Posts

    Re: Problems with $orchadmin dump

    ‏2012-09-25T15:21:33Z  
    Jaime,
    You may also need to source dsenv before executing DataStage
    command-line tools so that dependent libraries are added to LIBPATH:
    . ./dsenv
    -Dean
    From TechNote http://www-01.ibm.com/support/docview.wss?uid=swg21404123

    This command is located in $APT_ORCHHOME/bin and takes two arguments.
    Be sure to source the dsenv before running the command.
    ...

    Example:
    . ./dsenv
    ...
    orchadmin ...
  • SystemAdmin
    SystemAdmin
    7754 Posts

    Re: Problems with $orchadmin dump

    ‏2013-03-05T12:43:22Z  
    From TechNote http://www-01.ibm.com/support/docview.wss?uid=swg21404123

    This command is located in $APT_ORCHHOME/bin and takes two arguments.
    Be sure to source the dsenv before running the command.
    ...

    Example:
    . ./dsenv
    ...
    orchadmin ...
    Hello guys

    Could you please tell me how to 'source the dsenv' before running orchadmin?

    I have the same issue here, i.e. I can run $orchadmin but not orchadmin rm since I get the message:

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

    Thanks in advance

    Tony
  • WalkerDean
    WalkerDean
    28 Posts

    Re: Problems with $orchadmin dump

    ‏2013-03-05T15:14:47Z  
    Hello guys

    Could you please tell me how to 'source the dsenv' before running orchadmin?

    I have the same issue here, i.e. I can run $orchadmin but not orchadmin rm since I get the message:

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

    Thanks in advance

    Tony
    . ./dsenv

    dsenv will be in <infosrv>/Server/DSEngine
  • SystemAdmin
    SystemAdmin
    7754 Posts

    Re: Problems with $orchadmin dump

    ‏2013-03-05T15:22:04Z  
    . ./dsenv

    dsenv will be in <infosrv>/Server/DSEngine
    Thanks Dean
  • SystemAdmin
    SystemAdmin
    7754 Posts

    Re: Problems with $orchadmin dump

    ‏2013-03-05T15:50:44Z  
    Thanks Dean
    You may also need to set $APT_CONFIG_FILE