Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to configure unixODBC driver for RQM Live Reporting in RRDI?

Questions
Tags
Users
Badges
Leonardo Marzo
(249●6●48●52) Mar 04 '13, 1:36 p.m.
 Hi everyone, 

I´m having problems with the set up of RQM Live Reporting for RRDI. I succeeded in configuring the UnixODBC driver for 32 bit. However, I´m getting this error when testing the connection with the command isql -v RQM Live:

[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect

This is mi environment:

OS: Linux Redhat 64 bit. 

Output of command odbcinst -j:
unixODBC 2.3.0
DRIVERS............: /opt/IBM/RRDI2/etl/odbc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/IBM/RRDI2/etl/odbc/odbc.ini
FILE DATA SOURCES..: /opt/IBM/RRDI2/etl/odbc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

odbcinst.ini
[IBM Rational XML ODBC Driver]
Description=
Driver=/opt/IBM/RRDI2/etl/odbc/libratlxml.so
Driver64=/usr/local/lib
Setup=/opt/IBM/RRDI2/etl/odbc/libratlxmlS.so
Setup64=/usr/local/lib
LibPath=/opt/IBM/RRDI2/etl/jdbc
MaxActiveStatements=100
QueuingTimeout=100000
DefaultPageSize=1000
DefaultRetryTimes=10
Threading=0
UsageCount=2

jdbclogpath=/tmp/jdbc.log
Debug=1

#[ODBC]
Trace=Yes
TraceFile=/tmp/odbc_u.log

odbc.ini
[RQM Live]
Driver          = IBM Rational XML ODBC Driver
DataSource              = RQM Live
Description             =
Configuration           = /opt/IBM/RRDI2/_extra/rqm40-live.xdc


Everything is working properly on our RRDI except for Live Reporting. 


I would really appreciate you help. 

Thanks!

1

0 votes

2 answers
5,091 views
0 votes

2 answers

Permanent link
Pascale Micaelli
(1) Mar 04 '13, 5:34 p.m.
Hi

I had the same problem. Try to copy odbc.ini and odbcinst.ini files in the directory /etc.

Pascale



0 votes

Comments
Leonardo Marzo
Mar 05 '13, 7:20 a.m.

 I tried that but the problem is still there. Did you succeeded in configure it in a Linux 64 bit? Have you installed any additional libraries? Could yo show me the values of the env variables needed? Thank you!

Permanent link
Pascale Micaelli
(1) Mar 05 '13, 7:33 a.m.
I installed RRDI on Redhat 64bits and everything is Ok

Could you verify you file odbcinst.ini ?
In my file, the path for driver is :
LibPath=/u01/app/IBM/RRDI/etl/jdbc5


0 votes

Comments
Leonardo Marzo
Mar 05 '13, 7:39 a.m.

In mine the path is /opt/IBM/RRDI2/etl/jdbc and exists. Are you using Oracle? 

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,130

Question asked: Mar 04 '13, 1:36 p.m.

Question was seen: 5,091 times

Last updated: Mar 05 '13, 7:39 a.m.

Confirmation Cancel Confirm