Suresh,
Thanks,
Sue
"Suresh" <db2udbdba-ezmlmshield-x21964309.[Email address protected]
02/26/2007 02:02 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Re: DB2 BUFFERPOOL
db2pd -osinfo
Suresh G.
"Sheuehua" <db2udbdba-ezmlmshield-x18521361.[Email address protected]
02/26/2007 12:58 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Re: DB2 BUFFERPOOL
Hi,
Using what command in AIX and you see you have 8GB memory ?
Sue
"RLam" <db2udbdba-ezmlmshield-x40593343.[Email address protected]
02/26/2007 01:07 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
DB2 BUFFERPOOL
Hello, I need your help.
I increased a 4K buffer pool from 48,000 pages to 96,000 pages in our
production instance and db2diag showed the following error:
MESSAGE : ADM6050W The ALTER BUFFERPOOL statement for buffer pool
"DATABP"
(ID "6") was successful but could not be performed immediately
because of insufficient memory. The change will take effect on
the
next database startup. Refer to the documentation for SQLCODE
20189.
Actually our system still show over 8,000 MB memory FREE. Later I found
out this was due to a known bug with AIX - DB2UDB 8.1 fixpak7 where the
instance needs to be restarted for the new BP to take effect.
My problem is that all 8 GB free memory has completely vanished after the
restart.
Is it safe for me to scale back my change or should I pick up the phone
and call IBM support before someone breathes behind my back?
Thank you very much for your help.
db2mtrk -i -d shows
Tracking Memory on: 2007/02/26 at 10:17:31
Memory for instance
monh other
144.0K 2.1M
Memory for database:
utilh pckcacheh catcacheh bph bph bph bph
32.0K 45.4M 2.6M 15.8M 387.3M 4.0M 15.8M
bph bph bph bph bph bph bph
15.8M 15.8M 193.6M 624.0K 368.0K 240.0K 176.0K
lockh dbh other
10.5M 5.6M 0
Cheers
Ray
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
To: "LazyDBA Discussion" <[Email address protected]
cc:
From: "RLam" <db2udbdba-ezmlmshield-x40593343.[Email address protected]
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves
the right to retrieve and read any message created, sent and received.
Kohl's reserves the right to monitor messages to or from authorized Kohl's
Associates at any time
without any further consent.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
To: "LazyDBA Discussion" <[Email address protected]
cc:
From: "Suresh" <db2udbdba-ezmlmshield-x21964309.[Email address protected]
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page