IBM Support

Datastage ODBC stage jobs intermittently abort with timeout expired error message

Troubleshooting


Problem

Datastage ODBC stage jobs intermittently abort with following error message: IBM(Datadirect OEM)[ODBC DB2 Wire Protocol driver]Timeout expired. The job, when resubmitted at a later time, will complete successfully.

Cause

The LoginTimeout connection attribute has been added starting in DataDirect 6.0 drivers.

This attribute has a default value of 15 seconds. If the driver has to wait longer for a connection to be established than the specified number of seconds, the driver will return control to the application and generate a timeout error.

Resolving The Problem

To resolve this issue, you should Increase the value of the LoginTimeout connection attribute in the odbc.ini configuration file. This parameter is specified in seconds.

[SAMPLE]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb224.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Database=sample
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=<hostname>
IsolationLevel=CURSOR_STABILITY
LogonID=
LoginTimeout=120
Password=
Package=
PackageOwner=
TcpPort=<port#>
WithHold=1

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.7;8.5;8.1;8.0;7.5.3;7.5.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21570280

Page Feedback