DB2 - Problem description
Problem IC70423 | Status: Closed |
DB2ICRT AND DB2IDROP HANG WHEN EXECUTING DB2ISRV | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
db2icrt/db2idrop appears to hang when executing db2isrv. You will notice a high CPU usage caused by the db2isrv process. Eventually the db2icrt/db2idrop commands will exit and display an error message similar to this: "Failed to remove "DB2_db2instance1" from the services file. Return code is "-1879047690"." This symptom is caused by wrong order or missing ports from /etc/services. For example, the line "DB2_db2instance1 5914/tcp" will trigger the behavior described above: DB2_db2instance1_1 60001/tcp DB2_db2instance1_2 60002/tcp DB2_db2instance1_END 60003/tcp DB2_db2instance1 5914/tcp In the following example a missing port, DB2_db2instance2, is causing the behavior: DB2_db2instance2_1 60045/tcp DB2_db2instance2_2 60046/tcp DB2_db2instance2_END 60047/tcp | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users at DB2 V9.7 FP3a and below level * **************************************************************** * PROBLEM DESCRIPTION: * * db2icrt/db2idrop appears to hang when executing db2isrv. You * * will notice a high CPU usage caused by the db2isrv process. * * * * Eventually the db2icrt/db2idrop commands will exit and * * displayan error message similar to this: * * * * "Failed to remove "DB2_db2instance1" from the services file. * * Return code is "-1879047690"." * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 9.7 Fix Pack 4 * **************************************************************** | |
Local Fix: | |
Remove all DB2 port entries related to the instance from /etc/services file before invoking db2icrt/db2idrop. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.7 Fix Pack 4 | |
Workaround | |
see LOCAL FIX. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.08.2010 09.05.2011 09.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |