473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem when archiving log files

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
6 10555
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: BGN | last post by:
Hello, I've got quite a big Visual Studio .NET solution, that consists of many projects, including few Windows Services, and some console applications, and a setup project that creates one nice...
0
by: Anil0920 | last post by:
I have a very serious problem which really needs to be solved. We had a huge number of projects in 2002 that we recently converted to VS.NET 2003. The conversion was smooth and all is working well....
1
by: Kajol | last post by:
Hi I am facing a strange problem in downloading files from the web. CASE 1: I have an ActiveX.dll file developed using Visual Basic 6.0 and uploaded on a Linux Server. I am typing...
0
by: PeterB | last post by:
Hi! I am using the script below to download files, that are in a non-public directory, from my site. The "smaller files" section works for smaller files. However when the files are getting...
3
by: Ladykiller | last post by:
Hi everybody , I'm writing because i'm new in C++ and i have a big problem , I want my program to find files in a directory, (*.jpg, for example)and create alist of these files, Does anybody...
3
by: Deacon | last post by:
Dear all, I am using DB2 for AIX, I have the following problem when migrating my DB from DB2 v7.2 to v8.1 I orginally have a table with a CLOB field with logged and not compact properties. We...
6
by: Eran Kampf | last post by:
I am trying to dynamically create directories in my ASP.NET application (I am using Server.MapPath("/")+"test" as the folder) and I am getting a DirectoryNotFoundException saying "Could not find a...
0
by: Kleanthis | last post by:
I have a problem, when deploying multilingual applications using cab files on Compact Framework 2.0. It seems that something is going wrong with compact framework 2.0 Below I have a description...
11
by: kimiraikkonen | last post by:
Hi, Vb.net 2005 express i've been working, the problem is: I use openfiledialog to browse files, i created some code to execute file with OK button, no problem. But if i press "cancel" button as...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.