orchadmin dump issue

ram.m · Post by **ram.m** » Tue Jan 28, 2014 10:53 am

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?

chulett · Post by **chulett** » Tue Jan 28, 2014 12:17 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 28, 2014 1:43 pm

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.

ram.m · Post by **ram.m** » Fri Jan 31, 2014 12:38 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Jan 31, 2014 2:22 pm

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?

ram.m · Post by **ram.m** » Fri Jan 31, 2014 3:01 pm

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

PaulVL · Post by **PaulVL** » Sun Feb 02, 2014 10:42 am

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.

ram.m · Post by **ram.m** » Mon Feb 03, 2014 3:05 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 03, 2014 7:48 pm

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.)

ram.m · Post by **ram.m** » Tue Feb 04, 2014 8:26 am

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..

ray.wurlod · Post by **ray.wurlod** » Tue Feb 04, 2014 7:18 pm

You don't. Use dsrecords to determine whether the Data Set contains any records at all.

ram.m · Post by **ram.m** » Wed Feb 05, 2014 8:34 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Feb 05, 2014 3:23 pm

Use the shell variable $? to report whether orchadmin dump was successful.

Code: Select all

orchadmin dump test.ds
echo $?

ram.m · Post by **ram.m** » Wed Feb 05, 2014 6:03 pm

Hi Ray,

i got below output.

orchadmin dump test.ds
echo $?
1

PaulVL · Post by **PaulVL** » Wed Feb 05, 2014 11:15 pm

"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.