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

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
    ACCEPTED ANSWER

    Re: Problems with $orchadmin dump

    ‏2012-09-24T16:32:13Z  in response to Jaime_Santos
    $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
      ACCEPTED ANSWER

      Re: Problems with $orchadmin dump

      ‏2012-09-25T07:29:29Z  in response to WalkerDean
      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
        ACCEPTED ANSWER

        Re: Problems with $orchadmin dump

        ‏2012-09-25T08:44:51Z  in response to Jaime_Santos
        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
          ACCEPTED ANSWER

          Re: Problems with $orchadmin dump

          ‏2012-09-25T10:58:42Z  in response to WalkerDean
          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
            ACCEPTED ANSWER

            Re: Problems with $orchadmin dump

            ‏2012-09-25T15:15:30Z  in response to Jaime_Santos
            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
              ACCEPTED ANSWER

              Re: Problems with $orchadmin dump

              ‏2012-09-25T15:21:33Z  in response to WalkerDean
              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
                ACCEPTED ANSWER

                Re: Problems with $orchadmin dump

                ‏2013-03-05T12:43:22Z  in response to WalkerDean
                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