DB2 UDB 6.1 on AIX 4.3.3 Archive Logs

Robert Ord

DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
To anyone who understands UDB on AIX,

How do you list the archive log history that UDB holds ? I assume it must be
stored in SQLOGCTL.LFH, but which of the many undocumented commands unlocks
the information ?

Regards

Rob






_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Bob Lewis

Re: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
(in response to Robert Ord)
In the sample USEREXIT for archive logging you can specify where the archive
'log' is placed. I believe the name for the file is cleverly defaulted to
ARCHIVE.LOG. You can also specify a location for an error log.

-----Original Message-----
From: Robert Ord [mailto:[login to unmask email]
Sent: Thursday, December 21, 2000 12:14 PM
To: [login to unmask email]
Subject: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs


To anyone who understands UDB on AIX,

How do you list the archive log history that UDB holds ? I assume it must be
stored in SQLOGCTL.LFH, but which of the many undocumented commands unlocks
the information ?

Regards

Rob






_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.








[login to unmask email]

Re: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
(in response to Bob Lewis)
Rob,

If you are archiving the logs through the db2uext2 user exit to ADSM, then
you can use the "db2adutl query" command to see which logs are archived in
ADSM. Also, the exit will write a record of each log that it archives in
the ARCHIVE.LOG file, which is located in the directory that is coded in
the exit.

Hope this helps.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT 06083




Robert Ord
<[login to unmask email] To: [login to unmask email]
TMAIL.COM> cc:
Sent by: DB2 Subject: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
Data Base
Discussion
List
<[login to unmask email]
OM>


12/21/00
01:14 PM
Please
respond to
DB2 Data Base
Discussion
List






To anyone who understands UDB on AIX,

How do you list the archive log history that UDB holds ? I assume it must
be
stored in SQLOGCTL.LFH, but which of the many undocumented commands unlocks
the information ?

Regards

Rob






_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.








Gert van der Kooij

Re: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
(in response to BILL_GALLAGHER@PHL.COM)
The 'list history' command will help you. It's described in the Command
Reference.

----- Original Message -----
From: "Robert Ord" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Thursday, December 21, 2000 7:14 PM
Subject: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs


> To anyone who understands UDB on AIX,
>
> How do you list the archive log history that UDB holds ? I assume it must
be
> stored in SQLOGCTL.LFH, but which of the many undocumented commands
unlocks
> the information ?
>
> Regards
>
> Rob
>
>
>
>
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>


>



Robert Ord

Re: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
(in response to Gert van der Kooij)
Unfortunately we are archiving using Legato and their version of the
userexit. They don't provide an equivalent of "db2adutl query".

Regards

Rob




>From: [login to unmask email]
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: DB2 UDB 6.1 on AIX 4.3.3 Archive Logs
>Date: Thu, 21 Dec 2000 13:32:18 -0500
>
>Rob,
>
>If you are archiving the logs through the db2uext2 user exit to ADSM, then
>you can use the "db2adutl query" command to see which logs are archived in
>ADSM. Also, the exit will write a record of each log that it archives in
>the ARCHIVE.LOG file, which is located in the directory that is coded in
>the exit.
>
>Hope this helps.
>
>Bill Gallagher, DBA
>Phoenix Home Life
>Enfield, CT 06083
>
>
>
>
> Robert Ord
> <[login to unmask email] To: [login to unmask email]
> TMAIL.COM> cc:
> Sent by: DB2 Subject: DB2 UDB 6.1 on AIX
>4.3.3 Archive Logs
> Data Base
> Discussion
> List
> <[login to unmask email]
> OM>
>
>
> 12/21/00
> 01:14 PM
> Please
> respond to
> DB2 Data Base
> Discussion
> List
>
>
>
>
>
>
>To anyone who understands UDB on AIX,
>
>How do you list the archive log history that UDB holds ? I assume it must
>be
>stored in SQLOGCTL.LFH, but which of the many undocumented commands unlocks
>the information ?
>
>Regards
>
>Rob
>
>
>
>
>
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>
>
>
>
>
>
>
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.