IBM Support

JR31267: INFORMIX ENTERPRISE STAGE IN TRUNCATE WRITE MODE IS TOO SLOW.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In Informix Enterprise stage, when Connection Method is Native
    or HPL and Write Method is Truncate, it shows very poor
    truncation performance compared to truncating using "truncate
    table" statement.
    
    For example, it takes only 2 seconds to truncating a table of
    1,350,000 rows. But the informix enterprise stage with above
    configuration, it  takes 9 minutes to truncate.
    
    infxwrite and hplwrite use "DELETE FROM" statement not "TRUNCATE
    TABLE" for truncate mode.
    xpswrite uses "TRUNCATE TABLE", which was implemented in ecase
    88797. Same implemetation expected for hplwrite and infxwrite.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    The issue is seen in Informix Enterprise stage, when Connection
    Method is Native or HPL and Write Method is Truncate in IS 801
    FP1
    ****************************************************************
    PROBLEM DESCRIPTION:
    In Informix Enterprise stage, when Connection Method is Native
    or HPL and Write Method is Truncate, it shows very poor
    truncation performance
    ****************************************************************
    RECOMMENDATION:
    Install patch_JR31267
    ****************************************************************
    

Problem conclusion

  • The issue is fixed in patch_JR31267
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31267

  • Reported component name

    INFO SRVR PLATF

  • Reported component ID

    5724Q3612

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-30

  • Closed date

    2009-01-20

  • Last modified date

    2009-01-20

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

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

Modules/Macros

  • INFX EE
    

Fix information

  • Fixed component name

    INFO SRVR PLATF

  • Fixed component ID

    5724Q3612

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2009