| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Error Selecting Large Number of Records |
« View previous topic :: View next topic » |
| Author |
Message
|
| muneetb |
 Posted: Wed May 07, 2003 6:48 am Post subject: Error Selecting Large Number of Records |
 |
|
Newbie
Joined: 25 Oct 2002
Posts: 8
|
Hello--
I am having trouble selecting large number of records in the compute node. Is it possible to select more than 50000 records within MQSI? It works well for a few hundred records but crashes as soon as we get into thousands. Also, each record in this case is approximately equal to 4 Kb. I am runnning the broker on a solaris box which has 2 Gigs of RAM. The broker houses six execution groups. Is there a simple way to do this?
Here is my select statement:
SELECT COUNT(*) FROM MQ.BATCHWO AS T WHERE T.MSGID = CHAR(x'C3E2D840C4D4D8F14040404040404040B9536B2E75C2A701') AND (T.ACTIONIND = '711' OR T.ACTIONIND= '712' OR T.ACTIONIND= '701' OR T.ACTIONIND= '708')
Here is the error I get:
2003-05-07 09:28:53.365292 19 DatabaseException BIP2322E: Database error: SQL State '57011'; Native Error Code '-973'; Error Text '[IBM][CLI Driver][DB2/SUN] SQL0973N Not enough storage is available in the "APP_CTL_HEAP" heap to process the statement. SQLSTATE=57011
'.
Thanks!
--Muneet |
|
| Back to top |
|
 |
| Ian |
| Posted: Wed May 07, 2003 7:27 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Hi,
The error message is clear :
| Quote: |
SQL0973N Not enough storage is available in the "APP_CTL_HEAP" heap to process the statement.
|
You will need to increase your APP_CTL_HEAP size. The default (I think) is 128 4K pages and you can increase this to 1024, 2048 etc.
Suggest you discuss this with your DB2 DBA to establish the appropriate setting for your apllications requirements.
_________________
Regards, Ian |
|
| Back to top |
|
|
| muneetb |
| Posted: Wed May 07, 2003 8:29 am Post subject: |
|
|
Newbie
Joined: 25 Oct 2002
Posts: 8
|
| Yes I have tried increasing the heap size but that just gives me the ability to query twice as many records but I am nowhere near 50000 records. |
|
| Back to top |
|
|
| dandydon |
| Posted: Thu May 08, 2003 10:23 am Post subject: |
|
|
Newbie
Joined: 08 May 2003
Posts: 6
Location: Fort Worth, Texas
|
I first encountered the APP_CTL_HEAP message last year when inserting a large number of Message Flows into one Execution Group. Everything worked OK on our Development System, but failed with the APP_CTL_HEAP message on the Production System. The difference was the number of Message Flows in the Execution Group. Creating more Execution Groups, each containing fewer Message Flows, solved this problem temporarily. I then searched the net for the error message, found the solution, and increased the heap size in DB2 to 1024. Since you have already increased the heap size, if the Message Flow giving you the problem is not the only flow in the Execution Group, you could try putting it into an Execution Group all by itself.  |
|
| 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
|
|
|
|
