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

Problem when archiving log files

P: n/a
Hello,

After restoring my database I have some problems with diag.log who
becomes very large. The "logretain" and "userexit" are set to
"recovery" and "on" respectively.

Any suggestions are welcome...

Greetz
2005-04-25-13.50.33.699000+120 E86152469H468 LEVEL: Error
PID : 3344 TID : 1604 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1550
MESSAGE : ADM1833E The user exit program returned an error when
archiving log
file "S0000658.LOG" from
"C:\DB2INST1\NODE0000\SQL00001\SQLOGDIR\"
for database "WORKLOAD". The error code was "1".

2005-04-25-13.50.33.699000+120 I86152939H380 LEVEL: Error
PID : 3344 TID : 1604 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000658.LOG to USEREXIT from
C:\DB2INST1\NODE0000\SQL00001\SQLOGDIR\ with rc = 1.

2005-04-25-13.50.33.699000+120 I86153321H370 LEVEL: Warning
PID : 3344 TID : 1604 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 658 due to rc 1 for
LOGARCHMETH1
using method 4 and target .
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Hi Peter,

- did you compile the db2uext2.c with the right paths?
- did you copy the resulting db2uext2 to the sqllib/adm/ - directory?

What does USEREXIT.ERR (in ARCHIVE_PATH) say?

regards,

Norbert

Nov 12 '05 #2

P: n/a
Hi Norbert,

Where can I find the USEREXIT.ERR file? I do not have one in neither
C:/IBM/SQLLIB and C:\DB2INST1

Regards, Peter
Norbert Munkel <nm@acoreus.de> wrote in message news:<JH*************@se2-cb104-9.zrh1.ch.colt.net>...
Hi Peter,

- did you compile the db2uext2.c with the right paths?
- did you copy the resulting db2uext2 to the sqllib/adm/ - directory?

What does USEREXIT.ERR (in ARCHIVE_PATH) say?

regards,

Norbert

Nov 12 '05 #3

P: n/a
Hi Peter,

Peter wrote:
Hi Norbert,

Where can I find the USEREXIT.ERR file? I do not have one in neither
C:/IBM/SQLLIB and C:\DB2INST1


You should find it, wherever you have configured it in db2uext2.
As you are saying you are experiencing this problem since restoring the
database, I guess you have not compiled the userexit program (db2uext2)
at all. Please do so and copy it to the appropriate directory. Would be
sqllib/adm on a unix system. Please see reference documentation about
placement of userexit-routines in a windows environment.

regards,

Norbert
Nov 12 '05 #4

P: n/a
Peter,

it looks like, you have to set the new log managemt on.
Look for LOGARCHMETH1 in your db cfg.
For the new log managemt you don't need an userexit.

regards,
Joachim Müller

"Peter" <no******@yahoo.com> schrieb im Newsbeitrag
news:d9*************************@posting.google.co m...
Hello,

After restoring my database I have some problems with diag.log who
becomes very large. The "logretain" and "userexit" are set to
"recovery" and "on" respectively.

Any suggestions are welcome...

Greetz
2005-04-25-13.50.33.699000+120 E86152469H468 LEVEL: Error
PID : 3344 TID : 1604 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1550
MESSAGE : ADM1833E The user exit program returned an error when
archiving log
file "S0000658.LOG" from
"C:\DB2INST1\NODE0000\SQL00001\SQLOGDIR\"
for database "WORKLOAD". The error code was "1".

2005-04-25-13.50.33.699000+120 I86152939H380 LEVEL: Error
PID : 3344 TID : 1604 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000658.LOG to USEREXIT from
C:\DB2INST1\NODE0000\SQL00001\SQLOGDIR\ with rc = 1.

2005-04-25-13.50.33.699000+120 I86153321H370 LEVEL: Warning
PID : 3344 TID : 1604 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 658 due to rc 1 for
LOGARCHMETH1
using method 4 and target .

Nov 12 '05 #5

P: n/a
Hi,

Joachim Müller wrote:
Peter,

it looks like, you have to set the new log managemt on.
Look for LOGARCHMETH1 in your db cfg.
For the new log managemt you don't need an userexit.


you are absolutely right for 8.2 UDB. But as I understand, he is(was)
already using userexit. Never change a running system... ;-)

Oh... it is not running at all... sorry.

regards,

Norbert Munkel
Nov 12 '05 #6

P: n/a
Norbert,

changed all direct archiving with userexit to the new log management,
worked as designed...

regards,
Joachim Müller

"Norbert Munkel" <nm@acoreus.de> schrieb im Newsbeitrag
news:vq*************@se2-cb104-9.zrh1.ch.colt.net...
Hi,

Joachim Müller wrote:
Peter,

it looks like, you have to set the new log managemt on.
Look for LOGARCHMETH1 in your db cfg.
For the new log managemt you don't need an userexit.


you are absolutely right for 8.2 UDB. But as I understand, he is(was)
already using userexit. Never change a running system... ;-)

Oh... it is not running at all... sorry.

regards,

Norbert Munkel

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.