sheapthres_shr is a hard limit.. Once you reach the limit , probably you
will get the error message..SQL0955C...
You can try increasing SORTHEAP(db cfg) make it 512 , (increase the
sheapthres_shr also), look at the SQL's, as mentioned by others...
Amit Rai.
-----Original Message-----
From: Maxim Ness
[mailto:db2udbdba-ezmlmshield-x7147995.[Email address protected]
Sent: Wednesday, October 26, 2005 3:25 PM
To: LazyDBA Discussion
Subject: sort overflow, emergency
Hello DBA's,
Environment : DB2 UDB 1.6.1, windows 2000 adv server.
I am getting a huge amount of sort overflows for one application we are
running on DB2. The ratio is about 2 statements/ 1 overflow. Instance
has INTRA_PARALLEL ON, 1 GB of memory assigned to sheapthres, 40 mb
assigned to sheapthres_shr, 1.5 mg for SORTHEAP.
When i take a snapshot for applications i see that my custom program is
using shared memory to perform sorts. If sheapthres_shr is set to the
hard limit of 40 mg and it ran out of free space will i get an error in
db2diag.log ? Also in the snapshot for application how db2 reports
shared memory, in bytes or in db2 pages ?
What else can i do to eliminate the sort overflows ? Please help this is
a huge production issue.
Thank you in advance !
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page