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

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  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 UDB V9.1 users on Linux/unix/windows platform            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * 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.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to V9.1 FP9 or later to correct this problem.         *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in DB2 Version 9.1 Fix Pack 9
  

Temporary fix

Comments

APAR Information

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

  LI73881

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

Modules/Macros

• SQB
  

Fix information

• Fixed component name

  DB2 UDB WSE LIN

• Fixed component ID

  5765F3504

Applicable component levels

• R910 PSN

     UP