By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

plz help urgent

P: n/a
hi,
when i tried to create buffer pool in production

The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657
and when I re-start database i am getting

SQL1478W The defined buffer pools could not be started. Instead, one
small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

i'm using 32-bit version of db2(production server) for windows. and
it works fine in my local server which is also of same config

i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???
thnaks and regards
sridhar

Sep 13 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
situ wrote:
hi,
when i tried to create buffer pool in production

The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657
and when I re-start database i am getting

SQL1478W The defined buffer pools could not be started. Instead, one
small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

i'm using 32-bit version of db2(production server) for windows. and
it works fine in my local server which is also of same config

i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???
It appears you don't have enough memory for the buffer pools requested.
So if you decrease their sizes to a more reasonable limit you should be
fine.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 13 '06 #2

P: n/a

Serge Rielau wrote:
situ wrote:
hi,
when i tried to create buffer pool in production

The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657
and when I re-start database i am getting

SQL1478W The defined buffer pools could not be started. Instead, one
small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

i'm using 32-bit version of db2(production server) for windows. and
it works fine in my local server which is also of same config

i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???
It appears you don't have enough memory for the buffer pools requested.
So if you decrease their sizes to a more reasonable limit you should be
fine.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

thanks serge,

apart from resizing, is there any thing that can be done from OS side
like doing some change in memory allotment and also from db2 by
configuring some parameters

thnks and regrads
sri

Sep 13 '06 #3

P: n/a
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???

thnaks and regards
sridhar
In many cases (depending on the OS), you cannot even get up to 2GB with
32bit instance. Try lowering the bufferpools to 1GB.
Sep 13 '06 #4

P: n/a

Mark A wrote:
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???

thnaks and regards
sridhar

In many cases (depending on the OS), you cannot even get up to 2GB with
32bit instance. Try lowering the bufferpools to 1GB.
thanks
till now i have'nt fix it yet, i.e i didn't decrease the buffer pool
size,
but i restarted the prod server and i connected the application to the
database amezing it seems to be working fine,
till now it doesn't bombed anywhere :)

but i have a suspicion that whether it is still using internal
bufferpools,

is there any way to know the data base is using a specifed bufferpools
what i have assigned

thanks

sri

Sep 13 '06 #5

P: n/a
"situ" <SR********@REDIFFMAIL.COMwrote in message
>
thanks
till now i have'nt fix it yet, i.e i didn't decrease the buffer pool
size,
but i restarted the prod server and i connected the application to the
database amezing it seems to be working fine,
till now it doesn't bombed anywhere :)

but i have a suspicion that whether it is still using internal
bufferpools,

is there any way to know the data base is using a specifed bufferpools
what i have assigned

thanks

sri
Look at the db2diag.log to see if the hiden bufferpools are used just after
instance startup.
Sep 13 '06 #6

P: n/a
situ wrote:
apart from resizing, is there any thing that can be done from OS side
like doing some change in memory allotment and also from db2 by
configuring some parameters
You could move to a 64bit system.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Sep 13 '06 #7

P: n/a
Don't know if you want to leave it this way. Depends upon what
bufferpool sizes you ended up with. Your performance may suffer.

Larry E.

situ wrote:
Mark A wrote:
>>"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@i3g2000cwc.googleg roups.com...
>>>i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???

thnaks and regards
sridhar

In many cases (depending on the OS), you cannot even get up to 2GB with
32bit instance. Try lowering the bufferpools to 1GB.


thanks
till now i have'nt fix it yet, i.e i didn't decrease the buffer pool
size,
but i restarted the prod server and i connected the application to the
database amezing it seems to be working fine,
till now it doesn't bombed anywhere :)

but i have a suspicion that whether it is still using internal
bufferpools,

is there any way to know the data base is using a specifed bufferpools
what i have assigned

thanks

sri
Sep 13 '06 #8

P: n/a
The other thing you could do is:
1) State which version of DB2 tyou're on. Answer to this is deopendent on
V7 or V8/V9. As well the OS as this has an impact on all versions of DB2.
2) A little bit of reading the DB2 Quick Beginnings, which is online, will
show you, for your OS, what are the constraints on memory size, bufferpools
and what , if anything can be done.

Then. when you have explored this, a post here will help you and us try to
find out what can be done, if anything.
I know I'm asking a lot here but we'd all like to help.
Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"situ" <SR********@REDIFFMAIL.COMa écrit dans le message de news:
11**********************@b28g2000cwb.googlegroups. com...
>
Serge Rielau wrote:
>situ wrote:
hi,
when i tried to create buffer pool in production

The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657
and when I re-start database i am getting

SQL1478W The defined buffer pools could not be started. Instead, one
small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626

i'm using 32-bit version of db2(production server) for windows. and
it works fine in my local server which is also of same config

i know The 32-bit version of DB2 can only access a maximum of 2GB of
memory.

but what is the fix for this??????

how could i get out of this situation now???
It appears you don't have enough memory for the buffer pools requested.
So if you decrease their sizes to a more reasonable limit you should be
fine.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/


thanks serge,

apart from resizing, is there any thing that can be done from OS side
like doing some change in memory allotment and also from db2 by
configuring some parameters

thnks and regrads
sri
Sep 13 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.