DB2 - Problem description
Problem IC75836 | Status: Closed |
DBI1309E ERROR IS RETURNED WHEN SETTING DB2_UTIL_MSGPATH AT THE INSTANCE LEVEL USING DB2SET. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
SQL error DBI1309E is returned when trying to set db2 registry DB2_UTIL_MSGPATH at the instance level: Ex: As db2 instance owner: db2set DB2_UTIL_MSGPATH=<path_for_messages> DBI1309E System error. Explanation: The tool encountered an operating system error. User response: A system error was encountered during registry access. Ensure that there is enough space on the file system where the registry is located, and that there is a valid LAN connection if the registry is remote. According to db2 Info center, this registry is db2 registry and can be set at instance level. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?t opic=/com.ibm.db2.luw.admin.regvars.doc/doc/r0005669.html However, this registry can be set successfully globally as root user or as a system environment variable as db2 instance owner. Ex: . as root user: db2set -g DB2_UTIL_MSGPATH=<path_for_messages> . as db2 instance owner: export DB2_UTIL_MSGPATH=<path_for_messages> db2set -all [e] DB2_UTIL_MSGPATH=<path_for_messages> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users on DB2 V95 FP9 and prior * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v95 FP10 * **************************************************************** | |
Local Fix: | |
As a workaround to the issue, you can apply one of the following instructions. . To set it globally to be applied for all the db2 instances on the system, as root run: db2set -g DB2_UTIL_MSGPATH=<path_for_messages> or . to set it at the instance level, as db2 instance owner run: export DB2_UTIL_MSGPATH=<path_for_messages> | |
Solution | |
First Fixed in DB2 v95 FP10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.04.2011 05.09.2012 05.09.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.10 |