ADSM-L

Re: Full DB log file causing TCP/IP Connection Failure

2001-04-19 15:34:49
Subject: Re: Full DB log file causing TCP/IP Connection Failure
From: "Caffey, Jeff L." <jlcaffey AT PIER1 DOT COM>
Date: Thu, 19 Apr 2001 14:35:11 -0500
In regards to Neil Poland's response, I've had to do the same thing
recently.  The only difference is that I did a FULL backup of the database.
Also, after I reduced the log back to it's original size, I left the new log
volume (in Neil's example - "temprec.log01") out there in case I ever needed
it again.

It's a pain in the backside, but it will work.

Good luck,

Jeff Caffey
Enterprise Systems Programmer
(AIX & Storage Administrator)
Pier 1 imports, Inc.  -  Information Services
jlcaffey AT pier1 DOT com
Voice: (817) 252-6222
Fax:   (817) 252-7299

 -----Original Message-----
From:   Poland, Neil [mailto:NPoland AT TTIINC DOT COM]
Sent:   Thursday, April 19, 2001 1:48 PM
To:     ADSM-L AT VM.MARIST DOT EDU
Subject:        Re: Full DB log file causing TCP/IP Connection Failure

Try this, it's from my AIX notes but should work..

DSMFMT an additional recovery log volume:

dsmfmt -m -log temprec1.log01 101

Use the DSMSERV EXTEND LOG command to do a recovery log extension:

dsmserv extend log temprec.log01 100

Start the TSM server. When it comes up login and disable sessions, cancel
all current sessions, and cancel all processes that may be running. Start an
incremental backup.

Once your backup is complete and the log percent utilized drops, if in
rollfoward set the log mode to normal:

set logmode normal

Then reduce the log size and delete the new log volume:

reduce log 100
delete logvol temprec.log01

Set logmode back to roll forward:
set logmode rollfoward