| Author |
Message
|
| jmac |
 Posted: Tue Mar 18, 2003 1:13 pm Post subject: Define a new SYS in a SYSGRP on a different machine |
 |
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I am attempting the following:
I have an existing MQWF system on Box A. I have another MQWF system on Box B. Both of these are DB2 8.1; MQ 5.3.1; MQWF V3.4.
I am attempting to define a second system on Box B that points to the System Group on Box A.
I have followed all of the instructions in the Installation guide in section "Planning an additional system in a system group" (p 158 in V3.4 install guide).
I am getting the following error:
[IBM][CLI Driver] SQL30081N A communication error has been
detected. Communication protocol being used: "TCP/IP".
Communication API being used: "SOCKETS". Location where the
error was detected: "". Communication function detecting the
error: "connect". Protocol specific error code(s): "10061",
"*", "*". SQLSTATE=08001
Any help will be appreciated.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue Mar 18, 2003 1:54 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I think that's a DB2 error.
Have you catalogued(on machine B) the RT DB on the right port.
See if DB2 is listening on the port.
You better verify your DB2 setup by doing an "attach" and then connect fron machine B.
-------
Venny |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Mar 18, 2003 1:58 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Venny:
The attach fails with the same error.
How do I determine if DB2 is listening on the port?
Thanks
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue Mar 18, 2003 2:07 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
svcename is the port name.
do a get dbm cfg on your db2 server and check the 'svcename' parameter.
if you are using the default db2 instance for workflow, then the svcename will be 'db2cDB2'.
-Laze |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Mar 18, 2003 2:13 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What platform?
This is how I do it on unix platforms.
on machine A
1. db2 get dbm cfg | grep -i SVCENAME
and find out what SVCENAME's value is. (say db2insabcd)
2. view the /etc/services file and see the port for alias db2insabcd
then
3. netstat -na
and see if the port is in listening state.
If it's on Windows I think the procedure is same except for the services file location.
But if DB2 has a default install it should be on port 50000.
Hope this helps
-------
Venny |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue Mar 18, 2003 2:18 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
To find the port number for a db2 instance in windows you can do the following:
Open the control center on DB2 server.
Right Click the instance you need and click "Setup Communications".
Click the properties for TCPIP. you will find the svcename and port number in there.
-Laze |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Mar 18, 2003 3:06 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| vennela wrote: |
What platform?
If it's on Windows I think the procedure is same except for the services file location.
But if DB2 has a default install it should be on port 50000.
Hope this helps
-------
Venny |
Venny:
That did it for me... I was using the wrong DB2 port. Now, I can start the Admin Utility from Box B.
But how do I get the Fat Client to access the system? What I need I think is a combined channelTable that contains both of my systems, but I dont know how to create that. Any ideas?
THANKS
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue Mar 18, 2003 3:24 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
You donot have to need channel table data from SYS A, because you are confiuring an additional system.
Just configure the client normally with its QM and QM of SYS A. It should work.
-Laze |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Mar 18, 2003 3:30 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Laze:
Its working Kinda... I can login but the Templates that are in the DB on the other side are not showing up?
I'm still confused.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue Mar 18, 2003 3:41 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I am confused. Are you saying process templates are not showing up?
-Laze. |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Mar 18, 2003 3:51 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
YEP... There are templates in there and I dont see them in the client.
The wierd thing is if I use DB2 to have a look at the tables, I see the Templates in the ProcessModel table.
Also, I have two users logged on one from each machine, and I see both logged in users in the Session Table.
Really strange... But Im sure Im just doing something silly.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue Mar 18, 2003 4:49 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Weird. 
What are you seeing in the process templates window? nothing?
-Laze |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Mar 18, 2003 5:00 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Laze:
Don't know what changed, but now I see the templates. I just cycled the servers and they showed up.
Doesn't make any sense, but I think at this point I have this working the way I had anticipated it should work.
Thanks everyone for your help
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| manoj |
| Posted: Mon Mar 24, 2003 7:38 pm Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
Hi John,
I 've the following points
1. When u add a second system to the same system group it doesn't matter which system u r connecting to since both the system share the same runtime database (runtime DB is per System group in general)
2. u 've a fat client and u want the fat client to connect to both the systems automatically (i assume u r fat client is configured as a client with queue manager). Inorder to achieve this ,in the fat client configuration (say FMC3 is the cofig id of the fat client) u 've to add two connect names,one for the primary system and the other for the secondary system. In the java code i think u should use
Agen.setConfigId("FMC3") instead of directly looking up for the system.
i ven't tried this , please post me if u r getting any success with the above tip.
thx
_________________
-manoj |
|
| Back to top |
|
|
|
|
