Which application from where ?

DBFinder · #1 (**permalink**) 03-23-09, 11:47

Hi all

As we have located some error in DB2DIAG.LOG,
How can I tell which application on which workstation is causing this error.

This is important cause DEV team need to locate the source of error.

I searched through app snapshots but did not find anything using appID and PID/TID.

Code:

2009-03-23-10.55.26.840000   Instance:DB2   Node:000
PID:1808(db2syscs.exe)   TID:1776   Appid:GA4603F1.HC0E.023243150035
base sys utilities  sqleattach_agent Probe:60   Database:TRIUMPH

DIA0001E An internal error occurred. Report the following error code : 
"ZRC=0x81360012".

Server DB2 v 8.1.5 on Win 2000

Thanks
DBFinder

Marcus_A · #2 (**permalink**) 03-23-09, 12:30

GA4603F1 is the ip address of the application client. But it is in hex, so you need to convert to decimal.
So it is GA.46.03.F1 and then convert each level to Decimal.

Also, G=0 H=1, I= 2, etc (don't ask).

DBFinder · #3 (**permalink**) 03-23-09, 13:53

Thanks,

This resolved my problem.

I came to conclusion that all the errors were caused by one workstation.

All others are OK.

Thanks Again
DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech