470,636 Members | 1,512 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

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 5597
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Tom | last post: by
6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by
8 posts views Thread by Mark | last post: by
1 post views Thread by Korara | last post: by
???
reply views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.