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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
JeffDeveloperAuthor Commented:
Is there a command on AIX to show the DB and Version?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JeffDeveloperAuthor Commented:
Thank you Gary. Based on what I was finding the ODBC was looking like a dead end.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
IBM

From novice to tech pro — start learning today.