IBM Support

LI72471: INSTANCE IS CRASHING WHEN CUSTOMER RUNS LOT OF DB2 RUNSTATS SET PROFILE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Instance is crashing when customer runs lot of db2 runstats with
    set profile option within a single file.
    
    Env: DB2 ESE v9 FP2 on zlinux
    
    Statement used is:
    
    runstats on table <table_name> ON ALL COLUMNS WITH DISTRIBUTION
    ON ALL COLUMNS AND DETAILED INDEXES ALL SET PROFILE ONLY;
    
    
    FUNCTION: DB2 UDB, relation data serv, sqlr_init_tstat,
    probe:160
    MESSAGE : ZRC=0x8B120006=-1961754618=SQLR_STATS_HEAP_TOO_SMALL
    "Statistics heap size too small to begin with"
    DIA8328C No memory available in the statistics heap.
    
    FUNCTION: DB2 UDB, relation data serv,
    sqlr_construct_stats_command,
    probe:20
    RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
    "No memory available in 'Application Heap'"
    DIA8301C No memory available in the application heap.
    
    Stack shows,
    sqlofmblkEx
    sqlr_construct_new_stats_profile
    sqlr_update_catalogs
    sqlrLocalRunstats
    
    
    Inspecting DB2 9 fixpak 2, the application heap memory was
    exhausted because for each RUNSTATS ... SET PROFILE ONLY we
    allocated 2000 bytes from the application heap and there is no
    other place to subsequently free that memory allocation.
    

Local fix

  • The possible workarounds are,
    increase the application heap size or split the runstat file.
    
    (This problem has been fixed in V9 FP4)
    

Problem summary

  • This problem has been fixed in V9 FP4
    

Problem conclusion

  • This problem has been fixed in V9 FP4
    

Temporary fix

  • The possible workarounds are,
    increase the application heap size or split the runstat file.
    

Comments

APAR Information

  • APAR number

    LI72471

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-06-26

  • Closed date

    2007-12-20

  • Last modified date

    2008-02-11

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

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

    IZ15362 LI73338

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSY

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

Document Information

Modified date:
07 January 2022