Using PowerExchange ODBC Connections in a Data Archive Retirement Project

Back Next

Configure ODBC Data Sources on Linux or UNIX

Use this procedure to configure ODBC data sources on Linux or UNIX.

Copy the DataDirect Driver Manager from the computer where PowerCenter and DVO are installed to the server where Power Exchange and the Data Archive engine are installed.

To copy the DataDirect Driver Manager, copy the following directory to the system with the Data Archive engine:

 PowerCenter_installation_directory/ODBC6.1

Tar the entire directory, copy it using FTP, and then untar the directory on the target system.

Add the ODBC6.1/lib directory to one of the following environment variables:

LD_LIBRARY_PATH on Sun or Linux

SHLIB_PATH on HP-UX

LIBPATH on AIX

Create the odbc.ini file and set the ODBCINI environment variable to point to this file.

In the odbc.ini file, include the following line for each data source:

Compatibility=ILMBRIDGE

The following example shows a section of an odbci.ini file for one data source:

[nrdb2_mhz8902]
Driver=/pwx_installation_directory/source/libdtlodbc.so
Description=dBase
Database=
DBType=nrdb2
Location=zos_listener_name
DBQual1=
DBQual2=
MaxRows=0
Compress=N
Encrypt=N
ConfirmWrite=N
PaceSize=0
InterpretASRows=N
BulkLoad=N
DeleteTempFiles=0
LoadOptions=0
JCLTemplate=
CTLTemplate=
ModeType=0
ModeTime=0
Time=0
Space=
pace=0
SecSpace=0
Compatibility=ILMBRIDGE

For HP-UX systems, change the driver name in the odbc.ini file from libdtlodbc.so to libdtlodbc.sl.

For more information, see the

PowerExchange Reference Manual

Step 6: Configure PowerExchange ODBC Data Sources on the Data Archive Server

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal