|
Problem IC74687
|
Status: Closed |
DB2SUPPORT -A MAY MAKE DB UNCONNECTABLE ON WINDOWS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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.
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
V97FP4 and upper releases/fixpacks |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.02.2011
08.11.2012
08.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
