ADSM-L

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

2006-05-02 08:12:49
Subject: Re: HELP! Recovery log is almost 100% full!!!
From: "Smith, I (Ian)" <Ian.Smith AT RABOBANK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 2 May 2006 13:12:30 +0100
 
Process 3097, is this some sort of migration?

Is there a backup and migration occurring at the same time?

_____________________________
Ian Smith
SAN/TSM Specialist



-----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:40
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] HELP! Recovery log is almost 100% full!!!

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.
_____________________________________________________________