IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
31 March 2021