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 IC65706 Status: Closed

UNIX: DB2SPRF HAS INCORRECT PERMISSIONS

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Prior to DB2 v9.1 GA,  the file sqllib/cfg/db2sprf required 
world-write permission.   Starting with DB2 v9.1 GA, 
world-write was no longer required.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all Unix                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The file sqllib/cfg/db2sprf has world-write permission dueto * 
* a coding oversight.                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* If sqllib/cfg/db2sprf exists,  remove world write            * 
* permissionmanually.If sqllib/cfg/db2sprf does not exist,     * 
* apply DB2 v9.7 FP2 orlater.  No further action is required.  * 
****************************************************************
Local Fix:
manually remove world-write permission from the file.
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
The code which creates this file has been fixed in DB2 v9.7 FP2. 
However,  applying the fixpack will not change the permissions 
 
if the file already exists.  If the file already exists, 
 
 
permission may be removed manually by the customer,  for 
 
 
example by typing at the unix command line: 
 
chmod o-w db2sprf
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 FixList