By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

PHP on RedHat 7.2 connecting to DB2 V6.1 database on Solaris

P: n/a
Greetings All,

I have situation as such that I need to access the DB2 database reside
on
a Solaris box. I have DB2 6.1 on my Solaris box. However, my webserver
is on Redhat 7.2. Now, I want to access the database residing on the
Solaris box via PHP page.

The IBM site has tips on how PHP pages accessing DB2 database. The
example given is good enough for me. I manage to get the ODBC Driver
Manager for
RedHat from www.unixODBC.org and successfully manage to install it.
The problem
here is that, I'm not sure which version of DB2 Connect to be
installed in
my webserver which is RedHat 7.2.

I think the DB2 Version 6.1 is not certified on RedHat 7.2. I'm
getting all
sort of dependencies errors during installation. I guess it could be
due to incompatibility. However, DB2 Version 7.2 seem to fit on RedHat
7.2. If i were to use DB2 7.2 to connect to DB2 6.1 Database residing
on Solaris box, will
this work?

If the above is not possible, that means i need to upgrade DB2 version
on
the Solaris box to 7.2 or later before could access the database. Am i
right?

Please help!

Thanks
Uthuras
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ian
Uthuras wrote:
Greetings All,

I have situation as such that I need to access the DB2 database reside
on
a Solaris box. I have DB2 6.1 on my Solaris box. However, my webserver
is on Redhat 7.2. Now, I want to access the database residing on the
Solaris box via PHP page.

The IBM site has tips on how PHP pages accessing DB2 database. The
example given is good enough for me. I manage to get the ODBC Driver
Manager for
RedHat from www.unixODBC.org and successfully manage to install it.
The problem
here is that, I'm not sure which version of DB2 Connect to be
installed in
my webserver which is RedHat 7.2.


You can install the DB2 Runtime Client v7.2 and use this. (v7
will connect with a v6 instance).

You don't need DB2 Connect. You also don't need unixODBC. The IBM
DB2 support in PHP uses the php unified odbc driver, but it uses the
Runtime client code.
Also be aware that V6 is not supported on any platform anymore,
so you might want to consider moving your server up to V7 or V8
in the near future.
Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

P: n/a
Ian <ia*****@mobileaudio.com> wrote in message news:<3f**********@corp.newsgroups.com>...
Uthuras wrote:
Greetings All,

I have situation as such that I need to access the DB2 database reside
on
a Solaris box. I have DB2 6.1 on my Solaris box. However, my webserver
is on Redhat 7.2. Now, I want to access the database residing on the
Solaris box via PHP page.

The IBM site has tips on how PHP pages accessing DB2 database. The
example given is good enough for me. I manage to get the ODBC Driver
Manager for
RedHat from www.unixODBC.org and successfully manage to install it.
The problem
here is that, I'm not sure which version of DB2 Connect to be
installed in
my webserver which is RedHat 7.2.
You can install the DB2 Runtime Client v7.2 and use this. (v7
will connect with a v6 instance).

You don't need DB2 Connect. You also don't need unixODBC. The IBM
DB2 support in PHP uses the php unified odbc driver, but it uses the
Runtime client code.
Also be aware that V6 is not supported on any platform anymore,
so you might want to consider moving your server up to V7 or V8
in the near future.
Good luck,

Thanks for the prompt feedback. I have another question related to PHP
connection to the remote database. As i mentioned, the DB2 database
reside
on the solaris box, so how shall i address the location of the remote
server
under PHP configure option.

e.g
$cd php-4.0.5
$ ./configure --with-ibm-db=/home/db2inst1/sqllib
{instance-path}

The above only works for local machine. How configure remote DB2
remote
instance reside in the solaris box ? Do i have to CATALOG the remote
NODE,
INSTANCE and DATABASE to the local machine first?

I'm a bit confused please help me out

Thanks
Uthuras


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Nov 12 '05 #3

P: n/a
Ian
Uthuras wrote:

Thanks for the prompt feedback. I have another question related to PHP
connection to the remote database. As i mentioned, the DB2 database
reside
on the solaris box, so how shall i address the location of the remote
server
under PHP configure option.

e.g
$cd php-4.0.5
$ ./configure --with-ibm-db=/home/db2inst1/sqllib
{instance-path}

The above only works for local machine. How configure remote DB2
remote instance reside in the solaris box ? Do i have to CATALOG the
remote NODE, INSTANCE and DATABASE to the local machine first?


On the web server you will have a runtime client installed, and it
will have a client instance, where you will catalog the remote
database.

You should specify the argument to the --with-ibm-db2 based on the
location of your client instance on the web server.
Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #4

P: n/a
Ian <ia*****@mobileaudio.com> wrote in message news:<3f**********@corp.newsgroups.com>...
Uthuras wrote:

Thanks for the prompt feedback. I have another question related to PHP
connection to the remote database. As i mentioned, the DB2 database
reside
on the solaris box, so how shall i address the location of the remote
server
under PHP configure option.

e.g
$cd php-4.0.5
$ ./configure --with-ibm-db=/home/db2inst1/sqllib
{instance-path}

The above only works for local machine. How configure remote DB2
remote instance reside in the solaris box ? Do i have to CATALOG the
> remote NODE, INSTANCE and DATABASE to the local machine first?


On the web server you will have a runtime client installed, and it
will have a client instance, where you will catalog the remote
database.

You should specify the argument to the --with-ibm-db2 based on the
location of your client instance on the web server.
Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----


Greetings,

I manage to get DB2 V7.2/Apache 1.3.14/PHP 4.0.3 to work together on
RedHat 8.0.
However, i could not get the latest version of Apache which is known
as HTTPD 2.0.48/PHP 4.3.4/DB2 V7.2 on RedHat 8.0 work together.

The httpd 2.0.x seem to give compilation error when do 'make install'
after
doing the following

# cd /usr/local/etc/httpd
# ./configure --prefix=/usr/local/etc/httpd --sysconfdir=/www/conf
--enable-
module=rewrite --enable-module=status
# make

it gives error as such that

..
...
Installing header files
cp `include/apr_allocator.h' and
`/usr/local/etc/httpd/apr_allocator.h'
are the same file
cp `include/apr_atomic.h' and `/usr/local/etc/httpd/apr_atomic.h'
are the same file
cp `include/apr_anylock.h' and
`/usr/local/etc/httpd/apr_anylock.h'
are the same file
cp `include/apr_base64.h' and `/usr/local/etc/httpd/apr_base64.h'
are the same file
....
....
....
make[1]: *** [install-include] Error 1
make[1]: *** [install-recursive] Error 1

and stop the installation. What seem to be the problem? Is there some
library
that are missing ? What is the compatible and certified HTTPD and PHP
version
to run on Redhat 8.0. I could not seem to find any information and
thus helpless.

Please help!

Thanks in advance
Uthuras
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.