IBM Support

Information Server DataStage poor performance writing to SQL Server

Troubleshooting


Problem

Information Server DataStage job has poor performance when writing to SQL Server.

Cause

This can occur when using the older, deprecated ODBC driver VMmsss25.so for SQL Server.

Resolving The Problem

Use the newer, more advanced ODBC driver VMsqls25.so .
The older driver, VMmsss25.so, is called "The SQL Server Classic Wire Protocol Driver".
DataDirect describes a performance problem with this driver at this link:

http://knowledgebase.progress.com/articles/Article/8776

(In the article, the driver names begin with "iv". When this driver is bundled with Information Server, the "iv" in the name is replaced with "VM".)

The newer driver, VMsqls25.so, is called "The SQL Server Native Wire Protocol Driver".
This driver is built on newer technology and supports new datatypes and security features found in SQL Server 2008 and later. Datadirect makes this recommendation:

"We highly recommend using the NEW DataDirect SQL Server driver, ivsqlsxx.so or ivsqlsXX.dll (Windows) when connecting to SQL Server 2008."

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.7;8.5;8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21621427