|
Problem IC74687
|
Status: Geschlossen |
DB2SUPPORT -A MAY MAKE DB UNCONNECTABLE ON WINDOWS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
On Windows, currently the default DIAGPATH is same as the
instance path. If a user doesn't modify DIAGPATH to another
path, and use db2support -A to archive everything under the
DIAGPATH, which will accidentally archive everything including
the SQLDBDIR, security directories as well as other system files
under the path. Thus the "connect to db" will fail afterwards.
For example, some errors returned could be like the following:
C:\Documents and Settings>db2 connect to testdb
SQL1323N An error occurred when accessing the audit
configuration file.
SQLSTATE=57019
C:\Documents and Settings>db2 connect to testdb
SQL1031N The database directory cannot be found on the
indicated file system.
SQLSTATE=58031
We need to disable the db2support -A on Windows to avoid this
issue. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* On Windows, currently the default DIAGPATH is same as the *
* *
* instance path. If a user doesn't modify DIAGPATH to another *
* *
* path, and use db2support -A to archive everything under the *
* *
* DIAGPATH, which will accidentally archive everything *
* including *
* the SQLDBDIR, security directories as well as other system *
* files *
* under the path. Thus the "connect to db" will fail *
* afterwards. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the V97FP4 and upper releases/fixpacks *
**************************************************************** |
| Local-Fix: |
Copy back the archived files to the DIAGPATH |
| verfügbare FixPacks: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
V97FP4 and upper releases/fixpacks |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 24.02.2011
08.11.2012
08.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
