473,473 Members | 2,304 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Message i db2diag.log from 'oper system services sqloPostIPCWaitPost'

Today no users was able to connect to the database, I could not list applications, list active databases, nor could I execute 'db2stop force'. We had to restart the database server and db2 performed a successful crash recovery. Now all seems to be alright again. But what I can see from the db2diag.log is a lot of these messages:

2005-03-16-07.15.35.562000 Instance:DB2 Node:000
PID:1704(db2syscs.exe) TID:4336 Appid:*LOCAL.DB2.016445095031
oper system services sqloPostIPCWaitPost Probe:40 Database:XDKE00

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:1704 TID:4336 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.

Anyone know what these could tell me about what was wrong ?

Regards
Odd Bjørn Andersen
ErgoGroup
Oslo, Norway
Nov 12 '05 #1
3 1648
Odd Bjørn Andersen wrote:
Today no users was able to connect to the database, I could not list
applications, list active databases, nor could I execute 'db2stop
force'. We had to restart the database server and db2 performed a
successful crash recovery. Now all seems to be alright again. But what I
can see from the db2diag.log is a lot of these messages:

2005-03-16-07.15.35.562000 Instance:DB2 Node:000
PID:1704(db2syscs.exe) TID:4336 Appid:*LOCAL.DB2.016445095031
oper system services sqloPostIPCWaitPost Probe:40 Database:XDKE00

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:1704 TID:4336 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
Anyone know what these could tell me about what was wrong ?

Regards
Odd Bjørn Andersen
ErgoGroup
Oslo, Norway

What system?
What version of db2 ?
Do you have DB2Support ?

Cu,

indika
Nov 12 '05 #2
There could be couple of reasons for such messages
1) Check with the db2 client levels.
2) Check whether the remote client did not disconnect in proper fashion
3) Check if all the semaphore connection are released as part of your
db2stop.

Nov 12 '05 #3
Sorry. This is Windows 2003 and DB2 UDB Enterprise Server Edition version
8.1, fixpcak 6a.

Regards
Odd Bjørn

"indika" <in****@gmx.ch> wrote in message news:d1**********@nntp.ilk.net...
Odd Bjørn Andersen wrote:
Today no users was able to connect to the database, I could not list
applications, list active databases, nor could I execute 'db2stop
force'. We had to restart the database server and db2 performed a
successful crash recovery. Now all seems to be alright again. But what I
can see from the db2diag.log is a lot of these messages:

2005-03-16-07.15.35.562000 Instance:DB2 Node:000
PID:1704(db2syscs.exe) TID:4336 Appid:*LOCAL.DB2.016445095031
oper system services sqloPostIPCWaitPost Probe:40 Database:XDKE00

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:1704 TID:4336 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
Anyone know what these could tell me about what was wrong ?

Regards
Odd Bjørn Andersen
ErgoGroup
Oslo, Norway

What system?
What version of db2 ?
Do you have DB2Support ?

Cu,

indika

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: | last post by:
Does this message mean something to someone? I am receiving it during a CREATE SQL PROCEDURE statement and am wondering if this could be the source of the error: IBM CLI DRIVER SQL30020N ...
0
by: db2group88 | last post by:
we are using db2 udb v8.1 fp 5 on windows 64bit machine, i find these errors on db2diag.log 2004-07-26-14.13.08.760000 pid:5204 tid:5928 level:2 Common - DSTF - dstfLatchShmPool() probe:10...
4
by: WantedToBeDBA | last post by:
Hi Friends, I am running a stored procedure in Windows 2000 box (version 8.1.0) and i am getting following error in db2diag.log repeatly. The scenerio is as follows. I am inserting 55000...
0
by: lennart | last post by:
Greetings, the last three days I have started to get entries like: 2005-10-05-16.51.44.615996+120 I20328552G471 LEVEL: Warning PID : 11244 TID : 3006253568 PROC :...
13
by: Michel Esber | last post by:
Hello, Environment is: DB2 V8 FP10 Linux Kernel 2.6 My db2diag.log is full of the following lines: 2006-02-01-15.56.26.557312-120 E405226240G308 LEVEL: Error (OS) PID : 31005 ...
3
by: ariel | last post by:
Hello, I am running DB2 version v8.1.3.88 on a Sun v40z server running RedHat Linux AS 4 kernel version 2.6.9. My problem is that the db2diag.log file is growing without bounds (I just deleted a...
5
by: Norm | last post by:
Does anyone have any suggestions for securing against this vulnerability: http://nvd.nist.gov/nvd.cfm?cvename=CVE-2007-1027 Fixes are not yet available from IBM. They will be in FP2 for V9...
5
by: Eric Davidson | last post by:
I keep getting the folowing error message in my db2diag.log every couple of seconds, and I can not find any information on this on the DB2 website or in the apr's Can anyone give me a pointer...
6
by: KG | last post by:
Hi, Does anyone knows how to recover the test file db2diag.log. By mistake I have delete the contents of db2diag.log, wondering if I could restore the contents of my db2diag.log.
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
tracyyun
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...
0
agi2029
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,...
1
isladogs
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...
0
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...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.