| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Urgent Please, Database Agent |
« View previous topic :: View next topic » |
| Author |
Message
|
| abaaa |
 Posted: Wed Sep 03, 2003 4:57 am Post subject: Urgent Please, Database Agent |
 |
|
Newbie
Joined: 03 Sep 2003
Posts: 7
|
Hi all,
We are using
MQSI V2.0.1 CSD 5, on AIX SP NODE 4.3.3, DB2 6.1.0.31
I always face a problem with DB2 agents and I had to reboot all the system to recover it.
in my exceptionlist the error is:
(0x3000000)Type = 5
(0x3000000)Text = '[IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or
was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032
Please, I need a solution for this problem.
 |
|
| Back to top |
|
 |
| Craig B |
| Posted: Wed Sep 03, 2003 5:20 am Post subject: |
|
|
Partisan
Joined: 18 Jun 2003
Posts: 316
Location: UK
|
Hi,
Have you configured your Database connections to use TCP/IP loopback? In AIX, by default DB2, allows a maximum of 10 concurrent shared memory connections. Your error message is indicating that the limit of 10 has been reached. However if you configured your DB2 to use TCP/IP loopback, then this 10 shared memory connections limit will be removed and connectivity will be via TCP/IP between a local DB2 client and local DB2 server database.
This information is definitely in the Problem Determination guide for V2.1 and in V5 InfoCentre .... but Im not sure if it is in the V2.01 and v2.02 Problem determination guide.
_________________
Regards
Craig |
|
| Back to top |
|
|
| abaaa |
| Posted: Wed Sep 03, 2003 6:53 am Post subject: |
|
|
Newbie
Joined: 03 Sep 2003
Posts: 7
|
Thanks for the quick response.
If you can explain to me how to know if TCP/IP loopback is configured or not. I have defined db2 sevice on /etc/services with port number. and
in the dbm cfg the svcname is the same one in the /etc/services.
regards,,  |
|
| Back to top |
|
|
| Craig B |
| Posted: Wed Sep 03, 2003 8:10 am Post subject: |
|
|
Partisan
Joined: 18 Jun 2003
Posts: 316
Location: UK
|
Hi,
This is a summarised version of setting this up :
Ensure the 'DB2 Registry' (sic) variable DB2COMM is set to include TCP/IP:
query with :
db2set -all DB2COMM
and, if necessary, add tcp/ip:
db2set DB2COMM=tcpip
Note it can take multiple values so you may need to modify this example of the db2set command to include any existing settings - see the DB2 doc for syntax.
Next, update the DB2 DB manager configuration to use the services name specified in /etc/services for the connection port to the DB2 instance ('db2cdb2inst1' in these example commands which are for an instance called 'db2inst1'):
db2 update dbm cfg using svcename db2cdb2inst1
This gives a mapping to the TCP/IP port number on which the DB2 server will listen.
Cycle the DB2 DB manager to pick-up the new configuration by stopping all connected applications such as the wmqi broker (you can issue :
db2 force application all
to make sure) then db2 stop and then db2 start
Now configure an alias which will resolve connections via TCP/IP:
db2 catalog tcpip node local remote localhost server db2cdb2inst
(i.e. resolve to a server on the local tcp/ip hostname using the tcp/ip service and port specified above).
Assuming the real user database has been created on the default node with a command like :
db2 create db <user dbname>
You then have to create an alias to it which will when accessed via ODBC will get resolved using a TCP/IP connection:
db2 catalog db <user dbname> as <DNS name> at node local
_________________
Regards
Craig |
|
| Back to top |
|
|
| abaaa |
| Posted: Mon Sep 08, 2003 3:41 am Post subject: |
|
|
Newbie
Joined: 03 Sep 2003
Posts: 7
|
Hi,
What I have found on the last days invistagation and reading.
The DB2 registry and the mapping to tcpip port number already done before. what I missed are the catalog operations.
So can I do the catalog while the system is runnind. Or is there any risk of doing that?
Do you think this is what casue the probelm.
See the existed definition:
Database alias = XXX02
Database name = XXX02
Local database directory = /var/mqsi
Database release level = 9.00
Comment =
Directory entry type = Indirect
Catalog node number = 0
Database 6 entry:
Database alias = XAA
Database name = XXX02
Local database directory = /var/mqsi <----- NODE---LOCAL
Database release level = 9.00
Comment =
Directory entry type = Indirect <----- remote
Catalog node number = 0
The conclusions are:
- I need to catalog tcpip...
- I need to catalog this database to an aliass with a local node.
Regrads,
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
