Help
in [DB2]
|
From: matias.cornejo on 23 Mar 2007 12:34 ¿¿¿¿¿¿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
From: Philip Nelson on 23 Mar 2007 16:57 matias.cornejo(a)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(a)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(a)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
From: matias.cornejo on 25 Mar 2007 18:14 On 23 mar, 16:57, Philip Nelson <team...(a)scotdb.com> wrote: > matias.corn...(a)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(a)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(a)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.
|
Pages: 1 Prev: SQL0437W reason code 3, anything to worry about? Next: PROBLEM WITH JUNK CHARECTER |