IBM Support

How to check MySQL/MariaDB ODBC driver for RTM

Question & Answer


Question

If UnixODBC driver installed for RTM 10.1, how to get more detailed information of UnixODBC driver.

Answer

To address the UnixODBC driver information for RTM 10.1, you should:

1. Open a root shell

2. Input the command below:

odbcinst -j

You should get the output:

==========


unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
===========
You can see the DRIVER definition file
DRIVERS............: /etc/odbcinst.ini

3. Get more UnixODBC driver configuration
more /etc/odbcinst.ini
===========
.......
[MySQL RTM]
Description = Mysql ODBC Driver for IBM Spectrum LSF RTM.
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
UsageCount = 1
CPTimeout =
CPReuse =
===========

You can see the UnixODBC driver information for RTM
[{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

More support for:
IBM Spectrum LSF RTM

Software version:
10.1

Document number:
631655

Modified date:
17 June 2018

UID

isg3T1025537

Manage My Notification Subscriptions