| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Is there a limit to the size of a message flow? |
« View previous topic :: View next topic » |
| Author |
Message
|
| DJN |
 Posted: Mon Apr 14, 2003 9:42 am Post subject: Is there a limit to the size of a message flow? |
 |
|
Apprentice
Joined: 14 Apr 2003
Posts: 47
|
My flow is rather large and there are two distinct paths for a message to take. Recently I have experienced a problem where the flow will not deploy (log info follows). When I delete either of the paths from the flow the deployment is successful.
Log entries:
Apr 14 11:37:58 mqd01 WMQIv210[88732]: (UD01.Don)[3085]BIP2223I: A database operation was retried: attempt 3 of 10; diagnostic information 'ConfigurationMessageFlow.ConfigurationNode'. : UD01.ea73a744-f400-0000-0080-a1f2040ab362: /build/S210_P/src/DataFlowEngine/ImbConfigurationNode.cpp: 337: ImbConfigurationNode::evaluate: ComIbmConfigurationNode: ConfigurationNode
Apr 14 11:37:58 mqd01 WMQIv210[88732]: (UD01.Don)[3085]BIP2371E: Database statement 'INSERT INTO IBCMQS.BROKERRESOURCES (BrokerUUID, ExecGroupUUID, ResourceType, ResourceName, ResourceData) VALUES (?, ?, ?, ?, ?)' could not be executed. : UD01.ea73a744-f400-0000-0080-a1f2040ab362: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 1225: ImbOdbcStatement::execDirect: :
Apr 14 11:37:58 mqd01 WMQIv210[88732]: (UD01.Don)[3085]BIP2321E: Database error: ODBC return code '-1'. : UD01.ea73a744-f400-0000-0080-a1f2040ab362: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 147: ImbOdbcHandle::checkRcInner: :
Apr 14 11:37:58 mqd01 WMQIv210[88732]: (UD01.Don)[3085]BIP2322E: Database error: SQL State '57011'; Native Error Code '-973'; Error Text '[IBM][CLI Driver][DB2/6000] SQL0973N Not enough storage is available in the "QUERY_HEAP" heap to process the statement. SQLSTATE=57011: UD01.ea73a744-f400-0000-0080-a1f2040ab362: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 247: ImbOdbcHandle::checkRcInner: :
 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Apr 14, 2003 10:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
When you created your broker database, did you adjust the dbheap size as recommended? The Administration guide (or is it the Installation&Planning Guide?) recommends setting dbheap to 900.
If you did that or if you didn't, you can try increasing it or the sortheap, stmtheap, or applheapsz.
I don't know this will work, but it seems like a place to start based on the error mesage about 'QUERY_HEAP'. |
|
| Back to top |
|
|
| tillywern |
| Posted: Mon Apr 14, 2003 1:29 pm Post subject: Inefficient representation of data |
|
|
Centurion
Joined: 28 Jan 2003
Posts: 109
Location: Colorado
|
I second the ideas in the first post.... Remember that flows are, in the end, a bunch of XML stored in a database.. or on messges. It is very imporatnt to ensure that the databases supporting MQSI, both for config mgr and broker, are sized properly...
You should have a DBA look at you databases to ensure that they have parameters that will allows large flows if you are going to use them...
The problem is not just on of database either... Remember that MQ queues need to be large enough to handle the XML sent between the config manager and broker... And the broker database needs to be tuned enough to allow for insertion and querying the data held within. |
|
| Back to top |
|
|
| DJN |
| Posted: Tue Apr 15, 2003 9:10 am Post subject: |
|
|
Apprentice
Joined: 14 Apr 2003
Posts: 47
|
| [size=18]Thanks to all who replied.... increasing the number of pages did the trick!!!!!![/size] |
|
| 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
|
|
|
|
