When opening any DB2 GUI tool the folowing error maybe seen: DB2JAVIT : RC = 9505.
The reason for the error is because the user ID does not have privileges to access the files in the DB2 installation directory (i.e. C:\Program Files\IBM\SQLLIB) due to the extended security feature. With this feature enabled, only administrators and users that belong to the extended security groups DB2USERS or DB2ADMNS will be able to access the install directory and will be able to launch the GUI tools. Please note that on UAC enabled operating systems like Windows Vista, 7, and 2008, administrators may still need to be added to DB2USERS or DB2ADMNS as Windows does not include the full administrator access token when logged in.
For more information on this please see the following Microsoft doc:
Resolving the problem
Verify that the user ID that is trying to open the DB2 GUI tool is part of the Windows groups DB2ADMNS and DB2USERS. To do this:
- Go to Start
- Control Panel
- Administrative Tools
- Computer Management
- Local Users and Groups
You should see the groups DB2ADMNS and DB2USERS. Verify that the user ID you are trying to open the GUI tool with is part of these groups. If user ID is not part of the groups, manually add the user ID to the groups. Please note after adding the user to one or both of those groups, you may need to log out and log back in for it to take affect.
If the permissions are set correctly, this may also be caused because of a missing "TMP" folder within the instance profile path.
1) Run the command "db2set -all" and look for the value of DB2INSTPROF, such as:
DB2INSTPROF=C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\IBM\DB2\DB2COPY1
2) There should be a subdirectory named after the instance such as "DB2" within the instance profile path, similar to:
C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2
If you do not know the name of your instance it can be determined by running the command "db2 get instance"
3) Check this path to see if there is a "TMP" subdirectory. If it does not exist, create a folder called TMP, such as:
C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2\TMP
4) Retry the GUI tool that failed previously
For further discussion on this topic, visit this developerWorks forum thread: