DB2 - Problem description
Problem IC75190 | Status: Closed |
INSPECT FILE NOT REMOVED WHILE USING ADMIN_MOVE_TABLE UTILITY, E RROR IS WRITTEN INDB2DIAG EACCES (13) "PERMISSION DENIED" | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
In Version V9.5 the inspect file are not removed for DB2INSPECT_ACT_ROWCMPEST_TBL action by default, which affects both CLP and other applications. In Version V9.7 While using Admin_Move_Table utility following error are written in db2diag file. These error are related to db2fmp process. PID : 1241310 TID : 772 PROC : db2fmp (C) 0 INSTANCE: db2inst2 NODE : 000 EDUID : 772 EDUNAME: db2fmp (C) 0 FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied" DIA8701C Access denied for resource "", operating system return code was "". CALLED : OS, -, open OSERR : EACCES (13) "Permission denied" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * IBM DB2 9.5 * **************************************************************** * PROBLEM DESCRIPTION: * * INSPECT FILE NOT REMOVED WHILE USING ADMIN_MOVE_TABLE * * UTILITY, E * * RROR IS WRITTEN INDB2DIAG EACCES (13) "PERMISSION DENIED" * * * * n Version V9.5 the inspect file are not removed for * * * * DB2INSPECT_ACT_ROWCMPEST_TBL action by default, which * * affects * * both CLP and other applications. * * * * In Version V9.7 While using Admin_Move_Table utility * * following * * error are written * * * * in db2diag file. These error are related to db2fmp process. * * * * * * * * PID : 1241310 TID : 772 PROC : * * db2fmp (C) 0 * * * * INSTANCE: db2inst2 NODE : 000 * * * * EDUID : 772 EDUNAME: db2fmp (C) 0 * * * * FUNCTION: DB2 UDB, oper system services, sqloopenp, * * probe:80 * * MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access * * * * Denied" * * * * DIA8701C Access denied for resource "", * * operating * * system return code * * * * was "". * * * * CALLED : OS, -, open * * * * OSERR : EACCES (13) "Permission denied" * **************************************************************** * RECOMMENDATION: * * This problem is fixed in IBM DB2 9.5 FP8 and DB2 9.7 FP5. * * Upgrade the database to either DB2 9.5 FP8 or 9.7 FP5 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC75336 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.03.2011 04.07.2011 04.07.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8, 9.7.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.8 |