Results 1 to 9 of 9

Thread: Instance_memory

  1. #1
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72

    Unanswered: 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.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What is your question?

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

  4. #4
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72
    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.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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.

  7. #7
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72
    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 14:11.

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you try the manual?

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can also google for Exploring Memory in DB2 9.5 and Beyond

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •