Results 1 to 4 of 4

Thread: db2look error

  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: db2look error

    Hi,
    I am using DB2 ESE V9.5 on windows 2003.
    Running DB2look on any database generates the below error in the Event Viewer.

    Event ID: 1000
    Faulting application db2look.exe, version 9.5.0.808, faulting module db2look.exe, version 9.5.0.808, fault address 0x00041b5f.

    I tried running the same command on another machine also but even there it is generating the same error. What actually is causing the error and how can I overcome it to successfully execute the command?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Apply the latest Fix Pack and try again. It the problem persists, open a PMR with IBM.

    Andy

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    chk db2diag
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Jul 2008
    Posts
    131
    i dont think its the problem of fixpack because it worked before. I faced this errror yesterday only for the very first time.

    db2diag has got the below message:
    2009-05-05-10.06.37.648000+330 I3427H398 LEVEL: Info
    PID : 3244 TID : 7820 PROC : db2look.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 7820
    FUNCTION: DB2 Common, Security, Users and Groups, secLoadClientAuthPlugin, probe:10
    DATA #1 : String, 91 bytes
    Loaded plugin library C:\PROGRA~1\IBM\SQLLIB\security\plugin\IBM\client\ IBMOSauthclient.dll

    2009-05-05-10.06.37.648000+330 I3827H335 LEVEL: Info
    PID : 3244 TID : 7820 PROC : db2look.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 7820
    FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
    DATA #1 : String with size, 37 bytes
    db2secClientAuthPluginInit successful

    2009-05-05-10.06.37.976000+330 I4164H479 LEVEL: Info
    PID : 3244 TID : 7820 PROC : db2look.exe
    INSTANCE: DB2 NODE : 000
    APPID : *LOCAL.DB2.090505043637
    EDUID : 7820
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
    MESSAGE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
    "No connection"
    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 4 bytes
    71

    2009-05-05-10.06.37.976000+330 I4645H479 LEVEL: Info
    PID : 3244 TID : 7820 PROC : db2look.exe
    INSTANCE: DB2 NODE : 000
    APPID : *LOCAL.DB2.090505043637
    EDUID : 7820
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
    MESSAGE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
    "No connection"
    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 4 bytes
    71

Posting Permissions

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