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

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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