Openlink ODBC driver Installation

start a openlink drivers:

move odbc.openlink.tar to /data/postgres
untar install.zip
it will create /data/postgres/source
move source directory to /opt/odbc_postgres'

run sh ./install.sh
----------------------------------------------------------------------------------
Started installation on : hostname
Extracting (odbc_admin.taz) ...Extracting (pgr7_lt.taz) ...Creating link for Generic ODBC driver manager ...
Welcome to the HTTP-based OpenLink ODBC Administrator Setup.
This program will install the HTTP-based OpenLink ODBC Administrator, therebyenabling remote configuration for all OpenLink Drivers from any WebBrowser.
TCP/IP Port to use? [ENTER=8000] :
Log File? [ENTER=www_sv.log] :
Log all requests (y/n)? [ENTER=n] :
Administrator account? [ENTER=admin] :
Administrator's password? [ENTER=admin] :
The HTTP-based OpenLink ODBC Administrator is now ready for use.Please (re)start the HTTP-based OpenLink ODBC Administrator(using the command 'iodbc-admin-httpd.sh start')and then point your Web Browser to the URL below:
http://hostname:8000
Creating scripts
...
End of installation'
----------------------------------------------------------------------------------
run /opt/odbc_postgres/openlink.sh
. ./openlink.sh

copy the appropiate the license file to /opt/odbc_postgres/bin
cd /opt/odbc_postgres/bin
run ./iodbc-admin-httpd.sh start
run ./oplmgr +start
you should see these two openlink daemons running:
openlink daemons:
root 1531924 1 0 16:31:42 pts/5 0:00 ./www_sv
root 1462376 1 0 19:06:30 - 0:00 /home/p139pkg/odbc/source/32bit/bin/oplmgr +start

edit the odbc.ini /opt/odbc_postgres/bin/odbc.ini to connect to postgres database
for example: PG3
if you are getting error message, like connection refused.make sure you have permission to connect to PG3 from your serverthats the file to edit/data/pg_hba.conf
----------------------------------------------------------------

On datastage
1. update the $DSHOME/.odbc.ini with the driver and server info as follows
[ODBC_DSN]
Driver=/opt/odbc_postgres/lib/pgr7_mt_lt.so
PGHOST=X.X.X.X
Host=X.X.X.X:5432
PGPORT=5432
Options= -H x.x.x.x
ServerType=PostgreSQL
Database=mdc_oz
CURSOR_SENSITIVITY=LOW ; Set to HIGH after loading oplrvc.sql
NO_QUOTED_IDENTIFIERS=NHS
ODBC_FIX=N ; Set to Y when using HSODBC
Trace=1
TraceFile=/tmp/trace_pgodbc.log

2. run dsenv