IBM Support

JR30607: DB2 9.5 ON WINDOWS CREATE DATABASE RESULTS IN DB2FMP64 PROCESS NOT KILLED AFTER DB2STOP AND SQL1042N WHEN RUNNING DB2START

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SAP installations of version 9.5 use a sapinst script
    which creates a database and then stops and restarts the
    instance. This will fail with an db2fmp64 process left in the
    box after a db2stop which will produce the following messages on
    db2start:
    
    -------------------------------------------------
    2008-05-26-11.18.24.405000+120 I58081F330         LEVEL: Severe
    PID     : 3484                 TID  : 4212        PROC :
    db2syscs.exe
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4212                 EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, oper system services, sqloRunInstance,
    probe:80
    MESSAGE : ZRC=0xFFFFFBEE=-1042
    
    2008-05-26-11.18.24.405000+120 I58413F437         LEVEL: Severe
    PID     : 3484                 TID  : 4212        PROC :
    db2syscs.exe
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4212                 EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:115
    MESSAGE : SQL1042C  An unexpected system error occurred.
    CALLED  : DB2 UDB, oper system services, sqloRunInstance
    RETCODE : ZRC=0xFFFFFBEE=-1042
    
    2008-05-26-11.18.24.483000+120 I58852F697         LEVEL: Severe
    PID     : 4352                 TID  : 4300        PROC :
    db2start.exe
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4300
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode,
    probe:70
    DATA #1 : Hexdump, 69 bytes
    0x0000000000129A70 : 4442 3244 3239 2D30 203A 2054 6865 2073
    DB2D29-0 : The s
    0x0000000000129A80 : 6572 7669 6365 2068 6173 2072 6574 7572
    ervice has retur
    0x0000000000129A90 : 6E65 6420 6120 7365 7276 6963 652D 7370
    ned a service-sp
    0x0000000000129AA0 : 6563 6966 6963 2065 7272 6F72 2063 6F64
    ecific error cod
    0x0000000000129AB0 : 652E 0D0A 0A
    e....
    
    2008-05-26-11.18.24.717000+120 I59551F1686        LEVEL: Event
    PID     : 4980                 TID  : 4348        PROC :
    DB2START.EXE
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4348
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode,
    probe:1130
    DATA #1 : String, 44 bytes
    F:\db2\db2d29\db2_software\\bin\DB2STAR2.EXE
    DATA #2 : Hexdump, 256 bytes
    0x0000000000129D70 : 463A 5C64 6232 5C64 6232 6432 395C 6462
    F:\db2\db2d29\db
    0x0000000000129D80 : 325F 736F 6674 7761 7265 5C5C 6269 6E5C
    2_software\\bin\
    0x0000000000129D90 : 4442 3253 5441 5232 2E45 5845 004E 4F4D
    DB2STAR2.EXE.NOM
    0x0000000000129DA0 : 5347 0000 0000 0000 0000 0000 0000 0000
    SG..............
    0x0000000000129DB0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DC0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DD0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DE0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DF0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E00 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E10 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E20 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E30 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E40 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E50 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E60 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    
    -------------------------------------------------
    
    To reproduce the problem:
    
    db2 update dbm cfg using KEEPFENCED NO
    db2start
    At this point we have one db2fmp64 process PID A
    
    db2 create database test
    At this point we have one db2fmp64 process PID B
    
    db2stop
    
    PID A goes down OK. PID B stays on the machine, hence failure on
    db2start after this.
    

Local fix

  • Kill db2fmp64 process with the task manager or use
    
    db2 update dbm cfg using KEEPFENCED YES previously to creating a
    database.
    

Problem summary

  • USERS AFFECTED: ALL
    PROBLEM DESCRIPTION:DB2 9.5 ON WINDOWS CREATE DATABASE RESULTS
    IN DB2FMP64 PROCESS
    NOT KILLED AFTER DB2STOP AND SQL1042N WHEN RUNNING DB2START
    PROBLEM SUMMARY:
    ERROR DESCRIPTION:
    SAP installations of version 9.5 use a sapinst script
    which creates a database and then stops and restarts the
    instance. This will fail with an db2fmp64 process left in the
    box after a db2stop which will produce the following messages on
    db2start:
    
    -------------------------------------------------
    2008-05-26-11.18.24.405000+120 I58081F330         LEVEL: Severe
    PID     : 3484                 TID  : 4212        PROC :
    db2syscs.exe
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4212                 EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, oper system services, sqloRunInstance,
    probe:80
    MESSAGE : ZRC=0xFFFFFBEE=-1042
    
    2008-05-26-11.18.24.405000+120 I58413F437         LEVEL: Severe
    PID     : 3484                 TID  : 4212        PROC :
    db2syscs.exe
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4212                 EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:115
    MESSAGE : SQL1042C  An unexpected system error occurred.
    CALLED  : DB2 UDB, oper system services, sqloRunInstance
    RETCODE : ZRC=0xFFFFFBEE=-1042
    
    2008-05-26-11.18.24.483000+120 I58852F697         LEVEL: Severe
    PID     : 4352                 TID  : 4300        PROC :
    db2start.exe
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4300
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode,
    probe:70
    DATA #1 : Hexdump, 69 bytes
    0x0000000000129A70 : 4442 3244 3239 2D30 203A 2054 6865 2073
    DB2D29-0 : The s
    0x0000000000129A80 : 6572 7669 6365 2068 6173 2072 6574 7572
    ervice has retur
    0x0000000000129A90 : 6E65 6420 6120 7365 7276 6963 652D 7370
    ned a service-sp
    0x0000000000129AA0 : 6563 6966 6963 2065 7272 6F72 2063 6F64
    ecific error cod
    0x0000000000129AB0 : 652E 0D0A 0A
    e....
    
    2008-05-26-11.18.24.717000+120 I59551F1686        LEVEL: Event
    PID     : 4980                 TID  : 4348        PROC :
    DB2START.EXE
    INSTANCE: DB2D29               NODE : 000
    EDUID   : 4348
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode,
    probe:1130
    DATA #1 : String, 44 bytes
    F:\db2\db2d29\db2_software\\bin\DB2STAR2.EXE
    DATA #2 : Hexdump, 256 bytes
    0x0000000000129D70 : 463A 5C64 6232 5C64 6232 6432 395C 6462
    F:\db2\db2d29\db
    0x0000000000129D80 : 325F 736F 6674 7761 7265 5C5C 6269 6E5C
    2_software\\bin\
    0x0000000000129D90 : 4442 3253 5441 5232 2E45 5845 004E 4F4D
    DB2STAR2.EXE.NOM
    0x0000000000129DA0 : 5347 0000 0000 0000 0000 0000 0000 0000
    SG..............
    0x0000000000129DB0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DC0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DD0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DE0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129DF0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E00 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E10 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E20 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E30 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E40 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E50 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000000000129E60 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    
    -------------------------------------------------
    
    To reproduce the problem:
    
    db2 update dbm cfg using KEEPFENCED NO
    db2start
    At this point we have one db2fmp64 process PID A
    
    db2 create database test
    At this point we have one db2fmp64 process PID B
    
    db2stop
    
    PID A goes down OK. PID B stays on the machine, hence failure on
    db2start after this.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30607

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-29

  • Closed date

    2009-05-29

  • Last modified date

    2009-05-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 May 2009