Question & Answer
Question
How can I find the DataDirect ODBC driver version used by DataStage jobs?
Answer
Windows Instructions
Open Control Panel, ODBC Data Source Administrator
Select Drivers tab
Version is usually the second column
Unix instructions
1. Login to Unix system with dsadm id
2. Change to the home directory and source the dsenv file
$ cd $DSHOME
$ . ./dsenv
3. View the path of the Driver in the odbc.ini
$ more $ODBCINI
$/DSNNAME
[DSNNAME]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora24.so
4. View the odbc.ini file and determine the InstallDir in the [ODBC] Section
$ more $ODBCINI
$ /InstallDir
InstallDir=/opt/IBM/InformationServer/Server/branded_odbc
5. Change the current directory to the InstallDir/bin
$ cd /opt/IBM/InformationServer/Server/branded_odbc
6. Determine the test program
$ ls bin
ivtestlib (older versions)
ddtestlib (newer versions)
7. Run the test program from $DSHOME/../branded_odbc against the driver
$ bin/ivtestlib /opt/IBM/InformationServer/Server/branded_odbc/lib/VMora24.so
or
$ bin/ddtestlib /opt/IBM/InformationServer/Server/branded_odbc/lib/VMora24.so
The File Version will be returned. See example below:
Load of /opt/IBM/InformationServer/Server/branded_odbc/lib/VMora24.so successful, qehandle is 0x3
File version: 06.00.0079 (B0069,U0029)
[{"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"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21574486