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 . 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
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
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
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 .
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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....
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |