Topic
8 replies Latest Post - ‏2012-11-07T15:57:12Z by SystemAdmin
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

‏2012-05-20T10:17:31Z |
I tried to install it on few machines which have Windows xp 32bit and every time I get the following error while trying to run db2start:

DB2_01: The service has returned a service-specific error code.
SQL1042C An unexpected system error occured. SQLSTATE=58004

When trying to start manually the service it didn't give me any further information.

Note: I've installed the Linux and the Windows 64bit versions successfully on other machines without any problems at all.

Any idea? (PLEASE HELP...)
Updated on 2012-11-07T15:57:12Z at 2012-11-07T15:57:12Z by SystemAdmin
  • dickr
    dickr
    31 Posts
    ACCEPTED ANSWER

    Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

    ‏2012-05-21T12:07:39Z  in response to SystemAdmin
    Have that all the time:
    db2start
    SQL1042C
    db2start (again)
    works :)

    So, keep on trying and check your db2diag.log file
    • SystemAdmin
      SystemAdmin
      5837 Posts
      ACCEPTED ANSWER

      Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

      ‏2012-05-21T12:40:37Z  in response to dickr
      Hi, tried few times... doesn't work.

      that's what I'm getting from db2diag after running db2start:

      **************************************************************

      2012-05-21-15.36.08.020000+180 I361675H436 LEVEL: Warning
      PID : 6396 TID : 3756 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 3756
      FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:12463
      MESSAGE : Released lock on the file:
      DATA #1 : String, 71 bytes
      C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY3\DB2_02\ctrl\db2strst.lck

      2012-05-21-15.38.03.645000+180 I362113H445 LEVEL: Event
      PID : 4860 TID : 7120 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 7120
      FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:12741
      MESSAGE : Obtained exclusive mode lock on the file:
      DATA #1 : String, 71 bytes
      C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY3\DB2_02\ctrl\db2strst.lck

      2012-05-21-15.38.03.661000+180 I362560H1579 LEVEL: Event
      PID : 4860 TID : 7120 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 7120
      FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
      DATA #1 : String, 41 bytes
      C:\PROGRA~1\IBM\SQLLIB~2\bin\DB2STAR2.EXE
      DATA #2 : Hexdump, 256 bytes
      0x001236B0 : 433A 5C50 524F 4752 417E 315C 4942 4D5C C:\PROGRA~1\IBM\
      0x001236C0 : 5351 4C4C 4942 7E32 5C62 696E 5C44 4232 SQLLIB~2\bin\DB2
      0x001236D0 : 5354 4152 322E 4558 4500 0000 0000 0000 STAR2.EXE.......
      0x001236E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x001236F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123700 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123710 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123720 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123730 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123740 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123750 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123760 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123770 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123780 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x00123790 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
      0x001237A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

      2012-05-21-15.38.04.051000+180 I364141H445 LEVEL: Event
      PID : 6648 TID : 6188 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 6188
      FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:12741
      MESSAGE : Obtained exclusive mode lock on the file:
      DATA #1 : String, 71 bytes
      C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY3\DB2_02\ctrl\db2stst.0000

      2012-05-21-15.38.05.989000+180 E364588H383 LEVEL: Warning
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912
      FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:18
      DATA #1 : String, 28 bytes
      Memory usage is limited to:
      DATA #2 : signed integer, 8 bytes
      4294967296

      2012-05-21-15.38.06.004000+180 I364973H566 LEVEL: Event
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
      START : Starting FCM Buffer Manager
      1 resource group(s).
      128 buffers allocated.
      Maximum number of buffers supported is 8192.
      Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 860172 bytes.

      2012-05-21-15.38.06.004000+180 I365541H575 LEVEL: Event
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
      START : Starting FCM Channel Manager
      1 resource group(s).
      1024 channels allocated.
      Maximum number of channels supported is 8192.
      Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 1126416 bytes.

      2012-05-21-15.38.06.004000+180 I366118H572 LEVEL: Event
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
      START : Starting FCM Session Manager
      1 resource group(s).
      128 sessions allocated.
      Maximum number of sessions supported is 64000.
      Total session manager memory required for 1 logical and 0 fail-over partitions is 1667072 bytes.

      2012-05-21-15.38.06.020000+180 I366692H450 LEVEL: Event
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
      START : FCM infrastructure started
      FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4

      2012-05-21-15.38.06.020000+180 I367144H952 LEVEL: Error
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 Common, Cryptography, cryptDynamicLoadGSKitCrypto, probe:998
      MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
      Cannot load the specified library
      DATA #1 : unsigned integer, 4 bytes
      70
      DATA #2 : String, 45 bytes
      C:\PROGRA~1\IBM\SQLLIB~2\bin\icc\gsk8iccs.dll
      CALLSTCK:
      [0] 0x6D361329 sqloGetProfKey + 0x4A5F9
      [1] 0x6DD8380A ossLog + 0xDA
      [2] 0x6DD83784 ossLog + 0x54
      [3] 0x032BE8D9 sqlucPdLog + 0x8E7699
      [4] 0x0267B0CA cryptDecryptBuffer + 0x42A
      [5] 0x0267AF4E cryptDecryptBuffer + 0x2AE
      [6] 0x01B17CA7 sqloRunInstance + 0x187
      [7] 0x00402009 0x00402009 + 0x0
      [8] 0x004014CC 0x004014CC + 0x0
      [9] 0x7C80B729 GetModuleFileNameA + 0x1BA

      2012-05-21-15.38.06.020000+180 I368098H779 LEVEL: Error
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 Common, Cryptography, cryptContextInit, probe:105
      MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
      Cannot load the specified library
      DATA #1 : Hex integer, 4 bytes
      0x90000076
      CALLSTCK:
      [0] 0x6D361329 sqloGetProfKey + 0x4A5F9
      [1] 0x6DD8380A ossLog + 0xDA
      [2] 0x6DD83784 ossLog + 0x54
      [3] 0x032BE492 sqlucPdLog + 0x8E7252
      [4] 0x01B17CA7 sqloRunInstance + 0x187
      [5] 0x00402009 0x00402009 + 0x0
      [6] 0x004014CC 0x004014CC + 0x0
      [7] 0x7C80B729 GetModuleFileNameA + 0x1BA

      2012-05-21-15.38.06.036000+180 I368879H423 LEVEL: Severe
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:50
      MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
      Cannot load the specified library

      2012-05-21-15.38.06.036000+180 I369304H526 LEVEL: Severe
      PID : 6648 TID : 4912 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 4912 EDUNAME: db2sysc
      FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1884
      MESSAGE : SQL1042C An unexpected system error occurred.
      CALLED : DB2 UDB, oper system services, sqloRunInstance
      RETCODE : ZRC=0x870F00CD=-2029059891=SQLO_UNEXPECTED_SYSERR
      "Unexpected System Error"

      2012-05-21-15.38.06.067000+180 I369832H436 LEVEL: Warning
      PID : 6648 TID : 6188 PROC : db2syscs.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 6188
      FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:12463
      MESSAGE : Released lock on the file:
      DATA #1 : String, 71 bytes
      C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY3\DB2_02\ctrl\db2stst.0000

      2012-05-21-15.38.06.270000+180 E370270H455 LEVEL: Severe
      PID : 4860 TID : 7120 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 7120
      FUNCTION: DB2 UDB, oper system services, sqloStartDB2Service, probe:50
      DATA #1 : <preformatted>
      Service start error.
      Service name: DB2_02
      Machine name: (null)
      Error: DB2_02 : The service has returned a service-specific error code.

      2012-05-21-15.38.06.270000+180 E370727H383 LEVEL: Severe
      PID : 4860 TID : 7120 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 7120
      FUNCTION: DB2 UDB, oper system services, sqloStartDB2Service, probe:51
      DATA #1 : <preformatted>
      Service start arg: C:\PROGRA~1\IBM\SQLLIB~2\bin\DB2STAR2.EXE DATA

      2012-05-21-15.38.06.270000+180 I371112H390 LEVEL: Severe
      PID : 4860 TID : 7120 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 7120
      FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:9440
      DATA #1 : String, 67 bytes
      DB2_02 : The service has returned a service-specific error code.
      2012-05-21-15.38.06.286000+180 I371504H436 LEVEL: Warning
      PID : 4860 TID : 7120 PROC : db2start.exe
      INSTANCE: DB2_02 NODE : 000
      HOSTNAME: AMIRM-PS
      EDUID : 7120
      FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:12463
      MESSAGE : Released lock on the file:
      DATA #1 : String, 71 bytes
      C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY3\DB2_02\ctrl\db2strst.lck

      **************************************************************************
      Any other idea?
      • dickr
        dickr
        31 Posts
        ACCEPTED ANSWER

        Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

        ‏2012-05-21T13:28:47Z  in response to SystemAdmin
        All kind of "crypto" messages. Is your disk encrypted?
        • SystemAdmin
          SystemAdmin
          5837 Posts
          ACCEPTED ANSWER

          Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

          ‏2012-05-22T09:21:42Z  in response to dickr
          Yes, PGP encrypted.

          I also have a Win7 64bit machine with PGP encryption but didn't see any problems there...
          • dickr
            dickr
            31 Posts
            ACCEPTED ANSWER

            Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

            ‏2012-05-30T09:49:12Z  in response to SystemAdmin
            And that win7-64 machine is also running db2? The encryption is causing your errors. Cannot help you with that, sorry.
            • SystemAdmin
              SystemAdmin
              5837 Posts
              ACCEPTED ANSWER

              Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

              ‏2012-07-25T13:32:43Z  in response to dickr
              We resolved this problem by adding c:\program files\ibm\gsk8\lib to the PATH environment variable.
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: DB2 ExpressC v.10.1 doesn't work on Windows xp 32bit (?)

    ‏2012-07-26T06:15:03Z  in response to SystemAdmin
    We resolved this problem by adding c:\program files\ibm\gsk8\lib to the PATH environment variable.
    • SystemAdmin
      SystemAdmin
      5837 Posts
      ACCEPTED ANSWER

      DB2 ExpressC v.10.1 doesn't work on Windows 7 64 Bit

      ‏2012-11-07T15:57:12Z  in response to SystemAdmin
      Whenever you type the command db2start if the following error is displayed

      DB2 : The service has returned a service-specific error code.

      SQL1042C An unexpected system error occurred. SQLSTATE=58004

      Create icc64 directory in C:\Program Files\IBM\SQLLIB\BIN\ and copy the contents of C:\Program Files\IBM\gsk8\lib64 to C:\Program Files\IBM\SQLLIB\BIN\icc64 directory (copy only the contents of lib64 directory and also make sure you copy all the contents of lib64 directory)