Log Mirroring + User Exit AIX

[Mulder]

Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and
if so are you archiving these mirrored logs to TSM? Is this possible?
If so is there any sample code for the user exit and mirrored logging?

Thanks

[Dale McInnis]

Mulder
The user exit will archive the log file from the primary log path unless it
is damaged, in which case the user exit will archive from the secondary
path.
The DB2 engine tracks which path contains the "good" copy and will invoke
the user exit with the appropriate path.
The user exit that you used prior to V8 will continue to work with V8, there
are no user exit changes required.
The sample source code is located in the instance directory under
sqllib/sample/c

Hope this helps

Dale

"Mulder" <ty****@newsguy .com> wrote in message
news:6m******** *************** *********@4ax.c om...

Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and
if so are you archiving these mirrored logs to TSM? Is this possible?
If so is there any sample code for the user exit and mirrored logging?

Thanks

[Mulder]

On Tue, 27 Jan 2004 18:50:38 -0500, "Dale McInnis" <mc*****@aci.on .ca>
wrote:

Mulder
The user exit will archive the log file from the primary log path unless it
is damaged, in which case the user exit will archive from the secondary
path.
The DB2 engine tracks which path contains the "good" copy and will invoke
the user exit with the appropriate path.
The user exit that you used prior to V8 will continue to work with V8, there
are no user exit changes required.
The sample source code is located in the instance directory under
sqllib/sample/c

Hope this helps

Dale

"Mulder" <ty****@newsguy .com> wrote in message
news:6m******* *************** **********@4ax. com...

Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and
if so are you archiving these mirrored logs to TSM? Is this possible?
If so is there any sample code for the user exit and mirrored logging?

Thanks

I guess this would mean I'll need to recompile the user exit since I
have been using my user exit since v5. I would assume then that the
user exit code has been modified for v8 since the previous versions (
or the one I'm using now ) contain an embedded log path name for my
current log path.

Thanks

[Fan Ruo Xin]

"Mulder" <ty****@newsguy .com> wrote in message
news:no******** *************** *********@4ax.c om...

On Tue, 27 Jan 2004 18:50:38 -0500, "Dale McInnis" <mc*****@aci.on .ca>
wrote:

Mulder
The user exit will archive the log file from the primary log path unless itis damaged, in which case the user exit will archive from the secondary
path.
The DB2 engine tracks which path contains the "good" copy and will invoke
the user exit with the appropriate path.
The user exit that you used prior to V8 will continue to work with V8, thereare no user exit changes required.
The sample source code is located in the instance directory under
sqllib/sample/c

Hope this helps

Dale

"Mulder" <ty****@newsguy .com> wrote in message
news:6m******* *************** **********@4ax. com...

Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and
if so are you archiving these mirrored logs to TSM? Is this possible?
If so is there any sample code for the user exit and mirrored logging?

Thanks

I guess this would mean I'll need to recompile the user exit since I
have been using my user exit since v5. I would assume then that the
user exit code has been modified for v8 since the previous versions (
or the one I'm using now ) contain an embedded log path name for my
current log path.

Thanks

AFAIK, db2 udb V7.1 introduced the Log Mirroring. If you don't need to
recompile your user exit program after you upgrade the db server to V7.x,
then why you need to recompile when using V8?

[Blair Adamache]

v7 fixpak 3 (aka 7.2) was when we shipped log mirroring.

Fan Ruo Xin wrote:

"Mulder" <ty****@newsguy .com> wrote in message
news:no******** *************** *********@4ax.c om...

On Tue, 27 Jan 2004 18:50:38 -0500, "Dale McInnis" <mc*****@aci.on .ca>
wrote:

Mulder
The user exit will archive the log file from the primary log path unless
it
is damaged, in which case the user exit will archive from the secondary
path.
The DB2 engine tracks which path contains the "good" copy and will invoke
the user exit with the appropriate path.
The user exit that you used prior to V8 will continue to work with V8,
there
are no user exit changes required.
The sample source code is located in the instance directory under
sqllib/sample/c

Hope this helps

Dale

"Mulder" <ty****@newsguy .com> wrote in message
news:6m***** *************** ************@4a x.com...

Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and
if so are you archiving these mirrored logs to TSM? Is this possible?
If so is there any sample code for the user exit and mirrored logging?

Thanks

I guess this would mean I'll need to recompile the user exit since I
have been using my user exit since v5. I would assume then that the
user exit code has been modified for v8 since the previous versions (
or the one I'm using now ) contain an embedded log path name for my
current log path.

Thanks

AFAIK, db2 udb V7.1 introduced the Log Mirroring. If you don't need to
recompile your user exit program after you upgrade the db server to V7.x,
then why you need to recompile when using V8?