Restoring Journals on an iSeries Box

[QSECOFR]

I restored my DB2 journals from a primary AS/400 to a backup AS/400 and want
to replay the journals for recovery purposes, I discovered that the chain
link was broken jumping from one receiver to the other, is there a quick and
easy way not to break the link? Also, does it have to do something with the
ASP that it is in? It is in ASP1 by default and was not restored in ASP1 on
the secondary box.

Any help will be appreciated.

Thanks,

QSECOFR

[RdR]

Hi QSECOFR,

Based on the information you gave, I believe you really do not have "broken
chains" even if you see journal receivers not in sequence. First of all,
when you restore journals from one machine to another, the journal receiver
names and its sequence numbers may be different from the original names in
the original machine. And it is also common that when a receiver name or
sequence number reaches its max (meaning no other number higher but to go
back to zero), then this is where the :broken chains" seem to appear. Just
to be on the safe side, do a wrkjrnrcv command or a wrkjrna command, and
look at each journal receiver, each receiver should have a beggining and
ending sequence number. I am quite sure that one of the receivers that
appears to have a "broken chain" or the one that you think has a broken
chain will point to an ending sequence number which may not follow the
original sequence or to another journal receiver with a number that appears
to break the chain. And to further confirm this, look in your QAUDJRN any
references to a CHGJRN command with a RESET on it and most probably point to
the receiver that seems to have broken the chain.

Seems like you are using a tool to replay the journals, if ever there is
really a broken link, see if this tool has a "Set Journal Position" utility
so that you can continue from where you left off if ever there is small
chance that you have Journal Corruption (WRKJRNA will show this too).

Hope this helps,

RdR

Post by QSECOFR
I restored my DB2 journals from a primary AS/400 to a backup AS/400 and want
to replay the journals for recovery purposes, I discovered that the chain
link was broken jumping from one receiver to the other, is there a quick and
easy way not to break the link? Also, does it have to do something with the
ASP that it is in? It is in ASP1 by default and was not restored in ASP1 on
the secondary box.
Any help will be appreciated.
Thanks,
QSECOFR

[QSECOFR]

Hi RdR,

Thanks for all the help, you were right, that just saved me hours and hours
of trying to fix a problem which is really not a problem. I appreciate it
very much. Thanks so much.

John

Post by RdR
Hi QSECOFR,
Based on the information you gave, I believe you really do not have "broken
chains" even if you see journal receivers not in sequence. First of all,
when you restore journals from one machine to another, the journal receiver
names and its sequence numbers may be different from the original names in
the original machine. And it is also common that when a receiver name or
sequence number reaches its max (meaning no other number higher but to go
back to zero), then this is where the :broken chains" seem to appear. Just
to be on the safe side, do a wrkjrnrcv command or a wrkjrna command, and
look at each journal receiver, each receiver should have a beggining and
ending sequence number. I am quite sure that one of the receivers that
appears to have a "broken chain" or the one that you think has a broken
chain will point to an ending sequence number which may not follow the
original sequence or to another journal receiver with a number that appears
to break the chain. And to further confirm this, look in your QAUDJRN any
references to a CHGJRN command with a RESET on it and most probably point to
the receiver that seems to have broken the chain.
Seems like you are using a tool to replay the journals, if ever there is
really a broken link, see if this tool has a "Set Journal Position" utility
so that you can continue from where you left off if ever there is small
chance that you have Journal Corruption (WRKJRNA will show this too).
Hope this helps,
RdR

Post by QSECOFR
I restored my DB2 journals from a primary AS/400 to a backup AS/400 and

want

Post by QSECOFR
to replay the journals for recovery purposes, I discovered that the chain
link was broken jumping from one receiver to the other, is there a quick

and

Post by QSECOFR
easy way not to break the link? Also, does it have to do something with

the

Post by QSECOFR
ASP that it is in? It is in ASP1 by default and was not restored in ASP1

on

Post by QSECOFR
the secondary box.
Any help will be appreciated.
Thanks,
QSECOFR

[RdR]

Hi QSECOFR,

About the ASP (Auxiliary Storage Pool), that does not matter if you are
OS/400 Version 4.x and above, I do not think restoring to a different ASP
will matter because the journal attributes should point to the correct ASP.
I do not think that has anything to do with the broken journal receiver
chains.

RdR

Post by QSECOFR
I restored my DB2 journals from a primary AS/400 to a backup AS/400 and want
to replay the journals for recovery purposes, I discovered that the chain
link was broken jumping from one receiver to the other, is there a quick and
easy way not to break the link? Also, does it have to do something with the
ASP that it is in? It is in ASP1 by default and was not restored in ASP1 on
the secondary box.
Any help will be appreciated.
Thanks,
QSECOFR

[QSECOFR]

Hi RdR,

Thanks for all the help, you were right, that just saved me hours and hours
of trying to fix a problem which is really not a problem. I appreciate it
very much. Thanks so much.

John

Post by RdR
Hi QSECOFR,
About the ASP (Auxiliary Storage Pool), that does not matter if you are
OS/400 Version 4.x and above, I do not think restoring to a different ASP
will matter because the journal attributes should point to the correct ASP.
I do not think that has anything to do with the broken journal receiver
chains.
RdR

Post by QSECOFR
I restored my DB2 journals from a primary AS/400 to a backup AS/400 and

want

Post by QSECOFR
to replay the journals for recovery purposes, I discovered that the chain
link was broken jumping from one receiver to the other, is there a quick

and

Post by QSECOFR
easy way not to break the link? Also, does it have to do something with

the

Post by QSECOFR
ASP that it is in? It is in ASP1 by default and was not restored in ASP1

on

Post by QSECOFR
the secondary box.
Any help will be appreciated.
Thanks,
QSECOFR