Hey, I thought it meant Read The Flying Manual, because that's what manuals do around here after I try something new without reading them!!!!

Is it Friday yet? Anywhere in the world?

Nick

-------------- Original message --------------
From: "Edwards Ed " <db2udbdba-ezmlmshield-x73047497.[Email address protected]

> Hey RLAM,
> Read the Fine Manual? Hehe.
>
> Have a great Day!
>
>
>
>
>
>
>
> Please take a few minutes to provide feedback on the quality of service you
> received. The Department of Education values your feedback as a customer.
> Commissioner John L. Winn is committed to continuously assessing and improving
> the level and quality of services provided to you by Department staff. Simply
> use the link below. Thank you in advance for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
> From: RLam
> [mailto:db2udbdba-ezmlmshield-x48510335.[Email address protected]
> Sent: Tuesday, February 27, 2007 2:01 PM
> To: LazyDBA Discussion
> Subject: RE: DB2 BUFFERPOOL
>
> hi Ravi
>
> Initially I got very confused when different options of db2mtrk gave me
> totally different numbers - i thought DB2 and me had gone nuts.
>
> I'd suggest starting with "db2mtrk -d -i -v" and "db2mtrk -d -i" to get
> familiar with both the verbose or brief output.
>
> Adding -p and -v (along with grep and EXCEL) will allow the bytes from
> the
> "Total" line to be summed up easily.
>
> You had no idea how I felt when I found 7 GB memory missing after
> bouncing
> the production server and looking at the db2mtrk output first time with
> the (-m) option.
>
> Guess that's the price I paid for not RTFM (read the fine manual :)
>
> My story has a happy ending since the memory mysteriously returned after
>
> reboot.
>
> Other lessons I learned:
>
> - it's probably a good habit to check how much memory free before
> starting
> db2
> - ipquery and ipclean (after shutdown) are very useful before the next
> db2start but may not always free up "lost" memory
> - keep db2 up to date
>
> Cheers
> Ray
>
> PS - Suresh and Pierre (thanks for the info - it really helps)
>
>
>
>
> "Balley Ravi Shanker "
> > 02/27/2007 02:43 AM
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> RE: DB2 BUFFERPOOL
>
>
>
>
>
>
>
> 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" > 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" > 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" > 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.
>
>
> ---------------------------------------------------------------------
> 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 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 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
>

DB2 & UDB email list listserv db2-l LazyDBA home page