Hi,

Can someone suggest the most convenient way to backup db2 logs? I have
AIX4.3.3 and Tivoli as storage manager? At present i am using dsmc
incr (tivoli command) for backuping of db2 logs.

Please advice.
Jignesh Shah

Jignesh Shah,

look for the userexit in the /sqllib/samples/c directory for
db2uext2.ctsm for direct archiving to tsm.

Regards,
Joachim Müller

"Jignesh Shah" <jshah@joy.com> schrieb im Newsbeitrag
news:2360c2cd.0402100205.5f094a1c@posting.google.c om...
> Hi,
>
> Can someone suggest the most convenient way to backup db2 logs? I have
> AIX4.3.3 and Tivoli as storage manager? At present i am using dsmc
> incr (tivoli command) for backuping of db2 logs.
>
> Please advice.
> Jignesh Shah

Joachim Mueller wrote:

> Jignesh Shah,
>
> look for the userexit in the /sqllib/samples/c directory for
> db2uext2.ctsm for direct archiving to tsm.
>
> Regards,
> Joachim Müller
>
> "Jignesh Shah" <jshah@joy.com> schrieb im Newsbeitrag
> news:2360c2cd.0402100205.5f094a1c@posting.google.c om...
>> Hi,
>>
>> Can someone suggest the most convenient way to backup db2 logs? I have
>> AIX4.3.3 and Tivoli as storage manager? At present i am using dsmc
>> incr (tivoli command) for backuping of db2 logs.
>>
>> Please advice.
>> Jignesh Shah

Joachim,

Would you reckon that this sample user exit is "production quality" ?

I'm always scared to death of using user exits : if you return a RC=0 and
the log archive has failed for some reason then you stand to lose a log
(and hence be unrecoverable to current point in time).

And ever since I tried to compile a sample user exit on a previous release
and it gave compile failures I've been wary of using the sample code.

I'm hoping that soon IBM will ship an alternative to the USEREXIT : some new
registry variables or DB CFG parameters to point to an archive directory
(same as they now have OVERFLOWLOGPATH and MIRRORLOGPATH) and another one
to specifiy : DIRECTORY, TSM, LIBRARY (for other archive products, or to
plug in your own user exit for those who still want to do this).

I put forward this proposal to IBM in October at IDUG Europe and they said
that they were "working on it" : so I live in hope !!!

Phil

Philip,

we use the userexit since 6-7 years without problems.
First we ship the log with the userexit to another directory, so after that
TSM would get the log.
Since 1 year we use the userexit with direct archiving and ... it works as
designed.

You are right, that it would be better to work without userexit and db2
brings the log whereever.

I very hopeful to see this in one oft the next version, perhaps 9?.

Regards,
Joachim Müller

"Philip Nelson" <gulfvuk@yahoo.co.uk> schrieb im Newsbeitrag
news:TS4Wb.8055699$Of.1303327@news.easynews.com...
> Joachim Mueller wrote:
>
> > Jignesh Shah,
> >
> > look for the userexit in the /sqllib/samples/c directory for
> > db2uext2.ctsm for direct archiving to tsm.
> >
> > Regards,
> > Joachim Müller
> >
> > "Jignesh Shah" <jshah@joy.com> schrieb im Newsbeitrag
> > news:2360c2cd.0402100205.5f094a1c@posting.google.c om...
> >> Hi,
> >>
> >> Can someone suggest the most convenient way to backup db2 logs? I have
> >> AIX4.3.3 and Tivoli as storage manager? At present i am using dsmc
> >> incr (tivoli command) for backuping of db2 logs.
> >>
> >> Please advice.
> >> Jignesh Shah
>
> Joachim,
>
> Would you reckon that this sample user exit is "production quality" ?
>
> I'm always scared to death of using user exits : if you return a RC=0 and
> the log archive has failed for some reason then you stand to lose a log
> (and hence be unrecoverable to current point in time).
>
> And ever since I tried to compile a sample user exit on a previous release
> and it gave compile failures I've been wary of using the sample code.
>
> I'm hoping that soon IBM will ship an alternative to the USEREXIT : some
new
> registry variables or DB CFG parameters to point to an archive directory
> (same as they now have OVERFLOWLOGPATH and MIRRORLOGPATH) and another one
> to specifiy : DIRECTORY, TSM, LIBRARY (for other archive products, or to
> plug in your own user exit for those who still want to do this).
>
> I put forward this proposal to IBM in October at IDUG Europe and they said
> that they were "working on it" : so I live in hope !!!
>
> Phil

Joachim Mueller wrote:

> I very hopeful to see this in one oft the next version, perhaps 9?.
>

I'm hoping V8.2, but then we Scots are eternal optimists <G>.

Thanks for the info on your use of user exit. At our site we have written
user exits in Perl, but have not yet implemented them. Maybe we should
take a closer look at the sample code !!!

Phil

Hello folks,

Actually i was looking for some Utility sort of stuff which would
directly backs up the log once it is archived to log_archive
directory. At present i am using db2uext2 which archives from log_dir
to log_archive but which is the safest and appropriate way to back up
from log_archive to tivoli??. Any advice would be helpful as i am wary
of dsmc incr command.

Regards
Jignesh Shah

Including some logs with an online backup image is being considered for
the DB2 Stinger release.

Philip Nelson wrote:

> Joachim Mueller wrote:
>
>
>>Jignesh Shah,
>>
>>look for the userexit in the /sqllib/samples/c directory for
>>db2uext2.ctsm for direct archiving to tsm.
>>
>>Regards,
>>Joachim Müller
>>
>>"Jignesh Shah" <jshah@joy.com> schrieb im Newsbeitrag
>>news:2360c2cd.0402100205.5f094a1c@posting.google .com...
>>
>>>Hi,
>>>
>>>Can someone suggest the most convenient way to backup db2 logs? I have
>>>AIX4.3.3 and Tivoli as storage manager? At present i am using dsmc
>>>incr (tivoli command) for backuping of db2 logs.
>>>
>>>Please advice.
>>>Jignesh Shah
>
>
> Joachim,
>
> Would you reckon that this sample user exit is "production quality" ?
>
> I'm always scared to death of using user exits : if you return a RC=0 and
> the log archive has failed for some reason then you stand to lose a log
> (and hence be unrecoverable to current point in time).
>
> And ever since I tried to compile a sample user exit on a previous release
> and it gave compile failures I've been wary of using the sample code.
>
> I'm hoping that soon IBM will ship an alternative to the USEREXIT : some new
> registry variables or DB CFG parameters to point to an archive directory
> (same as they now have OVERFLOWLOGPATH and MIRRORLOGPATH) and another one
> to specifiy : DIRECTORY, TSM, LIBRARY (for other archive products, or to
> plug in your own user exit for those who still want to do this).
>
> I put forward this proposal to IBM in October at IDUG Europe and they said
> that they were "working on it" : so I live in hope !!!
>
> Phil

Jignesh Shah wrote:

> Hello folks,
>
> Actually i was looking for some Utility sort of stuff which would
> directly backs up the log once it is archived to log_archive
> directory. At present i am using db2uext2 which archives from log_dir
> to log_archive but which is the safest and appropriate way to back up
> from log_archive to tivoli??. Any advice would be helpful as i am wary
> of dsmc incr command.
>
> Regards
> Jignesh Shah

Jignesh,

You are probably a lot better off going directly to TSM. Reason
being, during a recovery (rollforward), DB2 will automatically
retrieve the required files from TSM.

If you backup to a directory and then archive to tape with TSM,
then you'd need to first (manually) restore files from TSM, and
then issue your rollforward. Plus, you probably don't know which
files to restore... So you may spend a lot of time restoring log
files that may not be necessary.



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----