Unix Technical Forum

Re: Not enough memory to load library modules

This is a discussion on Re: Not enough memory to load library modules within the DB2 forums, part of the Database Server Software category; --> No, You should not increase the size of the bufferpool. This pool is used to buffer table rows, not ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 03:32 PM
Anton Versteeg
 
Posts: n/a
Default Re: Not enough memory to load library modules

No,
You should not increase the size of the bufferpool.
This pool is used to buffer table rows, not to execute programs.
So decreasing the size of the bufferpool and some other database
parameters might be a good idea.
DB2 32-bit on AIX can use a maximum of about 1.5 GB shared memory per
DB2 instance.
I guess your options are:
1. switch over to multiple partitions (EEE)
2. upgrade to DB2 verision 8 64-bit (if you have enough memory)
3. tune the database parameters.

Bruce Pullen wrote:

>DB2 UDB 7.2 on AIX 4.3.3
>
>Our applications are failing with the following error
>
>SQL10015N There are not enough system resources to load the specified
>library "<name>".
>Explanation: There is not enough memory to load the library module.
>
>The only assistance I can find are the resolution tips from the
>documentation which are:
>1) Remove background processes.
>2) Decrease the values of the configuration parameters that define the
>allocation of memory.
>3) Install more memory.
>
>But if DB2 is complaining that there is not enough memory, what is the
>point in reducing it (point 2)? There is plenty of available memory in
>the machine, so should I look at increasing memory available to DB2
>(bufferpool, db2heap ...?)
>Can anyone help?
>Thank you.
>
>


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:26 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com