|
Problem IC66577
|
Status: Closed |
INSTANCE DEFUNCT PROCESSES CREATED UPON LOADS |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
This involves loads using file_transfer_cmd causing db2vend
process to become defunct as follows:
1. We don't wait for completion of userexit in db2vend (we don't
call wait nor waitpid after fork and exec in sqloexecs).
2. Neither set its SA_NOCLDWAIT flag nor set SIGCHLD to SIG_IGN
as the result of resetting SIGCHLD to default with FILE TRANSFER
COMMAND option in db2load utility. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* 9.5 FP3a *
****************************************************************
* PROBLEM DESCRIPTION: *
* This involves loads using file_transfer_cmd causing *
* db2vendprocess to become defunct. *
****************************************************************
* RECOMMENDATION: *
* By using LOGARCHMETH1 TSM setting, we no longer calluserexit *
* asa child process of db2vend process, so the first *
* conditionwillbe no longer satisfied. Hence, the problem will *
* be resolved. *
**************************************************************** |
| Local Fix: |
By using LOGARCHMETH1 TSM setting, we no longer call userexit as
a child process of db2vend process, so the first condition will
be no longer satisfied. Hence, the problem will be resolved. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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: IC66731 IC77544
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2010
19.07.2010
19.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
