By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Help

P: n/a
真真真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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.