IBM Support

IT05039: SLOW PERFORMANCE OF BUILD PHASE OF LOAD AFTER FIXPACK UPGRADE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Slow performance of Build phase of load after fixpack upgrade
    when the number of rows is at certain size.  With 10 million
    records, fp9 is faster than f7.  When using 36 million rows, fp9
    shows slower in the build phase.
    
    Rel 	SHEAPTHRES 	SHEAPTHRES_SHR 	SORTHEAP
    	SHEAPTHRES/sortheap 	SHEAPTHRES_SHR/sortheap 	Load Time
    	Build Time
    
    v97fp7 	7000000 	1000000 	250000 	  	28 	4 	2535 	  	3758
    v97fp7 	4000000 	1000000 	125000 	  	32 	8 	2588 	  	3873
    v97fp7 	2000000 	1000000 	62500 	  	32 	16 	2598 	  	3605
    v97fp7 	4000000 	4000000 	125000 	  	32 	32 	2587 	  	3758
    v97fp7 	2000000 	2000000 	62500 	  	32 	32 	2603 	  	3859
    
    v97fp9 	7000000 	1000000 	250000 	  	28 	4 	2469 	  	3962
    v97fp9 	4000000 	1000000 	125000 	  	32 	8 	2496 	  	3625
    v97fp9 	2000000 	1000000 	62500 	  	32 	16 	2511 	  	4345
    v97fp9 	4000000 	4000000 	125000 	  	32 	32 	2510 	  	3625
    v97fp9 	2000000 	2000000 	62500 	  	32 	32 	2535 	  	4112
    v97fp9 	5000000 	4000000 	125000 	  	40 	32 	2518 	  	4365
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Affects all server versions of DB2                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fix Pack 11 or higher.                   *
    ****************************************************************
    

Problem conclusion

  • DB2 sorting code will perform more caching of small rows to
    amortize cost of spill operations.
    
    First fixed in DB2 V9.7 Fix Pack 11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT05039

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-10-20

  • Closed date

    2015-10-19

  • Last modified date

    2015-10-19

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

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

    IT13326 IT13355

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
19 October 2015