|
Problem IC65723
|
Status: Closed |
Turning logarchmeth off will cause log file not to be reused. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 v97 fp2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Apply v97 fp2 |
| 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.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
