| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |

04-19-11, 18:30
|
|
Registered User
|
|
Join Date: Nov 2003
Location: California,USA
Posts: 71
|
|
|
Instance_memory
|
|
DB2 v9.5.0.4
AIX 5.3.0.0
In our development server we have around 10 instances with INSTANCE_MEMORY set to AUTOMATIC.
There are database ranging 2 - 4 in each of the instances.
Now I have to create two more databases and getting the below error when I try to connect 4th database in the same instance.
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
2236088320
All the databases were AUTO configured and bufferpools are also set to automatic.
Any clue is greatly appreciated.
Thanks in advance.
|
|

04-20-11, 07:46
|
|
:-)
|
|
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
|
|
|
|

04-20-11, 08:02
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
|
|
in addition to n_i's question, is it 32- or 64- bit installation ?
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
|
|

04-20-11, 12:48
|
|
Registered User
|
|
Join Date: Nov 2003
Location: California,USA
Posts: 71
|
|
It is 64 bit.
The issue is, in any instance when I try to active 4th database, getting the below error.
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
2236088320
How can I make sure the memory calculations.
|
|

04-20-11, 13:20
|
|
:-)
|
|
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
|
|
If you set database memory to automatic, I suggest you set each instance memory to approximately 1/10th of the memory available for DB2 (if all of them are active at the same time). However, I have a feeling that, at least for some databases, the database_memory parameter is not automatic.
|
|

04-20-11, 13:20
|
|
Registered User
|
|
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
|
|
development server? Then I can give this advice: search for the biggest bufferpool in 1 of the running databases, manually decrease the size considerable, re-try to start the extra database. Because you've just released a fair amount of memory it should work now.
When all the databases are running with STMM enabled (also for the bufferpool you just robbed) things will level out.
P.S. find the developers and compensate them with a cup of coffee.
|
|

04-21-11, 12:55
|
|
Registered User
|
|
Join Date: Nov 2003
Location: California,USA
Posts: 71
|
|
Thank you for the responses.
Would anyone direct me to the right document for a clearer explanation about the memory allocation options in AIX (INSTANCE_MEMORY, DATABASE_MEMORY AND STMM, BPOOLs, etc).
|
Last edited by nagasurir; 04-21-11 at 13:11.
|

04-21-11, 14:57
|
|
:-)
|
|
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
|
|
|
|

04-21-11, 19:02
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
You can also google for Exploring Memory in DB2 9.5 and Beyond
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|