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
