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