473,230 Members | 3,421 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,230 software developers and data experts.

db2_all

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 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched

Any idea? If I use run the above command on single physcial node/multiple logical db partitions, it will be ok. I got the above error when I run the db2_all on multiple physical node, multiple physical logical db partitions.
Nov 12 '05 #1
6 3624
Fan Ruo Xin wrote:
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 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched

Any idea? If I use run the above command on single physcial
node/multiple logical db partitions, it will be ok. I got the above
error when I run the db2_all on multiple physical node, multiple
physical logical db partitions.


Have you tried running it from bash?
The shell script interpreter (in this case ksh) seems to be unable to
parse the script db2_all, which is odd since ksh is supposed to be
compatible with bash.
Also very odd is that it states line 1, which cannot be a '{'. A
shellscript cannot begin with a '{'.

-R-
Nov 12 '05 #2
Fan, have you tried a simple rsh to the remote machine? Try something
like 'rsh <your_hostname> ls'. Sometimes the error can be in the
profile of the instance owner id on the remote box (i.e., unrelated to
db2_all).

Regards,
Miro

Nov 12 '05 #3
Hi Fan,

Try this: db2_all "db2 update db cfg for sample using tsm_mgmtclass \'\'" < /dev/null (this if I remember correctly applies only to ksh)

HTH,

JM

"Fan Ruo Xin" <fa*****@sbcglobal.net> a écrit dans le message de news:1r**************@newssvr23.news.prodigy.net.. .
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 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched

Any idea? If I use run the above command on single physcial node/multiple logical db partitions, it will be ok. I got the above error when I run the db2_all on multiple physical node, multiple physical logical db partitions.

Nov 12 '05 #4
Hi,
I have not tried running it from bash yet. I will try it later, if it can
work from bash, it will still be a puzzle for me.
Thanks for your help.
Fan

"Jurgen Haan" <ju****@fake.dom> wrote in message
news:42***********************@news.xs4all.nl...
Fan Ruo Xin wrote:
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 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched

Any idea? If I use run the above command on single physcial
node/multiple logical db partitions, it will be ok. I got the above
error when I run the db2_all on multiple physical node, multiple
physical logical db partitions.


Have you tried running it from bash?
The shell script interpreter (in this case ksh) seems to be unable to
parse the script db2_all, which is odd since ksh is supposed to be
compatible with bash.
Also very odd is that it states line 1, which cannot be a '{'. A
shellscript cannot begin with a '{'.

-R-

Nov 12 '05 #5
Hi, Miro
I did run rsh command first. It worked well. I could not understand this
behavior, you see:
(1) db2_all "db2 update db cfg for sample using tsm_mgmtclass my_tsm_cls"
ran well, so dose any db2_all command without involving the special
character, such as single-quote.
(2). Our production database was built on 5 physical nodes (40 db
partitions), but the testing db was built on a single physical node (4
logical db partitions). We installed the 5 physical production nodes and one
testing node from the same AIX CD.
But for testing db: $db2_all "db2 update db cfg for sample using
tsm_mgmtclass \'\'" can work.

Any idea? Thanks for the help.
Fan
"mirof007" <mi******@gmail.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...
Fan, have you tried a simple rsh to the remote machine? Try something
like 'rsh <your_hostname> ls'. Sometimes the error can be in the
profile of the instance owner id on the remote box (i.e., unrelated to
db2_all).

Regards,
Miro

Nov 12 '05 #6
Hi, Jean-Marc,
I tried it and was getting the same error:
PRD:> %sample using tsm_mgmtclass \'\'" < /dev/null <
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
PRD:> %

Thanks for the help.
Fan

"Jean-Marc Blaise" <no****@nowhere.com> wrote in message news:42**********************@news.wanadoo.fr...
Hi Fan,

Try this: db2_all "db2 update db cfg for sample using tsm_mgmtclass \'\'" < /dev/null (this if I remember correctly applies only to ksh)

HTH,

JM

"Fan Ruo Xin" <fa*****@sbcglobal.net> a écrit dans le message de news:1r**************@newssvr23.news.prodigy.net.. .
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 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched

Any idea? If I use run the above command on single physcial node/multiple logical db partitions, it will be ok. I got the above error when I run the db2_all on multiple physical node, multiple physical logical db partitions.

Nov 12 '05 #7

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

Similar topics

4
by: CompGeek | last post by:
Hi there, I am trying to load a file with 1729 records into a DB2 UDB EEE 7.1 DataBase (on AIX 4.3) which is across two partitions. The partitioning key is BI_INSTITUTIONAL_KEY which is a BIGINT...
1
by: db2sysc | last post by:
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...
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...
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...
13
by: Amber | last post by:
I have installed db2 9.1 enterprise trail version on Fedora 7(using all the default settings except creating a partitioned instance), and got two response files, one of which is db2ese_addpart.rsp....
5
by: danfan46 | last post by:
Hi! I have a previous post on the subject that connect takes a long time. I uninstalled db2 completely. Installed V9.5 Installed fixpack 1 created das created an instance installed...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.