Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    11

    Unanswered: db2 service not getting started

    I have db2 version 8.1.9.917 server Fixpak "9" installed in Win XP. I loaded DB2 Information Integrator over it. After that I uninstalled just the DB2 Information Integrator. But now, I am not able to start my DB2 service.

    From command prompt "db2start" says "SQL1042C An unexpected system error occurred"

    From the Windows Service it says unable to start service. This is what I got from the Event Viewer

    "The DB2 - DB2-0 service terminated with service-specific error 4294962116 (0xFFFFEBC4)."

    Can anyone tell me whats wrong and how to fix this.

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    start

    try a db2start from command window and check db2diag.log
    service... check db2 get dbm cfg <-- SVCENAME
    and db2nodes.cfg
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Try reinstalling the DB2 fixpak.

  4. #4
    Join Date
    Oct 2006
    Posts
    11
    Here's what db2diag.log has to say. Also db2nodes.cfg and SVCENAME seems to have correct entries.


    2006-10-28-09.01.23.176000+330 I1491131H1546 LEVEL: Event
    PID : 3952 TID : 3616 PROC : db2start.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
    DATA #1 : String, 48 bytes
    C:\PROGRA~1\DB2_IN~1\IBM\SQLLIB\bin\DB2STAR2.EXE
    DATA #2 : Hexdump, 256 bytes
    0x0012A8B4 : 433A 5C50 524F 4752 417E 315C 4442 325F C:\PROGRA~1\DB2_
    0x0012A8C4 : 494E 7E31 5C49 424D 5C53 514C 4C49 425C IN~1\IBM\SQLLIB\
    0x0012A8D4 : 6269 6E5C 4442 3253 5441 5232 2E45 5845 bin\DB2STAR2.EXE
    0x0012A8E4 : 004E 4F4D 5347 0000 0000 0000 0000 0000 .NOMSG..........
    0x0012A8F4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A904 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A914 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A924 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A934 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A944 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A954 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A964 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A974 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A984 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A994 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x0012A9A4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

    2006-10-28-09.01.24.057000+330 I1492679H366 LEVEL: Severe
    PID : 3832 TID : 2448 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleAddDataJoinerEnvString, probe:40
    MESSAGE : DiagData
    DATA #1 : Hexdump, 4 bytes
    0x0091DC3C : C4EB FFFF ....

    2006-10-28-09.01.24.067000+330 I1493047H357 LEVEL: Severe
    PID : 3832 TID : 2448 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleSetupEnvVars, probe:120
    MESSAGE : DiagData
    DATA #1 : Hexdump, 4 bytes
    0x0091DC84 : C4EB FFFF ....

    2006-10-28-09.01.24.077000+330 I1493406H353 LEVEL: Severe
    PID : 3832 TID : 2448 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:600
    MESSAGE : DiagData
    DATA #1 : Hexdump, 4 bytes
    0x0091FBBC : C4EB FFFF ....

    2006-10-28-09.01.24.137000+330 I1493761H635 LEVEL: Error
    PID : 3952 TID : 3616 PROC : db2start.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloStartDB2Service, probe:50
    DATA #1 : Hexdump, 66 bytes
    0x00129BA0 : 4442 322D 3020 3A20 5468 6520 7365 7276 DB2-0 : The serv
    0x00129BB0 : 6963 6520 6861 7320 7265 7475 726E 6564 ice has returned
    0x00129BC0 : 2061 2073 6572 7669 6365 2D73 7065 6369 a service-speci
    0x00129BD0 : 6669 6320 6572 726F 7220 636F 6465 2E0D fic error code..
    0x00129BE0 : 0A0A ..

    2006-10-28-09.01.24.137000+330 I1494398H658 LEVEL: Severe
    PID : 3952 TID : 3616 PROC : db2start.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:70
    MESSAGE : DiagData
    DATA #1 : Hexdump, 66 bytes
    0x0012A274 : 4442 322D 3020 3A20 5468 6520 7365 7276 DB2-0 : The serv
    0x0012A284 : 6963 6520 6861 7320 7265 7475 726E 6564 ice has returned
    0x0012A294 : 2061 2073 6572 7669 6365 2D73 7065 6369 a service-speci
    0x0012A2A4 : 6669 6320 6572 726F 7220 636F 6465 2E0D fic error code..
    0x0012A2B4 : 0A0A ..

    Can we avoid a re-install ?

Posting Permissions

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