Hi everybody,
I have a very strange problem with one DB (only one in a list of 21).
This DB is used by a Java application and work fine since a couple of years. This week the application stop responding, throwing this java the error :
Cannot create PoolableConnect ionFactory ([IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004
)
After a verification, the db was not Active so I tried to activate it (by clicking the "connect" link in Control center) a I got the error (obviously !):
([IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004
Since I cant access any parameter of this database if it does not start, I don't know how to solve my problem.
I tried to restore the file system of this DB from our backup but I got the same error.
If I refer to Db2 messages site, they suggest to reinstall the database manager or Db2 entirely. I'm not sure it's a good idea to reinstall for two reason :
1- we have db2 warehouse on the same server and dont want to fuck it up with a reinstall.
2- Other databases on this server works fine.
If reinstall is the only solutions, could I reinstall the database manager without any problem (data lost, broke warehouse link,...)?
I'm facing a wall... and need help as soon as possible
PS : we are using v8.1 on windows
Thanks in advance
Hugues
8  12100 
Hi,
check the db2diag.log file for the reason of this. I guess you might find some error indicating that memory could not be allocated.
You're running the 32bit version of DB2 on 32bit Window$? Then it may be a limitation to the 32bit LUW DB2 version that you ran into. Although your server might have lots of RAM available, you may get a "no memory" error by DB2.
32bit means all user processes and therefore DB2, too, are limited to 2 GB userspace RAM. This also limits database shared memory and instance shared memory.
This all would take too long to describe here. You'll find more information at http://www.ibm.com/developerworks/db...6qi/index.html and possibly even the solution.
Regards, Bernd
Thanks for the response Bernd ,
Yes we are on 32 bit, but if it's a version limitation why this problem occurs only with this DB ?
If I stop all others databases the problem still the same. I'd take a look at db2diag.log and found this (see at the end of the post).
What does it mean by "data does not exist". I wish i did not lost everything Seems to :-( but if I open the .dat file from the file system I can see lot of data between the "encrypted" text
Do you know what is the signification of "marked as bad" ?
Is it possible to restore a database from the file system file like in Sql Server (by copying the mdf file and attach a new DB) ?
Hugues
2007-09-19-13.49.38.748000-240 I79111629H388 LEVEL: Error
PID : 3220 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
FUNCTION: DB2 UDB, data protection, sqlpgolf, probe:320
RETCODE : ZRC=0x870F0009=-2029060087=SQLO _EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
2007-09-19-13.49.38.758000-240 I79112019H530 LEVEL: Error
PID : 3220 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
FUNCTION: DB2 UDB, data protection, sqlpgolf, probe:320
MESSAGE : Filename :
DATA #1 : Hexdump, 46 bytes
0x04AEF324 : 443A 5C44 4232 5C4E 4F44 4530 3030 305C D:\DB2\NODE0000 \
0x04AEF334 : 5351 4C30 3030 3034 5C53 514C 4F47 4449 SQL00004\SQLOGD I
0x04AEF344 : 525C 5330 3030 3030 3030 2E4C 4F47 R\S0000000.LOG
2007-09-19-13.49.38.758000-240 I79112551H321 LEVEL: Error
PID : 3220 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:1440
MESSAGE : Error -2045771763 opening database log extent 0:
2007-09-19-13.49.38.758000-240 I79112874H398 LEVEL: Error
PID : 3220 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
FUNCTION: DB2 UDB, data protection, sqlpgicl, probe:2130
RETCODE : ZRC=0x8610000D=-2045771763=SQLP _BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2007-09-19-13.49.38.758000-240 I79113274H404 LEVEL: Error
PID : 3220 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
FUNCTION: DB2 UDB, data protection, sqlpgLoggrInit, probe:1150
RETCODE : ZRC=0x8610000D=-2045771763=SQLP _BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2007-09-19-13.49.38.758000-240 I79113680H160 LEVEL: Error
PID:3220 TID:3796 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\32203796.000
2007-09-19-13.49.38.768000-240 I79113842H405 LEVEL: Severe
PID : 3220 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x04AEFC94 : 0000 0000 ....
2007-09-19-13.49.38.778000-240 I79114249H461 LEVEL: Severe
PID : 3220 TID : 3404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
APPHDL : 0-16 APPID: *LOCAL.DB2.0709 19174938
FUNCTION: DB2 UDB, data protection, sqlpgint, probe:3640
RETCODE : ZRC=0x8610000D=-2045771763=SQLP _BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2007-09-19-13.49.38.778000-240 I79114712H435 LEVEL: Severe
PID : 3220 TID : 3404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
APPHDL : 0-16 APPID: *LOCAL.DB2.0709 19174938
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x04119020 : 0D00 1086 ....
2007-09-19-13.49.38.778000-240 I79115149H414 LEVEL: Error
PID : 3220 TID : 3404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
APPHDL : 0-16 APPID: *LOCAL.DB2.0709 19174938
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #1 : Hexdump, 4 bytes
0x04119020 : 0D00 1086 ....
2007-09-19-13.49.38.778000-240 E79115565H372 LEVEL: Severe
PID : 3220 TID : 3404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
APPHDL : 0-16 APPID: *LOCAL.DB2.0709 19174938
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "SYNKGPR " marked bad.
2007-09-19-13.49.38.798000-240 I79115939H443 LEVEL: Severe
PID : 3220 TID : 3404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
APPHDL : 0-16 APPID: *LOCAL.DB2.0709 19174938
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnec t, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x03FA1B14 : EEFB FFFF ....
2007-09-19-13.49.38.808000-240 I79116384H466 LEVEL: Severe
PID : 3220 TID : 3404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SYNKGPR
APPHDL : 0-16 APPID: *LOCAL.DB2.0709 19174938
FUNCTION: DB2 UDB, base sys utilities, sqlescln, probe:24
DATA #1 : String, 22 bytes
sqlm_d_exit is failed.
DATA #2 : Hexdump, 4 bytes
0x04118D20 : 0100 0000
Thanks for the response,
I'd submit new detail on the thread after reading your reply. Could you check this ?
Hi,
check the db2diag.log file for the reason of this. I guess you might find some error indicating that memory could not be allocated.
You're running the 32bit version of DB2 on 32bit Window$? Then it may be a limitation to the 32bit LUW DB2 version that you ran into. Although your server might have lots of RAM available, you may get a "no memory" error by DB2.
32bit means all user processes and therefore DB2, too, are limited to 2 GB userspace RAM. This also limits database shared memory and instance shared memory.
This all would take too long to describe here. You'll find more information at http://www.ibm.com/developerworks/db...6qi/index.html and possibly even the solution.
Regards, Bernd
Hi,
looks like something very bad did happen to the log file. Seems to be there, but something inside is wrong. Did you encounter a disc full error lately?
You said you tried a restore but got the same error afterwards. Do you have an earlier backup to restore?
A restore of the whole db directory (in your case SQL00004) often works, but it's not recommended. You could try it. Stop the instance, move/rename the SQL00004 folder, restore from backup device. On connect DB2 will try a crash recovery. Maybe working, but no guarantee! Another way may be renaming the logs, so that DB2 thinks there's none. Btw., is your parameter LOGRETAIN set to RECOVERY or OFF?
Regards, Bernd
Hi,
Seems to be there, but something inside is wrong. Did you encounter a disc full error lately?
Nothing about disc full but a problem with the log file on another DB : msg=Database transaction log is full.
I saw that this "other" BD used log in SQL0004 (I don't understand why it does not use log in its db directory ?!?) then maybe the problem originate from this log error. I'll try to rename the log file as you mention.
You said you tried a restore but got the same error afterwards. Do you have an earlier backup to restore?
yes, but its not a DB2 backup but a file system backup from last week, before the problem occurs.
Btw., is your parameter LOGRETAIN set to RECOVERY or OFF?
Since my DB dont want to start (activate), how could I consult its parameters ? By now, I cant do anything with this DB
Thanks again
Hugues
HI,
Nothing about disc full but a problem with the log file on another DB : msg=Database transaction log is full.
This just means that the capacity of the log file(s) was exhausted. This may occure easily if you e.g. start a huge insert and your log files are too small. Doesn't do any harm.
You say the other db was using logs in a foreign db's folder? This is weird. But even though it shouldn't and no matter how that happened - if it is that way then this will have corrupted the log files of your db.
At the current moment I see no other way than to try the restore of the filesystem backup, to hope that it was taken while the db was inactive and therefore offline, and to wish you good luck.
Regards, Bernd
P.S.: Don't forget to repair the other messy db before doing the restore.
thanks for your help Bernd but we work to much on that problem.
We finally restored the entire VM of this DB server and migrate the DB from the restored server to the production server (with another DB name).
thanks again
Hugues
Hi,
you're welcome. Glad to hear you got the DB working again.
Finally, I have a question to you. You wrote that you're running the DB2 server within a VM. Cloud you specify which kind of VM (LPAR,Vmware,Xe n,...) and how your experiences are concerning reliability and performance?
Regards, Bernd
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Ghanashyam |
last post by:
Dotnet Framework 1.1 is installed on my computer running on Windows 2000
Professional.Visual Studio >net 2003 is installed.When I try to create an
ASP.NET project I get following error.
The web server reported the following error when attempting to create or
open the web project located at the following
'URL://Localhost/WebApplication1' HTTP 1.1/500 Server error
I tried reinstalling the .NET but it did not help me.
Any help in this...
|
by: Morten H. |
last post by:
Hey,
I have a problem on my server. WHen I activate cookieless sessionstate
I can only execute aspx pages. When the server tries to find an image
in a subfolder eg. http://mysite/(gklffgfgdsg85t6583)/image/top.gif
its not found. The same goes for javascripts ect. if I remove the
sessionid (http://mysite/image/top.gif) the image is found as usual.
This is only a problem on one of our servers, and I suspect that an
update has caused...
|
by: Ann Marinas |
last post by:
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
|
by: Brian Farnhill (MCP VB.NET) |
last post by:
Hi,
I am having some trouble using the MailMessage object to send an email with
more than one attachment.
I am working on a web based application where a user can submit information,
along with a number of files. The information, including the file is stored
in the database, and an email is sent with the information and any files that
were submitted are attached. The system works fine when a user makes a
submission that has no...
|
by: snicks |
last post by:
I'm trying to exec a program external to my ASP.NET app using the following
code. The external app is a VB.NET application.
Dim sPPTOut As String
sPPTOut = MDEPDirStr + sID + ".ppt"
Dim p As New System.Diagnostics.Process
'p.Start(MDEPDirStr & "macrun.exe", sPPTOut)
p.Start("C:\WINDOWS\SYSTEM32\CALC.EXE")
'p.Start("C:\WINDOWS\SYSTEM32\macrun.exe", sPPTOut)
| | |
by: K S |
last post by:
All,
I am getting the following error when I tried to deploy my webpage (Release
Version) on Windows Server 2003. The below error occurs when I try to access
the webservice.
PS: I can access the webservice from IE from the same Windows Server box.
I did some googling and tried the options suggested but with no luck. Any
help would be much appreciated.
|
by: drako |
last post by:
Hi,
I'm a bit stumped as I am getting a "Notice: Array to String
Conversion" error when trying to do something that on the surface
should be a very simple task - create an array, and write a set of
values to them based on data submitted from POST Fields.
Code below:
$_SESSION = array();
|
by: Tony K |
last post by:
ERROR MESSAGE RECEIVED WHEN SAVING.
"The operation could not be completed. No such interface supported."
Dell Inspirion E1705, 1GB RAM, Windows Vista Ultimate
I can start debugging and the website appears in my browser with pics so
that tells me that data is being retrieved from the db file.
Not sure what is going on. I receive this error when saving a new website.
This one in particular is a starter kit for the Business website. I...
|
by: mvanreek |
last post by:
Error when opening MDE (which includes Access97 runtime) in Office 2007
Hello.
I build an application for a client in Access97 and gave them the MDE version which includes the Access97-runtime (because they have an Office (2007) version without Access).
When they try to open the MDE-file, the get the error:
"You can not convert or activate a MDE file" (my translation of the original error, in Dutch:
"U kunt een MDE bestand niet...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
