Good luck with this one.
We went through months of these messages. IBM L2/L3 basically said the
server was overloaded and the logs are "stair stepping" due to high activity
and the inability of the TSM server keeping up with the transaction flow.
While we tweaked the bufpool values and tried redistributing the
schedules/workload, the only answer for us was to reduce the workload by
moving nodes to other TSM servers.
It is a design issue with the V5 DB/Logs.
On Tue, Mar 22, 2011 at 7:58 AM, Moyer, Joni M <joni.moyer AT highmark DOT
com>wrote:
> Hi Everyone,
>
> I'm trying to figure out information concerning the dirty page and it says
> to check the buffer pool statistics. What command can I run to find the
> appropriate information?
>
> Any help is appreciated. Thanks!
>
> Dirty page Lsn=26108034.23.2782, Last DB backup Lsn=26115521.189.972,
> Transaction table Lsn=26115382.78.3144, Running DB backup Lsn=0.0.0, Log
> truncation Lsn=26108034.23.2782
>
> Lsn=26108034.23.2782, Owner=DB, Length=56
> Type=Update, Flags=C2, Action=AllocPage, Page=21964800, Tsn=0:2.907583537,
> PrevLsn=26108033.124.2499, UndoNextLsn=0.0.0, UpdtLsn=26108033.127.1472 ===>
> Bit Offset = 173
> The recovery log is pinned by a dirty page in the data base buffer pool.
> Check the buffer pool statistics. If the associated transaction is still
> active then more information will be displayed about that transaction.
>
> Database buffer pool global variables:
>
> CkptId=1850569, NumClean=124335, MinClean=262048, NumTempClean=262144,
> MinTempClean=131024,
> BufPoolSize=262144, BufDescCount=262250, BufDescMaxFree=288358,
> DpTableSize=262144, DpCount=137805, DpDirty=137803, DpCkptId=1836176,
> DpCursor=26904,
> NumEmergency=0 CumEmergency=0, MaxEmergency=0.
> BuffersXlatched=2, xLatchesStopped=False, FullFlushWaiting=False.
>
>
> ________________________________
> This e-mail and any attachments to it are confidential and are intended
> solely for use of the individual or entity to whom they are addressed. If
> you have received this e-mail in error, please notify the sender immediately
> and then delete it. If you are not the intended recipient, you must not
> keep, use, disclose, copy or distribute this e-mail without the author's
> prior permission. The views expressed in this e-mail message do not
> necessarily represent the views of Highmark Inc., its subsidiaries, or
> affiliates.
>
--
Zoltan Forray
TSM Software & Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details visit
http://infosecurity.vcu.edu/phishing.html
|
