Doug, can you log in via plain db2 in linux (sorry if you said you could, I didnt read
that far back).
Heres what I do:
*************************************************************************************************
[root@somelinuxbox /root]# su - db2inst1
[db2inst1@somelinuxbox db2inst1]$ /usr/IBMdb2/V7.1/bin/db2
(c) Copyright IBM Corporation 1993,2001
Command Line Processor for DB2 SDK 7.2.0
You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 => CONNECT TO MYDB2DB user MICHAEL
Enter current password for MICHAEL:
Database Connection Information
Database server = OS/400 4.4.0
SQL authorization ID = MICHAEL
Local database alias = CMSFIL
db2 =>
**************************************************************************************************
Names changed to protect my network!:)
Can you do that?
Thanks
Dan
-----Original Message-----
From: Doug Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 7:02 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] can i use --with-unixODBC instead of --with-ibm-db2?
Matt,
I wish you were my boss :) I love MySQL and would want to use it instead
of db2 (seeing i could probably have had it working with php last week ;) )
but.... Somehow my boss loves to waste money on IBM products....... and then
hires on people who don't know how to use them well (i.e. me!). My
philosophy is: don't waste money on it, if you can use some open source --
for example he wanted to use IBM WAS (websphere application server) but, PHP
will do everything we need to do, and is a lot easier to deal with than the
bulky WAS.
Anyways.........
I had seen the IBM document that you referenced about connecting DB2 to
PHP, in fact, it's the main document i used to start attempting to get PHP
to work with DB2. The second doc you referenced from phpbuilder.net was
definately a good find -- had a couple ideas that i hadn't tried (i.e.
catalogging the db, running apache as db2inst1 [still trying to get that to
work, db2inst1 doesn't have the priviledges that root has, and henceforth
can't access all the files needed by apache])
Matt, thanks again for all your help!
-Doug
"Matt" <[EMAIL PROTECTED]> wrote in message
047001c23f46$f7707c40$[EMAIL PROTECTED]">news:047001c23f46$f7707c40$[EMAIL PROTECTED]...
> It seems way too difficult to configure db2 on linux. Let alone trying to
do
> it on freebsd, which I hope to tackle that next week.
>
> I tell you though, I really love mysql, it's so easy to use, and
configure.
> mysql just works. mysql's performance on a table I have that has roughly
> 250,000 rows of address entries, beats our as/400 with db2 by orders of
> magnitude and mytest box is a Celeron 300.
>
> Anyway, this is where I found the solution to the gibberish line that I
put
> in my doc (see step 3) :
>
http://www7b.boulder.ibm.com/dmdd/library/techarticle/scott/0614_scott.html
>
> You may find this of help:
> http://www.phpbuilder.com/mail/php-db/2001011/0076.php
>
> Oh, did you call your instance db2inst1?
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
