MQSeries.net :: View topic

Gemz · Posted: Wed Feb 13, 2008 3:06 am Post subject:

Hi,
I am also facing the similar ODBC connectivity problem.

I am using WMB 6.1 and tried to access the oracle database which is in server. In windows the flow is working perfectly and it is able to access the database.
When i deployed the same bar in AIX I am not able to access the same database and not even getting the ODBC error in trace.

We have created the DSN in broker's db2 database in 'odbc64.ini' file.

Created the DSN by adding the following lines in odbc64.ini file.

# Oracle stanza
[DSName]
Driver=/opt/IBM/mqsi/6.1/ODBC64/V5.2/lib/UKora22.so
Description=DataDirect 5.2 64bit Oracle Wire Protocol
HostName=[IPAddress]
PortNumber=1521
SID=dev
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
------------------------------------------
Then we set the dbparms using mqsisetdbparms.
Is there any way check this database connection in AIX.

My Env details are
AIX 5.3
64 bit Broker
Database is Oracle 10g 64 Bit

My Flow is

FileInput --->ComputeNode---->Database

In mqsichangetrace, flow runs till compute node. I am not getting anything about the Database node. Since the flow is not completed my input file is not moved to mqsiarchive or mqsibackout. So msgflow picks the file again and it is doing the same.

Thankss