DB2 - Problem description
Problem IC77995 | Status: Closed |
db2pd ( or db2pdcfg ) with -dbp or -mem option keeps on spawning new db2pd ( or db2pdcfg ) in a loop, and may exhaust the system | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
If db2nodes.cfg has non canonical hostname at the second column, such as netname, service adaptor name, or "localhost", as below example, db2pd or db2pdcfg with -dbp or -member option may run in an endless loop, and keep on spawning new db2pd or db2pdcfg process. ---- 0 hidehy01 0 1 hidehy02 1 2 hidehy03 2 ---- * above second columns are not 'hostname' command output but netname. If 'hostname' command returns hidehy1, hidehy2 and hidehy3 at each machines. Here is correct example: ---- 0 hidehy1 0 1 hidehy2 1 2 hidehy3 2 ---- * above second columns are output of 'hostname' command at each machines. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description field for more information. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 FixPack 5. * **************************************************************** | |
Local Fix: | |
Modify db2nodes.cfg to use canonical hostname at the second column of db2nodes.cfg | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.08.2011 16.12.2011 16.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.5 |