|
Problem IC66804
|
Status: Closed |
THE SAMPLE DATABASE CREATED DURING DB2 EXPRESS-C INSTALL CAN NOT BE ACCESSED BY ANY USER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When DB2 Express-C is installed via the GUI install, the SAMPLE
database is created.
However, since the install processes are executed under the
LocalSystem account, the creator of the database is the SYSTEM
account. Thus, other users on the system, including the users in
the local Adminstrator group do not have the authority to access
the database, and can not be granted the access by any of those
users. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* V97ga EXPc on windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* When DB2 Express-C is installed via the GUI install, the *
* SAMPLE database is created. *
* *
* However, since the install processes are executed under the *
* LocalSystem account, the creator of the database is the *
* SYSTEM *
* account. Thus, other users on the system, including the *
* users in the local Adminstrator group do not have the *
* authority to access *
* the database, and can not be granted the access by any of *
* those users. *
****************************************************************
* RECOMMENDATION: *
* This problem is fixed in v97fp2. Thus, the install user or *
* the instance user should have the access authorities to the *
* SAMPLE database created during the EXPc install, if the EXPC *
* image is from V97FP2 or higher releases *
**************************************************************** |
| Local Fix: |
Drop the SAMPLE database, and then manually re-create it by
executing the db2sampl.exe command line. |
| 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 |
Drop the SAMPLE db created during the v97ga EXPc install, and
then create it again with the db2sampl.exe command line. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.03.2010
17.05.2010
17.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2,
9.7.GA
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
