Datastage ODBC connector stage throws error, SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Socket closed.

Problem

Datastage jobs are failing when running a query against the Azure SQL Server database with the error: SQLSTATE = 08S01, Native Error Code = 0, Message = [IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver] Socket closed.

Cause

The maximum network packet size for encrypted connections for SQL Server, which is 16,383 bytes, was probably being exceeded.

Resolution

Set PacketSize=0 to use the server default or use a fixed packet size such as PacketSize=32.