bufferpool not starting up..

Thol Chidambaram

bufferpool not starting up..
Hi Listers,

We are running DB2 7.2 in Solaris 64-bit. I'm frequently encountering memory
allocation problems in different databases. Database starts up with default
pools with warning message (1478W). I checked the bufferpools files and they
are fine.
Can you please let me know any suggestions for this problem.

Thanks for the help,
Thol

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Aurora Dellanno

Re: bufferpool not starting up..
(in response to Thol Chidambaram)
Hi Thol,

This is normally related to the fact that you do not have enough real
storage to back up your bufferpool size definition, or that the total size
of your BP's exceeds your real storage - same difference as far as you are
concerned.

Resize one or all BPs, to be within your machine's limit and you will see
the messages disappear.

ciao!

Aurora Emanuela Dell'Anno
Database Analyst
Data Services Group - Bank of America
tel. 66192
ext. 0208 760 6192
[login to unmask email]

* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER

no trees were killed in sending this message. However, a large number of
electrons were seriously inconvenienced :-)



-----Original Message-----
From: Chidambaram, Thol [mailto:[login to unmask email]
Sent: 11 December 2003 19:48
To: [login to unmask email]
Subject: bufferpool not starting up..


Hi Listers,

We are running DB2 7.2 in Solaris 64-bit. I'm frequently encountering memory
allocation problems in different databases. Database starts up with default
pools with warning message (1478W). I checked the bufferpools files and they
are fine.
Can you please let me know any suggestions for this problem.

Thanks for the help,
Thol

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

Notice to recipient:
The information in this internet e-mail and any attachments is confidential
and may be privileged. It is intended solely for the addressee. If you are
not the intended addressee please notify the sender immediately by
telephone. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful.
When addressed to external clients any opinions or advice contained in this
internet e-mail are subject to the terms and conditions expressed in any
applicable governing terms of business or client engagement letter issued by
the pertinent Bank of America group entity.
If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of America
Futures Incorporated are regulated by the Financial Services Authority.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm