IBM Support

LI73174: DATABASE IS MARKED BAD AFTER ITS SMS USER TEMP TABLESPACE HITS DISK FULL AND ROLLBACK FAILS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After a SMS user temp tablespace hits disk full, a rollback
    operation starts. During rollback if the victim pages belong to
    the same full user temp table space, the page may not be
    flushed. This will cause database to be marked as bad.
    
    db2diag.log would have some messages similar to the following:
    
    2008-02-12-15.03.27.304837-300 I113965216E457     LEVEL: Error
    PID     : 23582                TID  : 183030155104PROC :
    db2agent (NYCMPI03) 0
    INSTANCE: nycmpi03             NODE : 000         DB   :
    NYCMPI03
    APPHDL  : 0-1996               APPID:
    10.224.0.150.46220.080212195442
    AUTHID  : GCTDEGL
    FUNCTION: DB2 UDB, data protection services, sqlptudo,
    probe:1710
    RETCODE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
              DIA8312C Disk was full.
    
    ................................
    
    2008-02-12-15.03.27.305695-300 I113966889E431     LEVEL: Severe
    PID     : 23582                TID  : 183030155104PROC :
    db2agent (NYCMPI03) 0
    INSTANCE: nycmpi03             NODE : 000         DB   :
    NYCMPI03
    APPHDL  : 0-1996               APPID:
    10.224.0.150.46220.080212195442
    AUTHID  : GCTDEGL
    FUNCTION: DB2 UDB, data protection services, sqlptud1,
    probe:1880
    MESSAGE : Due to error during UNDO, database will be brought
    down.
    
    2008-02-12-15.03.27.305835-300 I113967321E480     LEVEL: Error
    PID     : 23582                TID  : 183030155104PROC :
    db2agent (NYCMPI03) 0
    INSTANCE: nycmpi03             NODE : 000         DB   :
    NYCMPI03
    APPHDL  : 0-1996               APPID:
    10.224.0.150.46220.080212195442
    AUTHID  : GCTDEGL
    FUNCTION: DB2 UDB, data protection services, sqlpSpRb, probe:50
    DATA #1 : String, 91 bytes
    Failed to rollback to savepoint. Error code: -2062614516
    Request rollback savepoint type: 1
    
    .......................
    
    2008-02-12-15.03.25.780780-300 E113250644E403     LEVEL: Severe
    PID     : 23582                TID  : 183030155104PROC :
    db2agent (NYCMPI03) 0
    INSTANCE: nycmpi03             NODE : 000         DB   :
    NYCMPI03
    APPHDL  : 0-1996               APPID:
    10.224.0.150.46220.080212195442
    AUTHID  : GCTDEGL
    FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
    MESSAGE : ADM7518C  "NYCMPI03" marked bad.
    
    
    The final stack dump of the above db2agent would be similar to
    the following:
    
    ---FUNC-ADDR---- ------FUNCTION + OFFSET------
    0000002A9A9F2140 ossDumpStackTrace + 0x0080
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2osse.so.1)
    0000002A9A9EFE04 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2osse.so.1)
    0000002A97AAE9FB sqlo_trce + 0x033b
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A96959858 sqloDumpDiagInfoHandler + 0x0098
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000003D4AE0C430 do_sigwait + 0x0050
                    (/lib64/tls/libpthread.so.0)
    0000003D4942E829 kill + 0x0009
                    (/lib64/tls/libc.so.6)
    0000002A96959D73 sqloDumpEDU + 0x000b
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A967699B2 _Z12sqleMarkDBadP8sqledbcb + 0x0102
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A96666278
    _Z15sqldDumpContextP20sqle_agent_privatecbiiiiiPcPvi + 0x0500
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A96024D7F
    _Z8sqldmundP20sqle_agent_privatecbP8SQLP_LSNPcjsjP8SQLP_TIDP15SQ
    LD_RECOV_INFO + 0x062f
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A9629F49C
    _Z8sqlptudoP20sqle_agent_privatecbP9SQLP_LSN8P15SQLD_RECOV_INFOP
    11SQLP_TENTRY + 0x0174
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A9629EB29 _Z8sqlptud1P20sqle_agent_privatecbP9SQLP_LSN8 +
    0x0219
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A971433FA _Z8sqlpSpRbP20sqle_agent_privatecbim + 0x0252
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A9724100D
    _Z19sqlrr_stmt_rbk_svptP8sqlrr_cbP19sqlr_savepoint_infoi +
    0x010d
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A97C2DE40 _Z8sqlreespP8sqlrr_cbP19sqlr_savepoint_infoi +
    0x0450
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A97C2D4A8
    _Z15sqlr_end_saveptP8sqlrr_cbiijP19sqlr_savepoint_infoji +
    0x0098
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    0000002A97212814 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x05f4
                    (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
    

Local fix

  • Monitor disk space usage and avoid SMS tablespace hits disk full
    situation.
    

Problem summary

  • DATABASE IS MARKED BAD AFTER ITS SMS USER TEMP TABLESPACE HITS
    DISK FULL AND ROLLBACK FAILS.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 3
    

Temporary fix

  • Monitor disk space usage and avoid SMS tablespace hits disk full
    situation.
    

Comments

APAR Information

  • APAR number

    LI73174

  • 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

    2008-02-21

  • Closed date

    2009-04-07

  • Last modified date

    2009-04-07

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

    LI73164

  • 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

  • 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:
07 April 2009