Help

**Philip Nelson** · Mar 23 '07, 09:05 PM

Re: Help

matias.cornejo@ gmail.com wrote:

Â¿Â¿Â¿Â¿Â¿Â¿Any body knows this error??????
>
2007-03-23-11.08.12.484581 Instance:db2ins t1 Node:000
PID:204782(db2a gent (DB2XXX)) Appid:*LOCAL.db 2inst1.07032323 2921
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:db2ins t1 Node:000
PID:204782(db2a gent (DB2XXX)) Appid:*LOCAL.db 2inst1.07032323 2921
relation_data_s erv sqlrldri Probe:120 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544 ".
>
2007-03-23-11.10.40.351471 Instance:db2ins t1 Node:000
PID:52752(db2ag ent (DB2XXX)) Appid:C80EA1B1. 05CC.0703232337 59
relation_data_s erv sqlrl_sysTables Read 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_LTIMEOU T

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

**matias.cornejo@gmail.com** · Mar 25 '07, 10:15 PM

Re: Help

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:db2ins t1 Node:000
PID:204782(db2a gent (DB2XXX)) Appid:*LOCAL.db 2inst1.07032323 2921
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:db2ins t1 Node:000
PID:204782(db2a gent (DB2XXX)) Appid:*LOCAL.db 2inst1.07032323 2921
relation_data_s erv sqlrldri Probe:120 Database:DB2XXX
DIA9999E An internal error occurred. Report the following error code :
"0xFFFF8544 ".

>

2007-03-23-11.10.40.351471 Instance:db2ins t1 Node:000
PID:52752(db2ag ent (DB2XXX)) Appid:C80EA1B1. 05CC.0703232337 59
relation_data_s erv sqlrl_sysTables Read 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_LTIMEOU T
>
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.

Help

Help

Comment

Comment