Error SQL1084C when start db2

nmcuong · #1 (**permalink**) 07-14-11, 05:30

I have a database db2 on Win 2003 32 bit.

Anh I can't start database after config memory of database.

The error is SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019.

How can I start my database? Please help..........

ARWinner · #2 (**permalink**) 07-14-11, 10:31

You do not have enough memory for your configuration.

Please post output from "GET DBM CFG" and "GET DB CFG...". Also supply us with how much memory you have on the server.

Andy

n_i · #3 (**permalink**) 07-14-11, 10:42

What changes did you make to the memory configuration. My first guess would be to revert them.

nmcuong · #4 (**permalink**) 07-16-11, 11:05

Quote:

Originally Posted by n_i

What changes did you make to the memory configuration. My first guess would be to revert them.

I don't remember what I do

n_i · #5 (**permalink**) 07-16-11, 12:28

Looking in db2diag.log might give you a hint.

db2girl · #6 (**permalink**) 07-16-11, 14:31

What you can try to do is to set DB2_OVERRIDE_BPF registry variable to, let's say, 1000 and restart the instance. Then, connect to the db and reduce some config parameters (ie. bufferpools). Remember to unset this register variable and restart the instance after you're done.

nmcuong · #7 (**permalink**) 08-09-11, 22:33

Quote:

Originally Posted by db2girl

What you can try to do is to set DB2_OVERRIDE_BPF registry variable to, let's say, 1000 and restart the instance. Then, connect to the db and reduce some config parameters (ie. bufferpools). Remember to unset this register variable and restart the instance after you're done.

Ok thanks, I will try...

Internet Services

Web Development

Digital Marketing

Consumer Tech