IBM Support

IT13326: 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:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 10.1 Fix Pack 6                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 10.1 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT13326

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-01-22

  • Closed date

    2017-03-02

  • Last modified date

    2017-03-02

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

    IT05039

  • 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

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

Document Information

Modified date:
02 March 2017