Page 1 of 2
orchadmin dump issue
Posted: Tue Jan 28, 2014 10:53 am
by ram.m
Hi Ray,
I also have similar issue
to this post with orchadmin command.when i try to run the orchadmin dump commands it not returning either any outout or error.
can you please assist me on this?
Posted: Tue Jan 28, 2014 12:17 pm
by chulett
Similar doesn't work for a reply but it does as your own question, so I've split you out and linked back to the original just for grins. Note that I had to
guess at your particulars (version,O/S) as you've yet start your own topic.
Posted: Tue Jan 28, 2014 1:43 pm
by ray.wurlod
Show the exact syntax you used, the value of APT_ORCHHOME environment variable at the time, and any output (even error message) you received. Issue the command echo $? immedicately after orchadmin and report the output of that.
Posted: Fri Jan 31, 2014 12:38 pm
by ram.m
Hi Rey,
here is my orchadmin profile.I am not getting any error when i execute the profile and also able to see orchadmin help but when i use orchadmin dump or copy it is is not returning either output or any error.Please kindly assist
export DSHOME=$(cat /.dshome)
. $DSHOME/dsenv
export APT_CONFIG_FILE=$DSHOME/../Configurations/default.apt
APT_ORCHHOME=/dv/app/IBM/IS/server/PXEngine/; export APT_ORCHHOME
export LIBPATH=$LIBPATH:$APT_ORCHHOME/lib
export PATH=$PATH:$APT_ORCHHOME/bin
Posted: Fri Jan 31, 2014 2:22 pm
by ray.wurlod
I meant that you should show us the exact syntax of your orchadmin command. Also, can you list the Data Set using the Data Set Management tool in the Designer client?
Posted: Fri Jan 31, 2014 3:01 pm
by ram.m
Yes i am able to list the data set using dataset management tool and able to view the data too.
below is command i am using
orchadmin dump -name test.ds
orchadmin dump test.ds
Posted: Sun Feb 02, 2014 10:42 am
by PaulVL
Do you have the Grid Enablement Toolkit installed?
If you do, try setting your APT_GRID_CONFIG when in your shell. Set it to the one for your project defaults.
Then try again.
Posted: Mon Feb 03, 2014 3:05 pm
by ram.m
I tried by setting APT_GRID_CONFIG with my project default in orchadmin profile but it still not getting any output with orchadmin dump command
Posted: Mon Feb 03, 2014 7:48 pm
by ray.wurlod
The full syntax of
orchadmin command may be found
here
Records are dumped to stdout so you will need a redirection operator to catch the dumped records into a file.
It might also be worth running
orchadmin check first to verify the structural integrity of the Data Set, and possibly also
dsrecords to determine whether the Data Set is empty. (An empty Data Set will cause
orchadmin dump to appear silent.)
Posted: Tue Feb 04, 2014 8:26 am
by ram.m
Hi Ray,
I have tried that too but it is not giving any output to output file.can you please let me know if we need to look in to in dsenv files etc..
Posted: Tue Feb 04, 2014 7:18 pm
by ray.wurlod
You don't. Use dsrecords to determine whether the Data Set contains any records at all.
Posted: Wed Feb 05, 2014 8:34 am
by ram.m
dsrecords working fine and it is displaying the record count as 3 records. I am also able to view the 3 records thru datastage designer
Posted: Wed Feb 05, 2014 3:23 pm
by ray.wurlod
Use the shell variable
$? to report whether
orchadmin dump was successful.
Posted: Wed Feb 05, 2014 6:03 pm
by ram.m
Hi Ray,
i got below output.
orchadmin dump test.ds
echo $?
1
Posted: Wed Feb 05, 2014 11:15 pm
by PaulVL
"which orchadmin"
Maybe someone is messing with your mind and slapped their own version in your execution path.
My guess is that it is in your GRIDHOME path.