On Thu, 22 Jul 1999, Alexander Schatten wrote:
> I am searching for a database for my new project. now there are really a
> lot of RDBMS systems for Linux (nearly too much!). at the moment I am
> playing with mySQL, which is nice, simple, but lacks some functionality:
> foreign keys, first of all. PostgreSQL seems to have other problems, now
> there are certain commercial systems, that should be free for
> non-commercial use.
Don't know if DB2 fits this ... sure there is a time-limited evaluation
period. Maybe that is enough for you, or maybe you know more about their
licensing than I do.
> has someone experiences with DB2 and
>
> -- installation
DB2 comes with a nice installationprogram that sets everything up for you
(with reasonable default values). It worked fine on RH5.0 but failed with
segmentation fault on RH6.0 (probably glibc or the DB2 version I tested).
It can be installed anyway by simply installing the rpm's, and then fixing
things so they work (and I haven't really tested this much).
DB2 requires pdksh to be installed (it's included with RH).
> -- administration
You don't have to do anything unless you don't want to ... The docs are
readable (but are they included with the beta?)
> -- JDBC
The linux jdk doesn't seem to have any problems in this area. There are 2
JDBC drivers that come with DB2, one using a shared lib (app) and one
using pure java (net).
The app driver needs native threads (on solaris anyway, haven't tried it
on Linux) and some environment variables set (DB2INSTANCE). The net driver
needs a listener program (db2jd, which you start with db2jstrt), and
nothing more.
> -- connection to Access / ODBC
You need to install the "Client Application Enabler" on the client
machine, configure it to talk to the DB2, enable ODBC and then connect
access to that ODBC. I haven't done this to DB2 running on Linux, I have
done NT->Solaris.
There is a newsgroup comp.databases.ibm-db2, which is probably a better
place to ask DB2 related questions.
/Urban
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
