472,344 Members | 1,323 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Help

真真真Anybody knows this error??????

2007-03-23-11.08.12.484581 Instance:db2inst1 Node:000
PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
data_management sqldmdpi Probe:443 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544".

2007-03-23-11.08.12.495222 Instance:db2inst1 Node:000
PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
relation_data_serv sqlrldri Probe:120 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544".

2007-03-23-11.10.40.351471 Instance:db2inst1 Node:000
PID:52752(db2agent (DB2XXX)) Appid:C80EA1B1.05CC.070323233759
relation_data_serv sqlrl_sysTablesRead Probe:25 Database:DB2XXX
DIA1003C The interrupt has been received.

ZRC=0xFFFF8503

Mar 23 '07 #1
2 5707
ma************@gmail.com wrote:
多多多多多多Anybody knows this error??????

2007-03-23-11.08.12.484581 Instance:db2inst1 Node:000
PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
data_management sqldmdpi Probe:443 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544".

2007-03-23-11.08.12.495222 Instance:db2inst1 Node:000
PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
relation_data_serv sqlrldri Probe:120 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544".

2007-03-23-11.10.40.351471 Instance:db2inst1 Node:000
PID:52752(db2agent (DB2XXX)) Appid:C80EA1B1.05CC.070323233759
relation_data_serv sqlrl_sysTablesRead Probe:25 Database:DB2XXX
DIA1003C The interrupt has been received.

ZRC=0xFFFF8503
Matias,

You can get the meaning of the hex values using the command -

db2diag -rc 0xFFFF8544 (for example using your first code)

Here's the results cut and pasted direct from my V9.1 system -

scotdb@mahler:~db2diag -rc 0xFFFF8544

Input ECF string '0xFFFF8544' parsed as 0xFFFF8544 (-31420).
NOTE: ../sqz/sqlzwhatisrc.C:
V7 input ZRC 0xFFFF8544 (-31420) may translate to V8 ZRC value of
0x80100044 (-2146435004)

ZRC value to map: 0x80100044 (-2146435004)
V7 Equivalent ZRC value: 0xFFFF8544 (-31420)

ZRC class :
SQL Error, User Error,... (Class Index: 0)
Component:
SQLP ; data protection services (Component Index: 16)
Reason Code:
68 (0x0044)

Identifer:
SQLP_LTIMEOUT
Identifer (without component):
SQLZ_RC_LTIMEOUT

Description:
LockTimeOut - tran rollback Reason code 68

Associated information:
Sqlcode -911
SQL0911N The current transaction has been rolled back because of a deadlock
or
timeout. Reason code "".

Number of sqlca tokens : 1
Diaglog message number: 1

scotdb@mahler:~db2diag -rc 0xFFFF8503

Input ECF string '0xFFFF8503' parsed as 0xFFFF8503 (-31485).
NOTE: ../sqz/sqlzwhatisrc.C:
V7 input ZRC 0xFFFF8503 (-31485) may translate to V8 ZRC value of
0x80100003 (-2146435069)

ZRC value to map: 0x80100003 (-2146435069)
V7 Equivalent ZRC value: 0xFFFF8503 (-31485)

ZRC class :
SQL Error, User Error,... (Class Index: 0)
Component:
SQLP ; data protection services (Component Index: 16)
Reason Code:
3 (0x0003)

Identifer:
SQLP_LINT
Identifer (without component):
SQLZ_RC_INTR

Description:
Interrupt from application

Associated information:
Sqlcode -952
SQL0952N Processing was cancelled due to an interrupt.

Number of sqlca tokens : 0
Diaglog message number: 8003
So it looks like you had two deadlocks or timeouts, followed by someone
cancelling a session.

HTH

Phil
Mar 23 '07 #2
On 23 mar, 16:57, Philip Nelson <team...@scotdb.comwrote:
matias.corn...@gmail.com wrote:
真真真Anybody knows this error??????
2007-03-23-11.08.12.484581 Instance:db2inst1 Node:000
PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
data_management sqldmdpi Probe:443 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544".
2007-03-23-11.08.12.495222 Instance:db2inst1 Node:000
PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921
relation_data_serv sqlrldri Probe:120 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544".
2007-03-23-11.10.40.351471 Instance:db2inst1 Node:000
PID:52752(db2agent (DB2XXX)) Appid:C80EA1B1.05CC.070323233759
relation_data_serv sqlrl_sysTablesRead Probe:25 Database:DB2XXX
DIA1003C The interrupt has been received.
ZRC=0xFFFF8503

Matias,

You can get the meaning of the hex values using the command -

db2diag -rc 0xFFFF8544 (for example using your first code)

Here's the results cut and pasted direct from my V9.1 system -

scotdb@mahler:~db2diag -rc 0xFFFF8544

Input ECF string '0xFFFF8544' parsed as 0xFFFF8544 (-31420).
NOTE: ../sqz/sqlzwhatisrc.C:
V7 input ZRC 0xFFFF8544 (-31420) may translate to V8 ZRC value of
0x80100044 (-2146435004)

ZRC value to map: 0x80100044 (-2146435004)
V7 Equivalent ZRC value: 0xFFFF8544 (-31420)

ZRC class :
SQL Error, User Error,... (Class Index: 0)
Component:
SQLP ; data protection services (Component Index: 16)
Reason Code:
68 (0x0044)

Identifer:
SQLP_LTIMEOUT
Identifer (without component):
SQLZ_RC_LTIMEOUT

Description:
LockTimeOut - tran rollback Reason code 68

Associated information:
Sqlcode -911
SQL0911N The current transaction has been rolled back because of a deadlock
or
timeout. Reason code "".

Number of sqlca tokens : 1
Diaglog message number: 1

scotdb@mahler:~db2diag -rc 0xFFFF8503

Input ECF string '0xFFFF8503' parsed as 0xFFFF8503 (-31485).
NOTE: ../sqz/sqlzwhatisrc.C:
V7 input ZRC 0xFFFF8503 (-31485) may translate to V8 ZRC value of
0x80100003 (-2146435069)

ZRC value to map: 0x80100003 (-2146435069)
V7 Equivalent ZRC value: 0xFFFF8503 (-31485)

ZRC class :
SQL Error, User Error,... (Class Index: 0)
Component:
SQLP ; data protection services (Component Index: 16)
Reason Code:
3 (0x0003)

Identifer:
SQLP_LINT
Identifer (without component):
SQLZ_RC_INTR

Description:
Interrupt from application

Associated information:
Sqlcode -952
SQL0952N Processing was cancelled due to an interrupt.

Number of sqlca tokens : 0
Diaglog message number: 8003

So it looks like you had two deadlocks or timeouts, followed by someone
cancelling a session.

HTH

Phil- Ocultar texto de la cita -

- Mostrar texto de la cita -
Thanks for your information.

Mar 25 '07 #3

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

Similar topics

21
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an...
9
by: Tom | last post by:
A question for gui application programmers. . . I 've got some GUI programs, written in Python/wxPython, and I've got a help button and a help menu...
6
by: wukexin | last post by:
Help me, good men. I find mang books that introduce bit "mang header files",they talk too bit,in fact it is my too fool, I don't learn it, I have...
3
by: Colin J. Williams | last post by:
Python advertises some basic service: C:\Python24>python Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on win32 Type "help", "copyright",...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting...
5
by: Steve | last post by:
I have written a help file (chm) for a DLL and referenced it using Help.ShowHelp My expectation is that a developer using my DLL would be able to...
8
by: Mark | last post by:
I have loaded Visual Studio .net on my home computer and my laptop, but my home computer has an abbreviated help screen not 2% of the help on my...
10
by: JonathanOrlev | last post by:
Hello everybody, I wrote this comment in another message of mine, but decided to post it again as a standalone message. I think that...
1
by: trunxnirvana007 | last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more:...
0
by: hitencontractor | last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003. I added a menu item called "MyApp Help" in the end of the menu...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

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.