APAR status
Closed as program error.
Error description
Long running ODBC Connector read jobs which connect to DB2 z/OS might fail whenever the job run time exceeds idle thread timeout (IDTHTOIN) setting on the DB2 z/OS server. The error message could be one of the following, "socket closed" or "connection dead" or "permanent agent error".
Local fix
1) Set Auto Commit Mode to On in the ODBC Connector stage properties 2) Increase the idle thread timeout setting (IDTHTOIN) on the DB2 z/OS Server
Problem summary
Long running ODBC Connector read jobs connecting to DB2 z/OS database abort with "socket closed" or "connection dead" or "permanent agent error" message when the idle thread timeout is exceeded.
Problem conclusion
Code has been corrected to overcome this problem.
Temporary fix
Set Auto Commit Mode to ON in the ODBC connector stage properties and/or increase the idle thread timeout on the DB2 z/OS Server.
Comments
APAR Information
APAR number
JR57444
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-02-18
Closed date
2017-02-24
Last modified date
2017-02-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
None None
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R870 PSY
UP
R910 PSY
UP
R912 PSY
UP
RB30 PSY
UP
RB31 PSY
UP
RB50 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 February 2017