At one time, we had taken the sample C++ code that is provided under
samples (I believe it's called db2uext2.cdisk). There were only a few
things to change and then we compiled it. It worked, but we had
intermittent problems where some log files were not copied. The log files
would be left sitting on the active log directory. Since we really didn't
know C++ that much and we couldn't figure out a way to debug it, we
abandoned it.
So we wrote a couple of REXX scripts that manage the log files. Everyday,
we kick off a script that will copy the log files over to an archive
directory based on the "first active log file" that you get when you do a
"get db cfg for database ...". It's not quite as good as a user exit
getting called every time a new log is created, but it serves our purpose
of getting rid of old log files and making copies that could be used in the
event of a disaster.
John Lantz
Zurich North America
"McLeod, Scott" <[EMAIL PROTECTED]>@lists1.ba.best.com on 04/09/2001
02:20:15 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: DB2EUG: USEREXIT Sample
Does anyone have an NT based USEREXIT script to copy an archivelog file to
a
new location they would be willing to share with me. I know its not a very
complicated script and I've written them in the past for AIX but if someone
already has one and can keep from reinventing the wheel the would be great.
> TTFN and Hold Fast!
> Scott McLeod of MacLeod
> Best Buy, Inc.
> Sr. Database Architect
> 7750 Flying Cloud Dr.
> Eden Prairie, MN 55344
>
> (612) 324-0031 (voice)
> (612) 324-0828 (fax)
>
> [EMAIL PROTECTED]
>
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
