Do you need to recompile user exit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RSL101@gmail.com - 25 Jan 2008 00:53 GMT

Dear Group,

we are migrating V8.2 instances to V9.5 and try to map everything
thats needed. Does anybody know
if userexit program needs to be recompile in V9.5 for it to be
effective ? We use the exit to archive logs
to backup server.

TYIA. Richard

Reply to this Message

Lennart - 25 Jan 2008 08:57 GMT

On Jan 25, 1:53 am, RSL...@gmail.com wrote:

> Dear Group,
>
[quoted text clipped - 5 lines]
>
> TYIA. Richard

(Assuming LUW) Richard, I dont have the answer to you question but in
case you did not know, as of V8 and beyond you no longer need userexit
to archive logs. Instead you can use LOGARCHMETH1 / LOGARCHMETH2 in db
cfg

/Lennart

Reply to this Message

Mark A - 25 Jan 2008 10:35 GMT

> (Assuming LUW) Richard, I dont have the answer to you question but in
> case you did not know, as of V8 and beyond you no longer need userexit
> to archive logs. Instead you can use LOGARCHMETH1 / LOGARCHMETH2 in db
> cfg
> /Lennart

I believe that this is first available in 8.2. I know it is not in 8.1 base
code.

Reply to this Message

Lennart - 25 Jan 2008 12:55 GMT

> > (Assuming LUW) Richard, I dont have the answer to you question but in
> > case you did not know, as of V8 and beyond you no longer need userexit
[quoted text clipped - 4 lines]
> I believe that this is first available in 8.2. I know it is not in 8.1 base
> code.

Possible, I migrated from V7 to V8.2 so I never really used 8.1.
Anyhow, the OP is already at 8.2

/Lennart

Reply to this Message

RSL101@gmail.com - 25 Jan 2008 17:19 GMT

> On Jan 25, 1:53 am, RSL...@gmail.com wrote:
>
[quoted text clipped - 14 lines]
>
> /Lennart

Thanks for info. But LOGARCHMETH1,2 still seems to ...

...This parameter causes the database manager to call a user exit
program for archiving 7 and retrieving logs....

according to IBM help center search on LOGARCHMETH1 config param. Can
you clarify ? Thank You.

Reply to this Message

Lennart - 25 Jan 2008 17:57 GMT

On Jan 25, 6:19 pm, RSL...@gmail.com wrote:

> > On Jan 25, 1:53 am, RSL...@gmail.com wrote:
>
[quoted text clipped - 22 lines]
> according to IBM help center search on LOGARCHMETH1 config param. Can
> you clarify ? Thank You.

Maybe I misunderstood you, my impression was that you have written
your own userexit function (I remember doing so myself back in V7). My
point was that in V8.2 and beyond, you don't have to write your own
userexit.

/Lennart

Reply to this Message

RSL101@gmail.com - 25 Jan 2008 23:27 GMT

> On Jan 25, 6:19 pm, RSL...@gmail.com wrote:
>
[quoted text clipped - 33 lines]
>
> - Show quoted text -

Yes I have cloned the sample C userexit program from sqllib and used
it to send archived logs to backup server. I would rather not have to
do it. How do I replace that function is what I am asking for.

Thank You in Advance. Richard.

Reply to this Message

Mark A - 26 Jan 2008 06:31 GMT

>Yes I have cloned the sample C userexit program from sqllib and used
>it to send archived logs to backup server. I would rather not have to
>do it. How do I replace that function is what I am asking for.

db2 update db2 cfg for sample using LOGARCHMETH1 DISK:/your/path/here

LOGARCHMETH2 is for archiving dual logs

Set the user exit parm to OFF.

Reply to this Message