Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Which application from where ?

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •