DB2 active log repro questions

JH

DB2 active log repro questions
I created and pre-formatted two new active logs

D2T1.LOGCOPY1.DS04 and D2T1.LOGCOPY2.DS04


I then shutdown DB2 normally. the current
active logs were

D2T1.LOGCOPY1.DS01 and D2T1.LOGCOPY2.DS01

I then reproed DS01 to DS04 and found something
interesting.

Here are the REPRO output:
==================
REPRO INFILE(INPUT1) OUTFILE (OUTPUT1) REUSE

IDC0005I NUMBER OF RECORDS PROCESSED WAS 5940


REPRO INFILE(INPUT1) OUTFILE (OUTPUT1) REUSE

IDC0005I NUMBER OF RECORDS PROCESSED WAS 3964
====================

How come LOGCOPY1 and LOGCOPY2 have different number
of records, I thought they are identical.

Thanks for your help.



____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Avram Friedman

Re: DB2 active log repro questions
(in response to JH)
Joe
Did you do any of the following before the repro (or it may still be meaning full
to do now)
-DIS LOG
Log at the archive messages in MSTR
Print a log inventory

I expect one of two common issues
A) Your logs are not dataset synced That is when you are logging to
LOGCOPY1.DS01 the other log may be LOGCOPY2.DS02. This is very common
if you have experienced archive failures

B) 1.DS01 and 2.DS01 are not the same size. This would be noted by one of
the logs having the flag TRUNC in a -DIS LOG or log inventory. Many things
can cause this but if the condition does exist the larger log may be
preformated with additional blocks.

Regards
Avram Friedman


On Fri, 18 Jan 2008 08:20:30 -0800, Joe <[login to unmask email]> wrote:

>I created and pre-formatted two new active logs
>
>D2T1.LOGCOPY1.DS04 and D2T1.LOGCOPY2.DS04
>
>
>I then shutdown DB2 normally. the current
>active logs were
>
>D2T1.LOGCOPY1.DS01 and D2T1.LOGCOPY2.DS01
>
>I then reproed DS01 to DS04 and found something
>interesting.
>
>Here are the REPRO output:
>==================
> REPRO INFILE(INPUT1) OUTFILE (OUTPUT1) REUSE
>
>IDC0005I NUMBER OF RECORDS PROCESSED WAS 5940
>
>
> REPRO INFILE(INPUT1) OUTFILE (OUTPUT1) REUSE
>
>IDC0005I NUMBER OF RECORDS PROCESSED WAS 3964
>====================
>
>How come LOGCOPY1 and LOGCOPY2 have different number
>of records, I thought they are identical.
>
>Thanks for your help.
>
>
>
>
__________________________________________________________________
__________________
>Never miss a thing. Make Yahoo your home page.
>http://www.yahoo.com/r/hs
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
under the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raey

Re: DB2 active log repro questions
(in response to Avram Friedman)
I agree with Avram that the copy 1 and copy 2 logs may not have been synced. You can easily check if they are synced or not by checking the timestamp and the RBA points.

Best Regards,
Ayalew

Avram Friedman <[login to unmask email]> wrote:
Joe
Did you do any of the following before the repro (or it may still be meaning full
to do now)
-DIS LOG
Log at the archive messages in MSTR
Print a log inventory

I expect one of two common issues
A) Your logs are not dataset synced That is when you are logging to
LOGCOPY1.DS01 the other log may be LOGCOPY2.DS02. This is very common
if you have experienced archive failures

B) 1.DS01 and 2.DS01 are not the same size. This would be noted by one of
the logs having the flag TRUNC in a -DIS LOG or log inventory. Many things
can cause this but if the condition does exist the larger log may be
preformated with additional blocks.

Regards
Avram Friedman


On Fri, 18 Jan 2008 08:20:30 -0800, Joe wrote:

>I created and pre-formatted two new active logs
>
>D2T1.LOGCOPY1.DS04 and D2T1.LOGCOPY2.DS04
>
>
>I then shutdown DB2 normally. the current
>active logs were
>
>D2T1.LOGCOPY1.DS01 and D2T1.LOGCOPY2.DS01
>
>I then reproed DS01 to DS04 and found something
>interesting.
>
>Here are the REPRO output:
>==================
> REPRO INFILE(INPUT1) OUTFILE (OUTPUT1) REUSE
>
>IDC0005I NUMBER OF RECORDS PROCESSED WAS 5940
>
>
> REPRO INFILE(INPUT1) OUTFILE (OUTPUT1) REUSE
>
>IDC0005I NUMBER OF RECORDS PROCESSED WAS 3964
>====================
>
>How come LOGCOPY1 and LOGCOPY2 have different number
>of records, I thought they are identical.
>
>Thanks for your help.
>
>
>
>
__________________________________________________________________
__________________
>Never miss a thing. Make Yahoo your home page.
>http://www.yahoo.com/r/hs
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
under the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms



---------------------------------
Never miss a thing. Make Yahoo your homepage.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms