473,406 Members | 2,336 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

how to validate the RETURN CODE in db2_all

All:

When I execute a utility command using db2_all, Can I get seperate
return codes per node where the command got executed?

in other words, how to get the returncode when we execute db2_all
across nodes ?

Thanks
Nov 12 '05 #1
1 3092
Hi,
I'm sure there are far more elegant ways of doing this,but..

I dug this example out from on old (ksh)script, not exactly what you
are after but may be of use/prompt some other ideas?

for i in 01 02 03 04 05 06 07 08 09 10 11 12 13 14
do
db2_all ";<<+$i< echo partition backup && echo DB2NODE=$i && time db2
-v backup db ${DB2_DBENV?} online LOAD "$NB_DIR"/bin/libbpdb2.sl with
2 buffers buffer 1024 parallelism 4 without prompting" |tee -a
$LOGFILE.$i
.....

i.e produce a logfile per partition and then process it for return
codes etc..

Paul.
db*****@yahoo.com (db2sysc) wrote in message news:<69**************************@posting.google. com>...
All:

When I execute a utility command using db2_all, Can I get seperate
return codes per node where the command got executed?

in other words, how to get the returncode when we execute db2_all
across nodes ?

Thanks

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: SHC | last post by:
Hi all, I have a VC++ .NET 2003 - Windows XP Pro PC. I created a Win32 console application in my VC++ .NET 2003 and copied validateDOM.cpp, books.xml and books.xsd (see the attached files below)...
3
by: JS | last post by:
windows 2k with v 8 fix 5, eee set up when I issue db2_all "db2 get db cfg for <dbname>", I get for each node: <HOSTANME> : DB2 GET DB CFG FOR <DBNAME> completed RC=0 rah: <HOSTNAME> but there is...
5
by: Prince Kumar | last post by:
I am trying to escape the special characters while executing the following sql, but couldn't figure out a way. db2_all "db2 connect to mydb; db2 select * from table (SNAPSHOT_CONTAINER ( '' , -1...
0
by: Will Griffiths | last post by:
Hi, I am running DB2 v8.1 ESE on Windows 2000 and have a single instance on my machine with 3 nodes. When I attempt to run *any* command using db2_all I get the following output (my machine...
0
by: da | last post by:
Hi All, Suppose, I have a command like the following one. db2_all '<<-0<|| db2 list applications; db2 terminate ' Now, Would the commands inside the single quotes run parallel on all the...
6
by: Fan Ruo Xin | last post by:
db2_all "db2 update db cfg for sample using tsm_mgmtclass \'\'"; ksh: syntax error at line 1 : `{' unmatched ksh: syntax error at line 1 : `{' unmatched ksh: syntax error at line 1 : `{'...
3
by: Claire | last post by:
I have a large record with many enumerated fields. The record is stored in a file and the fields have to be extracted. I validate the data as it's read, but there's so many tests similar to the...
6
by: Jonny | last post by:
Hi, I'm trying to validate my xml against a xsd but I can't get it to work. Originally, I wanted to validate an xml string but since I didn't get that to work I tried to validate an xml file...
3
by: chettiar | last post by:
I am new to shell scripting. I need to use the db2_all command in a shell script can someone help. I need to use the following command in the shell script: db2_all <<-0< db2 conncet to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.