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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |