Example of ODBC Settings for IBM DB2 OS/390

The following example illustrates how you might edit odbc.ini to connect to a Data Source database, such as db2data on IBM DB2 version 8.2 (on AIX), using a DataDirect Wire Protocol driver. You can make a separate entry to connect to the OLAP Metadata Catalog database.

Use the vi $ODBCINI command to edit the odbc.ini file and insert the following statements:

[ODBC Data Sources]
os390=DB2 OS/390 Source Data

...

[os390]
Driver=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0/Drivers/ARdb222.so
Collection=DATADIRECT00
Database=
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=isaix21
IsolationLevel=CURSOR_STABILITY
Location=DALLAS
Package=PACK42
PackageOwner=
TcpPort=446
WithHold=1
[ODBC]
IANAAppCodePage=4
InstallDir=products/common/ODBC/Merant/6.0
Trace=0
TraceDll=products/common/ODBC/Merant/6.0/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

Note:

To use Integration Services with IBM DB2 OS/390, you must add an entry to the ais.cfg file after you configure the data source name for the source database.