Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    6

    Unanswered: DB2 9.1 connection issue

    When i try to connect the DB2 9.1 database in DB2 control center,it will come out the below error message!

    [IBM][CLI Driver] SQL0902C A system error (reason code = "")
    occurred. Subsequent SQL statements cannot be processed.
    SQLSTATE=58005


    The below info that i taken from db2diag.log:

    2010-09-24-17.43.24.879000+480 I2429488F468 LEVEL: Severe
    PID : 3776 TID : 3688 PROC : db2fmp64.exe
    INSTANCE: DB2DV1 NODE : 000
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
    MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR"
    DIA8532C An internal processing error has occurred.

    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 8 bytes
    81

    2010-09-24-17.50.18.704000+480 E2429958F368 LEVEL: Error (OS)
    PID : 2908 TID : 2000 PROC : db2syscs.exe
    INSTANCE: DB2DV1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloImpersonateLocalSystem, probe:20
    MESSAGE : ZRC=0x83000005=-2097151995
    CALLED : OS, -, OpenProcessToken
    OSERR : 5 "Access is denied."

    2010-09-24-17.50.18.720000+480 I2430328F282 LEVEL: Severe
    PID : 2908 TID : 2000 PROC : db2syscs.exe
    INSTANCE: DB2DV1 NODE : 000
    FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20
    RETCODE : ZRC=0x83000005=-2097151995

    2010-09-24-17.50.18.720000+480 I2430612F358 LEVEL: Severe
    PID : 2908 TID : 2000 PROC : db2syscs.exe
    INSTANCE: DB2DV1 NODE : 000
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : User ID
    DATA #1 : Hexdump, 4 bytes
    0x000000000703F920 : 0000 0000 ....

    2010-09-24-17.50.18.720000+480 I2430972F465 LEVEL: Severe
    PID : 3384 TID : 3460 PROC : javaw.exe
    INSTANCE: DB2DV1 NODE : 000
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
    MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR"
    DIA8532C An internal processing error has occurred.

    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 8 bytes
    81


    Thanks for help!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Looks like a process permissions issue. What account do you use to run the DB2 service?

  3. #3
    Join Date
    Jul 2010
    Posts
    6
    It is the domain administrator account!

    Tanks!

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It must be either a local administrator or the local system account.

Posting Permissions

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