Mainframe DB2 connection - DS 6

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Mainframe DB2 connection - DS 6

Post by admin »

We need to create an ODBC connection to a mainframe DB2 database. We're running DS 6 on Solaris. We've configured SQL Server and Informix connections, but not DB2.

Does anyone have a working example of the entry in the .odbc.ini file? (with sensitive info removed, obviously).
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Top
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Mainframe DB2 connection - DS 6

Post by admin »

Ryan, here is a working example of a .odbc.ini entry for Mainframe DB2...
We are currently running DataStage version 6.0.1 on AIX. Bernard.

[DB2xxx]
QEWSD=37942
Driver=/usr/Ardent/uv/../branded_odbc/lib/VMdb218.so
Description=DataDirect DB2 Wire Protocol Driver
Trace=0
TraceFile=odbctrace.out
TraceDll=/usr/Ardent/uv/../branded_odbc/lib/odbctrac.so
InstallDir=/usr/Ardent/uv/../branded_odbc
ConversionTableLocation=/usr/Ardent/uv/../branded_odbc/tables
UseCursorLib=0
IpAddress=
Database=DB2xxx
TcpPort=
Location=DB2xxx
Collection=NULLID
Package=
ServerCharSet=37

-----Original Message-----
From: Ryan Day [mailto:RWDAY@kcc.usda.gov]
Sent: Tuesday, November 25, 2003 6:46 AM
To: "'datastage-users@oliver.com'"
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Top
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Mainframe DB2 connection - DS 6

Post by admin »

Thanks Bernard

>>> Bernard.Potin@PREMERA.com 11/25/03 11:53AM >>>
Ryan, here is a working example of a .odbc.ini entry for Mainframe DB2...
We are currently running DataStage version 6.0.1 on AIX. Bernard.

[DB2xxx]
QEWSD=37942
Driver=/usr/Ardent/uv/../branded_odbc/lib/VMdb218.so
Description=DataDirect DB2 Wire Protocol Driver
Trace=0
TraceFile=odbctrace.out
TraceDll=/usr/Ardent/uv/../branded_odbc/lib/odbctrac.so
InstallDir=/usr/Ardent/uv/../branded_odbc
ConversionTableLocation=/usr/Ardent/uv/../branded_odbc/tables
UseCursorLib=0
IpAddress=
Database=DB2xxx
TcpPort=
Location=DB2xxx
Collection=NULLID
Package=
ServerCharSet=37

-----Original Message-----
From: Ryan Day [mailto:RWDAY@kcc.usda.gov]
Sent: Tuesday, November 25, 2003 6:46 AM
To: "'datastage-users@oliver.com'"
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Top
Locked

Return to “Archive of DataStage Users@Oliver.com”