Hi
Can anyone explain me commands like db2mtrk and db2pd
How do we interpret the output of db2mtrk command ?
do we have any more commands like this.
Thanks
Ravi.
-----Original Message-----
From: Suresh
[mailto:db2udbdba-ezmlmshield-x21964309.[Email address protected]
Sent: 26 February 2007 19:02
To: LazyDBA Discussion
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
Emails aren't always secure, and they may be intercepted or changed after they've been sent. Abbey doesn't accept liability if this happens. If you think someone may have interfered with this email, please get in touch with the sender another way.
This message doesn't create or change any contract. Abbey doesn't accept responsibility for damage caused by any viruses contained in this email or its attachments. Emails may be monitored.
If you've received this email by mistake, please let the sender know at once that it's gone to the wrong person and then destroy it without copying, using, or telling anyone about its contents.
Abbey National plc Reg. No 2294747, and Inscape Investments Limited Reg. No. 3839455 are registered in England and have their Registered Offices at Abbey National House, 2 Triton Square, Regent's Place, London, NW1 3AN.
Abbey National plc and Inscape Investments Limited are authorised and regulated by the Financial Services Authority. Abbey National plc advises on Phoenix Life Assurance Limited's life assurance and pension products, advises on its own mortgage and collective investment scheme products, and acts as an insurance intermediary for general insurance. Inscape Investments Limited is authorised and regulated for the provision of investment management services and only advises on a selected range of collective investment schemes from Abbey Group and Phoenix Life Assurance Limited's life assurance and pension products. Inscape, Abbey and the flame logo are registered trademarks.
DB2 & UDB email list listserv db2-l LazyDBA home page