| Author |
Message
|
| pfaulkner |
 Posted: Tue Aug 20, 2002 9:24 am Post subject: Database Errors |
 |
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
I have a Message Flow that has 10 MQInput Nodes and everything seems to work fine most of the time. Every so often I get the following errors in my AIX Broker log:
Aug 20 11:50:21 cose2e1 WMQIv210[43210]: (BROKER1.EMTExecutionGroup)[5141]BIP2628E: Exception condition detected on input node 'EMT7_RE
PLY.0007'. : BROKER1.0f4d328c-ef00-0000-0080-be1d007eaa78: /build/S000_P/src/DataFlowEngine/ImbMqInputNode.cpp: 1248: ImbMqInputNode::r
eadQueue: ComIbmMQInputNode: 9832c0c1-ef00-0000-0080-ef8ed9a98840
Aug 20 11:50:21 cose2e1 WMQIv210[43210]: (BROKER1.EMTExecutionGroup)[5141]BIP2230E: Error detected whilst processing a message in node
'EMT7_REPLY.EMT_PARSE_REGISTRY_MSG1.Parse header as MRM'. : BROKER1.0f4d328c-ef00-0000-0080-be1d007eaa78: /build/S000_P/src/DataFlowEng
ine/BasicNodes/ImbResetContentDescNode.cpp: 462: ImbResetContentDescNode::evaluate: bbfc73b2-ef00-0000-0080-ef8ed9a98840.0d4b3dd7-ed00-
0000-0080-f6615009c53c: bbfc73b2-ef00-0000-0080-ef8ed9a98840.0d4b3dd7-ed00-0000-0080-f6615009c53c
Aug 20 11:50:21 cose2e1 WMQIv210[43210]: (BROKER1.EMTExecutionGroup)[5141]BIP2321E: Database error: ODBC return code '-1'. : BROKER1.0f
4d328c-ef00-0000-0080-be1d007eaa78: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 142: ImbOdbcHandle::checkRcInner: :
Aug 20 11:50:21 cose2e1 WMQIv210[43210]: (BROKER1.EMTExecutionGroup)[5141]BIP2322E: Database error: SQL State '08001'; Native Error Cod
e '-1224'; Error Text '[IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a r
esult of a database system shutdown or a force command. SQLSTATE=55032: BROKER1.0f4d328c-ef00-0000-0080-be1d007eaa78: /build/S000_P/sr
c/DataFlowEngine/ImbOdbc.cpp: 232: ImbOdbcHandle::checkRcInner: :
It seems to happen randomly, sometimes for multiple messages in a row then everything works again???
Any help would be appreciated.
thanks |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Aug 20, 2002 9:39 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
|
| Back to top |
|
|
| pfaulkner |
| Posted: Tue Sep 03, 2002 12:41 pm Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
I followed the instructions and still have the same issue.
From the notes in the link, I have the following values:
maxuproc = 1200
processess running = 33
maxappls = 40
avg appls = 1
Should I try increasing maxappls? If so do you know how, I looked through the DB2 books but only found out to view it.
Any other ideas?
I am running DB2 7.1.0 |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Sep 03, 2002 1:14 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Try increasing maxappls parameter to 100. I would also increase avg_appls to 5.
Using DB2 control Center select configure.. for your database by right clicking on it. Under Applications tab, you will see parameters, maxappls, avg_appls.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| pfaulkner |
| Posted: Tue Sep 03, 2002 1:20 pm Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
| It's DB2 for AIX. I assume those instructions were for NT? |
|
| Back to top |
|
|
| pfaulkner |
| Posted: Tue Sep 03, 2002 1:29 pm Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
Found it in the manual.
For anyone else following along that cares....it's:
UPDATE DATABASE CONFIGURATION FOR dbname USING MAXAPPLS 100 |
|
| Back to top |
|
|
| pfaulkner |
| Posted: Tue Sep 03, 2002 1:35 pm Post subject: |
|
|
Master
Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA
|
Didn't help though. Still getting same errors. Seems like it works for a few messages then breaks for a few and then works again. The most I have seen it work for is 4 messages in a row.
What happens when we have millions of messages going through this thing? |
|
| Back to top |
|
|
| Nyusser |
| Posted: Thu Sep 05, 2002 1:15 am Post subject: |
|
|
Apprentice
Joined: 02 Jul 2002
Posts: 48
|
|
| Back to top |
|
|
|
|
