ADSM-L

Re: HELP! Recovery log is almost 100% full!!!

2006-05-02 07:40:55
Subject: Re: HELP! Recovery log is almost 100% full!!!
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 2 May 2006 07:40:03 -0400
Hi Ian,

Here is the results of show logpinned

Dirty page Lsn=5454721.208.1841, Last DB backup Lsn=5454721.230.3738,
Transaction table Lsn=5443792.104.3574, Running DB backup Lsn=0.0.0, Log
truncation Lsn=5443792.104.3574

Lsn=5443792.104.3574, Owner=DB, Length=199
Type=Update, Flags=C2, Action=ExtInsert, Page=8576166, Tsn=0:2724937766,
PrevLsn=0.0.0, UndoNextLsn=0.0.0, UpdtLsn=5443786.36.2397 ===>
ObjName=AS.Segments, Index=29, RootAddr=14, PartKeyLen=3, NonPartKeyLen=3,
DataLen=93
(195) Generating SM Context Report:
(195)  *** no sessions found ***
(135) Generating SM Context Report:
(135)  *** no sessions found ***
(35) Generating SM Context Report:
(35)  *** no sessions found ***
(176) Generating SM Context Report:
(176)  *** no sessions found ***
(176)   procNum=3097, status=Disk Storage Pool ORACLE, Moved Files: 135,
Moved Bytes: 3,401,248,768, Unreadable Files: 0, Unreadable Bytes: 0.
Current Physical File (bytes): 20,975,616 Current output volume: T02469. ,
cancelInProgress=False
(176)   descr=Migration, name=MIGRATION, cancelled=False
No session or process assoicated with this transaction can be located, or
one or more session and process found.

Has anyone ever seen this before?  Thanks again!

********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************



             "Smith, I (Ian)"
             <Ian.Smith@RABOBA
             NK.COM>                                                    To
             Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
             Dist Stor                                                  cc
             Manager"
             <[email protected]                                     Subject
             .EDU>                     Re: HELP!  Recovery log is almost
                                       100% full!!!

             05/02/2006 07:37
             AM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>







Show logpinned

This will display any potential sessions pinning the log.

Kick off an incremental database backup asap.

_____________________________
Ian Smith
SAN/TSM Specialist
IT Infrastructure
Rabobank International
Thames Court, One Queenhithe
London EC4V 3RL
t: +44 (0)20 7809 3046
f: +44 (0)20 7809 3599
m: +44 (0)7843 689914
Mailto: ian.smith AT rabobank DOT com


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: 02 May 2006 12:36
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] HELP! Recovery log is almost 100% full!!!

Hello Everyone,

I came in this morning and found that the recovery log is 99.1% full!  I
have a TSM 5.2.7.1 server on AIX 5.2.  What, if anything, can I check to
see that has the log so full?  Thanks in advance!

********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
_____________________________________________________________

This email (including any attachments to it) is confidential, legally
privileged, subject to copyright and is sent for the personal attention of
the intended recipient only. If you have received this email in error,
please advise us immediately and delete it. You are notified that
disclosing, copying, distributing or taking any action in reliance on the
contents of this information is strictly prohibited. Although we have taken
reasonable precautions to ensure no viruses are present in this email, we
cannot accept responsibility for any loss or damage arising from the
viruses in this email or attachments. We exclude any liability for the
content of this email, or for the consequences of any actions taken on the
basis of the information provided in this email or its attachments, unless
that information is subsequently confirmed in writing. If this email
contains an offer, that should be considered as an invitation to treat.
_____________________________________________________________