OK Tim, I think I see the problem. The recovery log doesn't go into
roll-forward mode until the next full database backup, which is necessary
in order to have a baseline from which the log can be used to recover a
database.
When you defined the dbbackuptrigger, it automatically did the full backup
for you... that's why you see the roll forward mode working.
If you had run a full db backup after you set the mode to rollforward, the
recovery log would have started to operate in roll-forward mode.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"Rushforth, Tim" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/06/2003 13:16
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: Logmode RollForward on 5.1.6.2
OK this is bizarre!
I tried this yesterday around 16:00.
The last db backup was yesterday at 13:30 (according to volhist and
searching actlog). This morning I could recreate this and showed a
co-worker. After reading your post, I tried again and the same thing
happened.
I then defined a DB Backuptrigger (a DB backup was triggered) and I tried
this again.
Now the log continues filling - log pages continue to go up.
I tried recreating this by deleting the DB backuptrigger with no luck! So
I
know this is hard to believe but I know what I saw (and it wasn't just
me!)
Anyways, we are going to try a test migration with a copy of our Prod DB
next.
Thanks,
Tim
-----Original Message-----
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]
Sent: March 6, 2003 11:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Logmode RollForward on 5.1.6.2
Tim, I'm playing with this myself, and I don't see the problem you
describe.
Is it possible that a db backup is being run between the time you see the
usage climb and when it goes back down?
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"Rushforth, Tim" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/06/2003 09:51
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Logmode RollForward on 5.1.6.2
Is anyone running in logmode rollforward on 5.1.6.2? I'm currently
testing
5.1.6.2 on W2K and this doesn't seem to be working.
Issue set logmode rollforward to set to rollforward mode (q status
confirms
that this is set).
Issue q log to see log utilization
Start a client archive that archives thousands of files.
Issue q log periodically.
The used pages go up then resets as if running in normal mode.
Thanks,
Tim Rushforth
City of Winnipeg
