Veritas-bu

[Veritas-bu] DB2 Archive Logs

2003-12-11 04:34:44
Subject: [Veritas-bu] DB2 Archive Logs
From: yetan AT gcis.com DOT my (YE Tan)
Date: Thu, 11 Dec 2003 17:34:44 +0800
This is a multi-part message in MIME format.

------=_NextPart_000_0001_01C3C00D.126E9250
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

        I have installed Veritas NetBackup 4.5 to backup DB2 archive
logs.
        User exit program is turned on, Veritas is configured to send
the log files to tape (db2.conf, ARCFUNC SAVE) whenever "db2 terminate"
is executed.

        I've executed the following steps:

        i) Execute "db2 backup database."
        ii) Insert some data using "db2 insert into." then "db2
terminate". Executed 3 times => 3 logs.
        iii) Veritas backup those 3 logs to tapes.
        iv) Execute "db2 restore database."
        v) Execute "db2 rollforward database."
        
        
I notice that the logs are sent to tapes and they still exists in the
logs directory. When rollforward is performed, Veritas will only take
those logs that are not present in the log directory from tapes while
retrieving the rests from disks (e.g. log 1 from tape, log 2 and 3 from
disk).

My questions are:

        a) Aren't the logs supposed to be deleted from the log directory
once they are sent to tapes?
        b) Is it due to the fact that the logs are not yet full and thus
they are not deleted from disk?
        

Thanks and regards,

YE Tan


------=_NextPart_000_0001_01C3C00D.126E9250
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.4630.0">
<TITLE>DB2 Archive Logs</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi,</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">I have installed Veritas NetBackup 4.5 to backup DB2 =
archive logs.</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">User exit program is turned on, Veritas is configured to =
send the log files to tape (db2.conf, ARCFUNC SAVE) whenever &quot;db2 =
terminate&quot; is executed.</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">I've executed the following steps:</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">i) Execute &quot;db2 backup database&#8230;&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">ii) Insert some data using &quot;db2 insert =
into&#8230;&quot; then &quot;db2 terminate&quot;. Executed 3 times =
=3D&gt; 3 logs.</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">iii) Veritas backup those 3 logs to tapes.</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">iv) Execute &quot;db2 restore =
database&#8230;&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">v) Execute &quot;db2 rollforward =
database&#8230;&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20

<BR><FONT SIZE=3D2 FACE=3D"Arial">I notice that the logs are sent to =
tapes and they still exists in the logs directory. When rollforward is =
performed, Veritas will only take those logs that are not present in the =
log directory from tapes while retrieving the rests from disks (e.g. log =
1 from tape, log 2 and 3 from disk).</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">My questions are:</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">a) Aren't the logs supposed to be deleted from the log =
directory once they are sent to tapes?</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">b) Is it due to the fact that the logs are not yet full =
and thus they are not deleted from disk?</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks and regards,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">YE Tan</FONT>
</P>

</BODY>
</HTML>
------=_NextPart_000_0001_01C3C00D.126E9250--


<Prev in Thread] Current Thread [Next in Thread>