Thanks Leigh !
The 2 TSM Servers does not communicate together at all: there are
independant.
>From the "show logpin", I have this answer
"
Dirty page Lsn=27091.153.2916, Last DB backup Lsn=27092.23.2722,
Transaction table Lsn=0.0.0, Running DB backup Lsn=0.0.0, Log
truncation Lsn=27091.153.2916
Lsn=27091.153.2916, Owner=DB, Length=56
Type=Update, Flags=82, Action=SetIcb, Page=8192, Tsn=0:459265,
PrevLsn=0.0.0, UndoNextLsn=0.0.0, UpdtLsn=0.0.0 ===> Bit Offset =
546
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=11928, NumClean=24626, MinClean=24595, NumTempClean=24691,
MinTempClean=12297,
BufPoolSize=24691, BufDescCount=24692, BufDescMaxFree=27160,
DpTableSize=24576, DpCount=65, DpDirty=65, DpCkptId=11928, DpCursor=2,
NumEmergency=0 CumEmergency=0, MaxEmergency=0.
BuffersXlatched=0, xLatchesStopped=False, FullFlushWaiting=False.
"
It does not indicate any session number or so..
I didn't have any session running on the server, neither DB or LOG
process.
I will have a look at articles "IBM Technotes: 1084167; 1105651; 1105830".
Of course, I will try ton understand how to prevent from reappearing, but
I should cure these 2 ones =)
Regards
Vincent
Leigh Reed <L.Reed AT MDX.AC DOT UK>
Envoyé par : "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
14/11/05 11:56
Veuillez répondre à "ADSM: Dist Stor Manager"
Pour : ADSM-L AT VM.MARIST DOT EDU
cc : (ccc : Vincent RATAJSZCZAK/INFOGER/GRT/FR)
Objet : Re: [ADSM-L] Recovery Log Pinned
Vince,
I forgot something else, if it is 2 of your servers illustrating the
same behaviour, the offending operation could be a server to server
function that you may be running.
Leigh
-A TSM cowboy with too much time on my hands-
-Although if I want to keep getting work, I shouldn't refer to myself as
a cowboy-
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Vincent RATAJSZCZAK
Sent: 14 November 2005 10:27
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Recovery Log Pinned
Hi TSM Cow Boys/Girls
I would like to abuse of your busy time.
I discover that 2 of my several servers have a recovery Log pinned.
I use the TSM/ADSM QuickFacts which point me to "IBM site article
swg21054574"
I'm unable to find this article on the net, neither the IBM site.
Someone would be kind enough to send me this article or shortly explain
me
how to resolve a log pinned, please ?
Regards
Vince
|