IBM Support

How can I find the DataDirect ODBC driver version used by DataStage jobs?

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"}}]

Document Information

Modified date:
16 June 2018

UID

swg21574486