htliner, LLC
(503) 745-6850 phone/vmail
-Original Message-
From: Warren, Matthew James [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Logmode rollforward and incr/full dbbackups
Hello TSM'ers
I am trying to run the followin
Hello TSM'ers
I am trying to run the following simple SQL query
select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where
access='READONLY'),(select count(*) from volumes where access='UNAVAILABLE')
from db,log
The above works fine, but if I add 'as' into it like so;
sel
In logmode=rollforward:
A full DB backup will backup the entire database, plus anything in the log.
An incr DB backup will only backup the log.
The logutil may not drop immediately after a DB backup, if there are
in-flight transactions that have not yet completed. The logutil will drop
further af
Just to clarify, I understand that the incremntal backup under rollforward
mode does not save the complete DB as a full backup does; What I don't
understand is why the incremental does not clear the log.
Matt.
-Original Message-
From: Warren, Matthew James
Sent: Tuesday, April 23, 2002 1
