Hello, this is db2 v9.5 on AIX. We received a severe error and I am
investigating the cause. I have a PMR open but just for my knowledge
I wanted to know if there was a way to interpret at least an SQL error
from this entry in the diag log. This is the last line in the diag
log before a db2 trap:

2010-09-15-23.25.30.957325+000 I788758A506 LEVEL: Severe
PID : 7078080 TID : 2315 PROC : db2sysc
INSTANCE: ebony NODE : 000 DB : EBONY
APPHDL : 0-7 APPID: *LOCAL.ebony.100915232329
AUTHID : EBONY
EDUID : 2315 EDUNAME: db2agent (EBONY)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect,
probe:100
DATA #1 : Hexdump, 4 bytes
0x078000000073BCDC : FFFF F918

Does this last line have any meaningful information no admins? I
thought I read somewhere that it could be translated to an sql code
using a mask. Anyone know?

It doesn't have to be a SQLCODE.

But let's try:

C:\>db2diag -rc FFFFF918

Input ECF string 'FFFFF918' parsed as 0xFFFFF918 (-1768).
ERROR: t:/db2_v97fp3/nt32/s100725/engn/pd/../sqz/sqlzwhatisrc.C:
Input ZRC 0xFFFFF918 (-1768) cannot be identified as a V7 or V6
ZRC value

C:\>db2 ? SQL1768;


SQL1768N Unable to start HADR. Reason code = "<reason-code>".

The -1768 would only make sense if this is a first connect and the
databse is being activated I'd guess.

Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

On Sep 17, 11:47*am, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
Thanks Serge!