Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


ODBC to AIX DB2 (I know...)

ODBC to AIX DB2 (I know...)

ODBC to AIX DB2 (I know...)

Hi All,

I'm sure this one's been beat into the ground, but I can't find a good answer. I'll start this off by saying I'm a Business Objects and Crystal developer. I'm not good with databases and I know nothing of Unix or Linux.

I've got Business Objects on a Windows 7 machine.
I've got a db2 database on the network on an AIX machine.
I've installed the DB2 ODBC driver on my machine.

I can't get the ODBC to work at all. I can't even figure out where to put the IP Address and Port or anything. The end result I need is to connect Business Objects to this db2. The easiest way I know to connect anything to Business Objects is ODBC.

I've read the IBM documents on DB2 ODBC and about every post I can find, but it's just not doing it for me. My DBA's say they can't help me because they don't know Windows. Really I just need some step by step idiot instructions. I appreciate any help you can send my way.


RE: ODBC to AIX DB2 (I know...)

Suggest you find and talk with whoever supports db2 on aix. Are these the same dbs'a who say they don't know Windows?

Someone should know how to connect to db2 on aix . . .

RE: ODBC to AIX DB2 (I know...)

Yep. Same guys. I'm a contractor and I've only been around 6 days. I'm not really getting much help.

RE: ODBC to AIX DB2 (I know...)

While I was not able to set up the odbc yet, loading the client got me the drivers I needed to create the aliases I needed to connect directly with Crystal Reports DB2 connector. Thanks for the tip, mikrom.

RE: ODBC to AIX DB2 (I know...)

Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)

opens the ODBC Data Source Adminstrator.

Open the System DSN Tab

ADD the DB2 driver. This dialog is where you add the Host, Port, UID, Password and any other required property selections. You might also look at the Advanced settings and MORE.


glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: ODBC to AIX DB2 (I know...)

suppose you have a db2 server with tcipip# and a db2instance listening to port 50000. There is a database called mydbase running under control of that instance. You need te access that database by means of ODBC.
It is just 3 simple lines, just do not forget to execute them in the "db2cmd" box an not in the normal cmd windows shell:


db2 -v "catalog tcpip node mydbnode remote server 50000" 
db2 -v "catalog   database mydbase  at node mydbnode"   
db2 -v "catalog system odbc data source     mydbase" 
That's all folks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close