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.

 
Go Back  dBforums > Database Server Software > DB2 > Instance_memory

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-19-11, 18:30
nagasurir nagasurir is offline
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.
Reply With Quote
  #2 (permalink)  
Old 04-20-11, 07:46
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
What is your question?
Reply With Quote
  #3 (permalink)  
Old 04-20-11, 08:02
sathyaram_s sathyaram_s is offline
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.
Reply With Quote
  #4 (permalink)  
Old 04-20-11, 12:48
nagasurir nagasurir is offline
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.
Reply With Quote
  #5 (permalink)  
Old 04-20-11, 13:20
n_i n_i is offline
:-)
 
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.
Reply With Quote
  #6 (permalink)  
Old 04-20-11, 13:20
dr_te_z dr_te_z is offline
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.
Reply With Quote
  #7 (permalink)  
Old 04-21-11, 12:55
nagasurir nagasurir is offline
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.
Reply With Quote
  #8 (permalink)  
Old 04-21-11, 14:57
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Did you try the manual?
Reply With Quote
  #9 (permalink)  
Old 04-21-11, 19:02
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
You can also google for Exploring Memory in DB2 9.5 and Beyond
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On