sql1478w for new database

L_DBA_L · #1 (**permalink**) 09-23-09, 20:11

Hi,

I can't connect to a brand new database, getting sql1478w - defined buffer pool can't be started. I'm using 9.5 on Linux.

Thank a lot.

Marcus_A · #2 (**permalink**) 09-23-09, 20:47

You have run out of free memory on the machine. DB2 cannot use virtual memory, real memory must be available.

You will need to temporarily override your bufferpool sizes, then you can connect into the database and alter bufferpool size(s) via SQL, then reset the override back to null (so the override is no longer in effect).

These are the steps:

db2stop
db2set DB2_OVERRIDE_BPF=1000
db2start
db2 connect to <database-name>
db2 ALTER bufferpool <oversized-bufferpool-name> SIZE <some reasonable number of pages based on real memory available>
db2 terminate
db2stop
db2set DB2_OVERRIDE_BPF=
db2start
db2 connect to <database-name>

L_DBA_L · #3 (**permalink**) 09-23-09, 20:52

Marcus_A, I did not create any bufferpools. All I did was to issue - create database command.

L_DBA_L · #4 (**permalink**) 09-23-09, 21:35

I want to correct myself, I can connect but with sql1478w. I checked the bufferpools - default one exists with a very large size. The size is almost 1.5 gig. I don't understand why it was created using this size if I only have 2 gig of memory on this server.

Marcus_A · #5 (**permalink**) 09-24-09, 00:05

Keep in mind that if you receive the SQL1478W error message, the defined buffer pools could not be started. Instead, one very small buffer pool for each page size has been started by DB2. So your database will perform very slowly with such as small bufferpool size when you connect with that error messge. Please change the bufferpool size of the default bufferpool (that you mentioned is defined to 1.5 GB) to something more reasonable and restart DB2.

L_DBA_L · #6 (**permalink**) 09-24-09, 19:46

I lowered the buffer pool size and then connected without sql1478w. I then decided to drop the database and created it again - used create database command. Database was created okay and then connect generated sql1478w. I don't understand why.