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.mo...@highmark.comwrote:
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
zfor...@vcu.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