Hi Luis, I faced a similar problem in AIXv5.2 with WMQI v2.1 CSD 04, which was due to DB2 problem on AIX, that a process cann't have more than 10 connections if the database is local, as it uses IPC's for DB2 Connections.
For analysing the exact problem, try logging the ExceptionList tree from MQOutput Node to a file using Trace node. If the problem is related to DB2, then try cataloging the broker database as a remote database, in which case the DB2 connections are obtained through TCP/IP Sockets. Please refer to the attached text file for information related to changes required for DB2. Regards, Rajkumar Torry Harris Business Solutions Bangalore, India
DB2 Problem in AIX / Alternate Solution ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Problem : ---------- On AIX, DB2 will issue SQL 1224N when the Broker process tries to access the Broker database for fetching details regarding Message Sets. Hence the processing of message flows fail. Observation : -------------- This is due to the limitation in number of connection available to Broker. Since the database is in local machine as that of production broker, the odbc dsn for broker uses Interprocess communication for getting connection to database, which means Shared memory segment will be used for attaching the client (odbc dsn) to the DB2 Server agent process. This has a limitation that a single process (like broker) cannot have more than 10 concurrent sessions with the server. Hence at times, when the requirement to have more than 10 sessions arises, the broker cannot be serviced by DB2. Resolution : ------------- Catalog the database as remote database by configuring the TCP/IP Loopback. This will make broker to use TCP/IP communication, in which case it communicates to DB2 agent process via sockets. Using sockets the broker requests to the database will be serviced completely. Steps: ------- 1. Find the db2 service name for the instance. command : ========= “db2 get dbm cfg | grep –i svcename” 2. Catalog the loopback node command: ======== “db2 catalog tcpip node <name> remote 127.0.0.1 server <service name>” where replace <name> with the reference node name replace <service name> with the ouput from step.1 example: db2 catalog tcpip node WMQINODE remote 127.0.0.1 server db2cdb2inst20 3. Catalog the database as follows commands: ========== db2 catalog db <database name> as <database alias> db2 uncatalog db <database name> db2 catalog db <database alias> as <database name> at node <nodename> example: db2 catalog db WMQIBKDB as PRDBKDB db2 uncatalog db WMQIBKDB db2 catalog db PRDBKDB as WMQIBKDB at node WMQINODE Note : ------ The database alias name can be any name but not same as the database name. SQL1334N will result if the database is not configured properly 4. Restart DB2 to refresh to directory cache. commands: ========= db2stop db2start