IBM Support

IC77604: TRAP IN SQLEINITAPPLICATIONENVIRONMENT WHEN DB2_MEMORY_PROTECT AND POWER 7 IS USED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Call to a trusted function could trap if POWER 7 is used and DB2
    registry DB2_MEMORY_PROTECT  is set.
    Stack will have the following:
    0x090000000AE80038 sqleInitApplicationEnvironment__FiUiT2P5sqlca
    + 0x118
    0x090000000AE7FC78 sqleCommonInitializationForAPIs + 0x58
    0x090000000B977B4C sqllcUpdateUsageAPI + 0x1EC
    0x09000000236A56F4 gsege_init__FR8GseError + 0x114
    0x09000000238768F8 gseArea + 0x758
    0x090000001A0BDCF4 sqloInvokeFnArgs + 0xBF4
    0x090000001A107BF4 sqloInvokeUDF + 0x234
    0x090000001B4DFC28
    sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
    0xE08
    0x090000001B4D8BC0 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x1A60
    0x090000001B4D6F08 sqlriusf__FP8sqlrr_cb + 0x268
    0x090000001DAF84A8 sqlriNljnPiped__FP8sqlrr_cb + 0x5E8
    0x090000001B14DF78 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x298
    0x090000001C29A0E0 sqlrr_dss_router__FP8sqlrr_cb + 0x820
    0x090000001C299120
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xEA0
    0x090000001C289BC0 sqleSubRequestRouter__FP8sqeAgentPUiT2 +
    0xA40
    0x090000001C284E40 sqleProcessSubRequest__FP8sqeAgent + 0x360
    0x090000001A1A8300 RunEDU__8sqeAgentFv + 0x960
    0x090000001A19ACA4 EDUDriver__9sqzEDUObjFv + 0x284
    0x090000001A19A9D0 sqlzRunEDU__FPcUi + 0x10
    0x090000001A10906C sqloEDUEntry + 0x2CC
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 on POWER7 and DB2_MEMORY_PROTECT set                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * TRAP IN SQLEINITAPPLICATIONENVIRONMENT when                  *
    * DB2_MEMORY_PROTECT AND POWER 7 is used.                      *
    * Call to a trusted function could trap if POWER 7 is used and *
    * DB2 registry DB2_MEMORY_PROTECT  is set.                     *
    * Stack will have the following:                               *
    * 0x090000000AE80038                                           *
    * sqleInitApplicationEnvironment__FiUiT2P5sqlca + 0x118        *
    * 0x090000000AE7FC78 sqleCommonInitializationForAPIs + 0x58    *
    * 0x090000000B977B4C sqllcUpdateUsageAPI + 0x1EC               *
    * 0x09000000236A56F4 gsege_init__FR8GseError + 0x114           *
    * 0x09000000238768F8 gseArea + 0x758                           *
    * 0x090000001A0BDCF4 sqloInvokeFnArgs + 0xBF4                  *
    * 0x090000001A107BF4 sqloInvokeUDF + 0x234                     *
    * 0x090000001B4DFC28                                           *
    * sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf  *
    * + 0xE08                                                      *
    * 0x090000001B4D8BC0 sqlriInvokeInvoker__FP10sqlri_ufobb +     *
    * 0x1A60                                                       *
    * 0x090000001B4D6F08 sqlriusf__FP8sqlrr_cb + 0x268             *
    * 0x090000001DAF84A8 sqlriNljnPiped__FP8sqlrr_cb + 0x5E8       *
    * 0x090000001B14DF78                                           *
    * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x298          *
    * 0x090000001C29A0E0 sqlrr_dss_router__FP8sqlrr_cb + 0x820     *
    * 0x090000001C299120                                           *
    * sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xEA0    *
    * 0x090000001C289BC0 sqleSubRequestRouter__FP8sqeAgentPUiT2 +  *
    * 0xA40                                                        *
    * 0x090000001C284E40 sqleProcessSubRequest__FP8sqeAgent +      *
    * 0x360                                                        *
    * 0x090000001A1A8300 RunEDU__8sqeAgentFv + 0x960               *
    * 0x090000001A19ACA4 EDUDriver__9sqzEDUObjFv + 0x284           *
    * 0x090000001A19A9D0 sqlzRunEDU__FPcUi + 0x10                  *
    * 0x090000001A10906C sqloEDUEntry + 0x2CC                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Install this APAR or turn DB2_MEMORY_PROTECT  off.           *
    ****************************************************************
    

Problem conclusion

  • Call to a trusted function could trap if POWER 7 is used and DB2
    registry DB2_MEMORY_PROTECT  is set.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77604

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-18

  • Closed date

    2011-12-07

  • Last modified date

    2011-12-07

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 December 2011