home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC65699 Status: Closed

Turning logarchmeth off will cause log file not to be reused.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Turning logarchmeth off will cause log files not to be reused if 
at the time database was activated 
and it found that at least one of the tablespaces is in either 
 
 - Load pending 
 - Delete pending 
 - Restore pending 
 - Recovery pending 
 - Disable pending 
 - Reorg in progress 
 - storage must be defined 
 - restore in progress 
 - offline and not accessible 
 - only action is drop 
 - redistribute in progress 
 - storeage may be defined 
 - storage Definition is in finla 
 - storage Deffinition was chaged prior to rollforward 
 - Tablespace in progression in progress 
 - tablespace creating in progress
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Turning logarchmeth off will cause log files not to be       * 
* reused if                                                    * 
* at the time database was activated                           * 
*                                                              * 
* and it found that at least one of the tablespaces is in      * 
* either                                                       * 
*                                                              * 
*                                                              * 
* - Load pending                                               * 
*                                                              * 
* - Delete pending                                             * 
*                                                              * 
* - Restore pending                                            * 
*                                                              * 
* - Recovery pending                                           * 
*                                                              * 
* - Disable pending                                            * 
*                                                              * 
* - Reorg in progress                                          * 
*                                                              * 
* - storage must be defined                                    * 
*                                                              * 
* - restore in progress                                        * 
*                                                              * 
* - offline and not accessible                                 * 
*                                                              * 
* - only action is drop                                        * 
*                                                              * 
* - redistribute in progress                                   * 
*                                                              * 
* - storeage may be defined                                    * 
*                                                              * 
* - storage Definition is in finla                             * 
*                                                              * 
* - storage Deffinition was chaged prior to rollforward        * 
*                                                              * 
* - Tablespace in progression in progress                      * 
*                                                              * 
* - tablespace creating in progress                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply V95 FP6.                                               * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
Apply V95 FP6.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.01.2010
25.05.2010
25.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)