IBM Support

IT32033: DB2DART RECEIVES SIGNAL #11 DUE TO TOO MANY TABLESPACES AND OR CONTAINERS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2dart might fail with signal #11 (segmentation fault) when it
    inspects all contents in the table space information files
    SQLSPCS.1 and SQLSPCS.2, and there are too many tablespaces and
    or containers in them.
    
    It will have a stack similar to the following:
    
    SqloMemController::dumpOnOOM(const unsigned int,bool)(??, ??,
    ??) at 0x900000019b66844
    sqloMemLogPoolConditions(??, ??, ??, ??) at 0x900000019b53b38
    sqloGetMemoryBlockExtended(0x11010d6b8, 0x34000, 0x24c, 0x0,
    0x0, 0x0, 0x1f5) at 0x900000019b4f568
    sqlbReadPoolOneFile(SQLO_FHANDLE&,long,SQLO_MEM_POOL*,SQLB_POOL_
    CB**,bool,SQLB_GLOBALS*)(0x3, 0xbd300000, 0x10000000100, 0x0,
    0x0, 0x0) at 0x90000001abb8890
    DartCheckPoolTable(SQLB_GLOBALS*,DartControlStruct*,SQLO_FHANDLE
    *)(??, ??, ??) at 0x1000d9e28
    DartMGRInspectDB(SQLB_GLOBALS*,DartControlStruct*,SQLO_FHANDLE*)
    (??, ??, ??) at 0x10000e2b0
    DartMGRMain(??) at 0x10000cfd8
    main(??, ??) at 0x1000022bc
    

Local fix

  • Avoid db2dart actions that inspect the whole table space
    information files.
    
    A workaround is to use option /QCK 8 to only inspect one table
    space to avoid segmentation fault (signal #11). Note /QCK 8
    applies to /T and /TS actions. /TS action requires table space
    id to be run, thus multiple iterations will need to be used to
    inspect the entire database.
    
    
    db2dart SAMPLE /TS /TSI 1 /QCK 8 /RPT /tmp /RPTN ts1_db2dart.out
    
    Database = SAMPLE
    Tablespace ID = 1
    Outputs file to /tmp/ts1_db2dart.out
    
    Tablespace names and ids are displayed as "Id" from "db2pd -db
    sample -tablespaces" command.
    
    Tablespace Configuration:
    Address            Id .... Name
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * db2dart                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply v11.1 Mod 4 Fixpack 6 to the DB2 database server       *
    ****************************************************************
    

Problem conclusion

  • First fixed in v11.1 Mod 4 Fixpack 6
    

Temporary fix

  • See LOCAL FIX
    

Comments

APAR Information

  • APAR number

    IT32033

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-28

  • Closed date

    2021-03-29

  • Last modified date

    2021-03-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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022