How to I connect to an IBM AIX database externally?

I have a customer that has an IBM AIX server and that server runs their ERP system. It's AIX version 5 2009. How do you connect to the database in this server via an external connection like ODBC?

I have experience with iSeries OS400 but not AIX. I'm not sure what database this system runs and I'm not sure how to check...
LVL 1
JeffDeveloperAsked:
Who is Participating?
 
Gary PattersonVP Technology / Senior Consultant Commented:
Not a Berkley DB or sqlite expert, I'm afraid.  Neither sound likely to be the main DB for a large ERP system, though.  More likely used by some systems management tools or something.  

Why not just call or email Target Data Systems tech support and ask them what DB they use, or have an authorized client rep do it for you?

- Gary
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
OS/400 has DB2 built in to the OS as the native DBMS.  You are unlikely to ever find another database running on iSeries (though you might see MySQL running in PASE, rarely).

AIX doesn't have an integrated database, so you can have any of a number of different database management systems installed.  So you need to know what the DBMS is before we can answer the question of "how do I connect".

What's the ERP system?
0
 
JeffDeveloperAuthor Commented:
ERP is Target Data Systems. They connect via terminal client BluVista.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
JeffDeveloperAuthor Commented:
Is there a command on AIX to show the DB and Version?
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
No one command, unfortunately.  Mostly depends on how the application was installed.

smitty list_installed

Also take a look at the lslpp (list licensed program products) command:
man lslpp, lslpp -h all, lslpp -L all

For RPM packages (like MySQL): rpm -qa

For Oracle: find / -name oracle

For db2: http://www-01.ibm.com/support/docview.wss?uid=swg21667518

You can also look through the list of running processes - generally you can identify running database processes by name:  ps -ef

Also keep in mind that there is no reason that multiple databases can't be running on a single server.
0
 
JeffDeveloperAuthor Commented:
Thank you. I'll see what I can dig up.
0
 
JeffDeveloperAuthor Commented:
There are 2 database systems installed that I can find. db4 (berkeley) and sqlite.
0
 
JeffDeveloperAuthor Commented:
Gary. I don't believe these databases can be accessed via a network port. Can you confirm this? It sounds like if I did manage to connect, somehow, it would break the database.
0
 
JeffDeveloperAuthor Commented:
Thank you Gary. Based on what I was finding the ODBC was looking like a dead end.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.