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 | |
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 |