IBM Support

LI72642: ENGINE SEGVS WHEN ATTEMPTS TO DUMP BINARY DATA FOR IDLE SUBAGENTS IN FEDERATED ENV.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Engine SEGVs when attempts to dump binary data for idle
    subagents in federated env.
    
    For the SEGV inside binary write, the stack for SEGV will be :
    
    0000002A9A92B968 ossDumpStackTrace + 0x0080
                    (/home/nycsrdi2/sqllib/lib64/libdb2osse.so.1)
    0000002A9A92962C _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
                    (/home/nycsrdi2/sqllib/lib64/libdb2osse.so.1)
    0000002A97A67C13 sqlo_trce + 0x033b
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A96937E64 sqloEDUCodeTrapHandler + 0x0074
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    000000340F90C320 __libc_sigaction + 0x0090
                    (/lib64/tls/libpthread.so.0)
    0000002A96259E84 _Z16sqlqgGetDjTranCBP20sqle_agent_privatecb +
    0x0004
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A964385E3 _Z20sqlqg_dump_ctrl_blksv + 0x014b
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A978DAC77 _Z20sqlqg_signal_handleri + 0x004f
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A960FE681 sqloExecuteEDUExitList + 0x0131
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A9693815B sqloDumpDiagInfoHandler + 0x0193
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    000000340F90C320 __libc_sigaction + 0x0090
                    (/lib64/tls/libpthread.so.0)
    000000340DFC6F19 semop + 0x0009
                    (/lib64/tls/libc.so.6)
    0000002A96486028 sqloWaitEDUWaitPost + 0x0130
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A9605D148
    _Z24sqleWaitUntilReactivatedP13sqle_agent_cbPiPh + 0x0560
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A9605BC1E _Z12sqleRunAgentPcj + 0x0206
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A960FE01C _Z13sqloCreateEDUPFvPcjES_mP13SQLO_EDU_INFOPi +
    0x01fc
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A960FDAF3 sqloIPCSignature + 0x022b
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A960FD5DA sqloInitEDUServices + 0x016a
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    0000002A960FA6D7 sqloRunInstance + 0x0927
                    (/home/nycsrdi2/sqllib/lib64/libdb2e.so.1)
    
    
    To reproduce:
    
    - Setup EEE instance with >1 logical nodes.
    - Create sample db.
    - Enable federated:
        db2 update dbm cfg using FEDERATED yes
    - Activate db, connect to it and run:
        db2 "select * from sample"
    - Issue db2pd -allbpd -dump all. Engine might crash.
    

Local fix

Problem summary

  • Users affected: Users of DB2 Homogeneous Federation Feature or
    WebSphere Federation Server
    
    Problem description and summary:
    See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5, FixPak 1 (s080328).
    This fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI72642

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-10-31

  • Closed date

    2008-04-22

  • Last modified date

    2008-04-22

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

    LI72444

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       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:
22 April 2008