Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    14

    Unanswered: db2fmp process high CPU utilization

    HI All,

    I see db2fmp using high CPU,

    PID %CPU Size Res Res Res Char RAM Paging Command │
    │ Used KB Set Text Data I/O Use io other repage │
    │45096028 170.1 41664 41688 32 41656 0 0% 0 0 0 db2fmp │
    │50866938 112.8 1341272 1341280 128 1341152 17364 1% 14 19 0 db2sysc

    and also I see below error in diaglog very frequent

    2012-03-01-17.45.06.951470+000 E11120361A397 LEVEL: Error
    PID : 55050292 TID : 258 PROC : db2wdog 0
    INSTANCE: db2ecp NODE : 000
    EDUID : 258 EDUNAME: db2wdog 0
    FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:15
    DATA #1 : <preformatted>
    A non-EDU child crashed. Process id: 62202406, OSS term code: 0x102, signal: 9

    2012-03-01-17.45.07.092465+000 I11120759A452 LEVEL: Error
    PID : 16848712 TID : 1290 PROC : db2fmp (C) 0
    INSTANCE: db2ecp NODE : 000
    EDUID : 1290 EDUNAME: db2fmp (C) 0
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
    MESSAGE : FMP exiting with error. Last agent registered:
    DATA #1 : Hexdump, 4 bytes
    0x000000011115EE58 : 0001 0F4E ...N

    2012-03-01-17.45.07.535468+000 I11121212A452 LEVEL: Error
    PID : 16848712 TID : 844 PROC : db2fmp (C) 0
    INSTANCE: db2ecp NODE : 000
    EDUID : 844 EDUNAME: db2fmp (C) 0
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
    MESSAGE : FMP exiting with error. Last agent registered:
    DATA #1 : Hexdump, 4 bytes
    0x0000000110F53E58 : 0000 F35F ..._

    2012-03-01-17.45.07.535739+000 I11121665A1185 LEVEL: Error
    PID : 50866938 TID : 62303 PROC : db2sysc 0
    INSTANCE: db2ecp NODE : 000 DB : ECP
    APPHDL : 0-62601 APPID: *LOCAL.db2ecp.120301174513
    AUTHID : DB2ECP
    EDUID : 62303 EDUNAME: db2agent (ECP) 0
    FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
    MESSAGE : Sending SIGKILL to the following process id
    DATA #1 : signed integer, 4 bytes
    15930656
    CALLSTCK:
    [0] 0x0900000013F801AC pdLog + 0xC0
    [1] 0x0900000010A19D60 pdLog@glue420 + 0xD0
    [2] 0x0900000010261CCC sqlossig + 0xDC
    [3] 0x0900000012EC87C0 sqlossig@glue647 + 0x88
    [4] 0x09000000103EEA58 sqlerReturnFmpToPool__FcT1P14sqlerFmpHandleP8sqeAg ent + 0x66C
    [5] 0x0900000013D39F3C sqlerReturnFmpToPool__FcT1P14sqlerFmpHandleP8sqeAg ent@glue60F + 0x80
    [6] 0x0900000010CD2920 sqlri_close_udf_ufob_cleanup__FP10sqlri_ufobP5sqlc aP8sqlrr_cb + 0xAC
    [7] 0x0900000013F3668C sqlri_close_udf_eos__FP25sqlra_sql_context_sibling iP8sqlrr_cb + 0x138
    [8] 0x0900000013F38C60 sqlricls_simple__FP8sqlrr_cbil + 0x6EC
    [9] 0x0900000013F40BDC sqlrr_process_execute_request__FP8sqlrr_cbi + 0x820


    Please urgent help needed,

    Regards
    Bond

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Whatever code is being executed in the db2fmp (fenced mode process) causes a crash of the process. Do you run any UDFs or stored procedures by any chance?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Dec 2011
    Posts
    14
    stolze

    We are using DB2 with SAP, we dont run any explicit UDF or stored procedures,

    i am unable to select D(dynamic Sqls) in db2top it hangs

    Regards
    Bond

Posting Permissions

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