By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

db2uext2.exe not work with db2 database

P: n/a
geo
hi,

we have a problem with the db2uext2.exe under W2000 SP4 and DB2 V8 FP
4a.
We copy the sample db2uext.cdisk to db2uext.c, compiled it with
Microsoft Visual C++ Toolkit 2003 without errors.
After that we test the db2uext2.exe file like this:
D:\install\db2uext2> db2uext2.exe -RQARCHIVE -DBESN04P2 -NNNODE0000
-LPE:\DESN04P2\NODE0000\SQL00001\SQLOGDIR\ -LNS0000001.LOG
-> the result was copy 1 files. Okay.

So we think it is correct and copied the db2uext2.exe to sqllib\bin
directory
and set logretain on and userexit on in the database.
After that, we try to archive a log with following command:
db2 archive log for db ESN04P1
the command ends successfully but there are no files in the archive
directory and nothing in the ARCHIVE.LOG or USEREXIT.ERR.

Can anybody help us?

Regards
Geo
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
geo wrote:
hi,

we have a problem with the db2uext2.exe under W2000 SP4 and DB2 V8 FP
4a.
We copy the sample db2uext.cdisk to db2uext.c, compiled it with
Microsoft Visual C++ Toolkit 2003 without errors.
After that we test the db2uext2.exe file like this:
D:\install\db2uext2> db2uext2.exe -RQARCHIVE -DBESN04P2 -NNNODE0000
-LPE:\DESN04P2\NODE0000\SQL00001\SQLOGDIR\ -LNS0000001.LOG
-> the result was copy 1 files. Okay.

So we think it is correct and copied the db2uext2.exe to sqllib\bin
directory
and set logretain on and userexit on in the database.
After that, we try to archive a log with following command:
db2 archive log for db ESN04P1
the command ends successfully but there are no files in the archive
directory and nothing in the ARCHIVE.LOG or USEREXIT.ERR.

Can anybody help us?


Did you actually have some operations that caused logs to be written? If
nothing is logged, then you can't archive anything.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
geo wrote:
hi,

we have a problem with the db2uext2.exe under W2000 SP4 and DB2 V8 FP
4a.
We copy the sample db2uext.cdisk to db2uext.c, compiled it with
Microsoft Visual C++ Toolkit 2003 without errors.
After that we test the db2uext2.exe file like this:
D:\install\db2uext2> db2uext2.exe -RQARCHIVE -DBESN04P2 -NNNODE0000
-LPE:\DESN04P2\NODE0000\SQL00001\SQLOGDIR\ -LNS0000001.LOG
-> the result was copy 1 files. Okay.

So we think it is correct and copied the db2uext2.exe to sqllib\bin
directory
and set logretain on and userexit on in the database.
After that, we try to archive a log with following command:
db2 archive log for db ESN04P1
the command ends successfully but there are no files in the archive
directory and nothing in the ARCHIVE.LOG or USEREXIT.ERR.

Can anybody help us?


Did you actually have some operations that caused logs to be written? If
nothing is logged, then you can't archive anything.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #3

P: n/a
geo
Knut Stolze <st****@de.ibm.com> wrote in message news:<c7**********@fsuj29.rz.uni-jena.de>...
geo wrote:
hi,

we have a problem with the db2uext2.exe under W2000 SP4 and DB2 V8 FP
4a.
We copy the sample db2uext.cdisk to db2uext.c, compiled it with
Microsoft Visual C++ Toolkit 2003 without errors.
After that we test the db2uext2.exe file like this:
D:\install\db2uext2> db2uext2.exe -RQARCHIVE -DBESN04P2 -NNNODE0000
-LPE:\DESN04P2\NODE0000\SQL00001\SQLOGDIR\ -LNS0000001.LOG
-> the result was copy 1 files. Okay.

So we think it is correct and copied the db2uext2.exe to sqllib\bin
directory
and set logretain on and userexit on in the database.
After that, we try to archive a log with following command:
db2 archive log for db ESN04P1
the command ends successfully but there are no files in the archive
directory and nothing in the ARCHIVE.LOG or USEREXIT.ERR.

Can anybody help us?


Did you actually have some operations that caused logs to be written? If
nothing is logged, then you can't archive anything.

yes, i have import many tables and there are many logs in the logdir.
In the windows taskmanager,db2uext2.exe is running, but no logs were
copied and no userexit.err was written.
Nov 12 '05 #4

P: n/a
geo
Knut Stolze <st****@de.ibm.com> wrote in message news:<c7**********@fsuj29.rz.uni-jena.de>...
geo wrote:
hi,

we have a problem with the db2uext2.exe under W2000 SP4 and DB2 V8 FP
4a.
We copy the sample db2uext.cdisk to db2uext.c, compiled it with
Microsoft Visual C++ Toolkit 2003 without errors.
After that we test the db2uext2.exe file like this:
D:\install\db2uext2> db2uext2.exe -RQARCHIVE -DBESN04P2 -NNNODE0000
-LPE:\DESN04P2\NODE0000\SQL00001\SQLOGDIR\ -LNS0000001.LOG
-> the result was copy 1 files. Okay.

So we think it is correct and copied the db2uext2.exe to sqllib\bin
directory
and set logretain on and userexit on in the database.
After that, we try to archive a log with following command:
db2 archive log for db ESN04P1
the command ends successfully but there are no files in the archive
directory and nothing in the ARCHIVE.LOG or USEREXIT.ERR.

Can anybody help us?


Did you actually have some operations that caused logs to be written? If
nothing is logged, then you can't archive anything.

yes, i have import many tables and there are many logs in the logdir.
In the windows taskmanager,db2uext2.exe is running, but no logs were
copied and no userexit.err was written.
Nov 12 '05 #5

P: n/a
Hi,
I have the same problem, did you ever figure yours out? after you let db2
try and run it on its interval, did u search for archive.log? After mine
did not work I searched for it. I found it at the root of the drive I was
saving off to, but I had it configured two folders deep, not the root
level. When I opened it, for some reason the userexit program was trying
to save it to (in my case) J:DB2BackupOnLineArchiveLogs but I have it
defined as J:\DB2Backup\OnLineArchiveLogs\ and I even tried
J:\\DB2Backup\OnLineArchiveLogs\\
I also get some warnings during the compile, but no errors. Hope that
helps you.
Thats pretty wierd, uh?

Nov 12 '05 #6

P: n/a
Hi,
I have the same problem, did you ever figure yours out? after you let db2
try and run it on its interval, did u search for archive.log? After mine
did not work I searched for it. I found it at the root of the drive I was
saving off to, but I had it configured two folders deep, not the root
level. When I opened it, for some reason the userexit program was trying
to save it to (in my case) J:DB2BackupOnLineArchiveLogs but I have it
defined as J:\DB2Backup\OnLineArchiveLogs\ and I even tried
J:\\DB2Backup\OnLineArchiveLogs\\
I also get some warnings during the compile, but no errors. Hope that
helps you.
Thats pretty wierd, uh?

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.