DB2 - Problem description
Problem IC78022 | Status: Closed |
THE DB2START COMMAND WITH RESTART OPTION MAY TAKE LONG TIME. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
The db2start command with restart option may take long time. The node recovery by db2start with restart option may take long time. The following stack can be observed for db2start in this situation. nrecvfrom(??, ??, ??, ??, ??, ??) at 0x9000000001037c4 .readloop()() at 0x900000015264c00 .sqleIsHostAlive(char*)(??) at 0x9000000152647b8 sqleIsHostAlive(char*)(??) at 0x900000015264598 sqleIssueStartStop.fdpr.chunk.8(int,void*,char*,char*,sqlf_kcfd* ,int,SQLE_INTERNAL_ARGS*,unsigned int,unsigned int,sqlca*)(0x900000018d82cbc, 0xfffffffffffab10, 0x0, 0x0, 0x3000000000000000, 0xc310, 0x0, 0x0) at 0x9000000151f7f90 sqleProcessStartStop.fdpr.chunk.3(int,void*,SQLE_INTERNAL_ARGS*, sqlf_kcfd*,char*,int,unsigned int,unsigned int,sqlca*)(??, ??, ??, ??, ??, ??, ??, ??) at 0x900000018d84134 main(??, ??) at 0x100001558 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using db2start with restart option. * **************************************************************** * PROBLEM DESCRIPTION: * * The db2start command with restart option may take long time. * * * * The node recovery by db2start with restart option may take * * long * * time. * * * * The following stack can be observed for db2start in this * * situation. * * * * nrecvfrom(??, ??, ??, ??, ??, ??) at 0x9000000001037c4 * * .readloop()() at 0x900000015264c00 * * .sqleIsHostAlive(char*)(??) at 0x9000000152647b8 * * sqleIsHostAlive(char*)(??) at 0x900000015264598 * * sqleIssueStartStop.fdpr.chunk.8(int,void*,char*,char*,sqlf_k * * cfd* * * ,int,SQLE_INTERNAL_ARGS*,unsigned * * int,unsigned int,sqlca*)(0x900000018d82cbc, * * 0xfffffffffffab10, * * 0x0, 0x0, 0x3000000000000000, 0xc310, 0x0, 0x0) at * * 0x9000000151f7f90 * * sqleProcessStartStop.fdpr.chunk.3(int,void*,SQLE_INTERNAL_AR * * GS*, * * sqlf_kcfd*,char*,int,unsigned * * int,unsigned int,sqlca*)(??, ??, ??, ??, ??, ??, ??, ??) at * * 0x900000018d84134 * * main(??, ??) at 0x100001558 * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.7 Fix Pack 5. * **************************************************************** | |
Local Fix: | |
Not available | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
The issue was fixed in V9.7 Fix Pack 5. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC78120 IC78121 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.08.2011 08.12.2011 08.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 |