IBM Support

LI73881: RESTORE FROM BACKUP SLOW AT V9.5 COMPARED TO V8

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Restore from backup is much slower at V9.
    
    Restore from backup is much slower at V9 compared to V8.
    The actual difference in restore time is dependent on type of
    hardware, OS and the type of filesystem, but typically may take
    longer to restore by a factor of 2.  Journally filesystems such
    as jfs2 , ext3 are more likely to show the problem but it is not
    confined to these filesystem types.
    

Local fix

  • Using a non journally type of filesystem may improve
    performance.
    Using DMS containers may improve performance.
    Use raw device DMS containers
    

Problem summary

  • Users Affected:
    Db2 users restoring a database with system managed tablespaces
    into journalled type filesystems.
    Problem Description:
    Restore from backup is much slower at V9.
    
    Restore from backup is much slower at V9 compared to V8.
    The actual difference in restore time is dependent on type of
    hardware, OS and the type of filesystem, but typically may take
    longer to restore by a factor of 2.  Journally filesystems such
    as jfs2 , ext3 are more likely to show the problem but it is not
    confined to these filesystem types.
    
    Problem Summary:
    Potentially slow restore from backup compared to V8 if
    journalled type filesystems are being used.
    

Problem conclusion

  • First fixed in DB2 UDB Version V9.5 Fixpak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73881

  • Reported component name

    DB2 UDB WSE LIN

  • Reported component ID

    5765F3504

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-17

  • Closed date

    2009-05-29

  • Last modified date

    2009-05-29

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

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

    LI74100

Fix information

  • Fixed component name

    DB2 UDB WSE LIN

  • Fixed component ID

    5765F3504

Applicable component levels

  • R950 PSY

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

Document Information

Modified date:
29 May 2009