Hi Charles, So you just need to get the Apache on Fedora configured to connect to the DB2 servers on AIX? This is a good a list to ask as any :) Here are the steps I would take (some of which you might have already done... so it's up to you whether you want to start fresh or tweak my instructions). This is based on RHEL / CentOS using DB2 v9.7, so it might be slightly different for you. (Sorry for the top post, it's easier to write this all up front.) 1. Download the DB2 Runtime Client. Based on the specs you mention, it would be: IBM Data Server Runtime Client (Linux AMD64 and Intel EM64T) ibm_data_server_runtime_client_linuxx64_v10.1.tar.gz (613 MB) 2. Install and configure the DB2 RC (I use 9.7, so modify this for 10.1): tar -xzvf ibm_data_server_runtime_client_linuxx64_v9.7.tar.gz cd rtcl echo "no" > rsp.txt ./db2_install < rsp.txt groupadd db2iadm1 useradd db2inst1 -g db2iadm1 /opt/ibm/db2/V9.7/instance/db2icrt -s client db2inst1 echo '. /home/db2inst1/sqllib/db2profile' >> /etc/sysconfig/httpd # Assuming yum install of httpd... otherwise put it in apachectl 2. Then either download the PHP and IBM DB2 extension source (instructions here: http://us.php.net/manual/en/ibm-db2.installation.php), or use Zend Server (which I recommend if you want to manage everything with yum, including the DB2 drivers). http://www.zend.com/en/products/server/downloads Install, then add the "php-5.3-ibmdb2-zend-server" extra package (you could also install the PDO one). 3. Catalog the remote system (optional... you'd just use a lengthier connection string in step 4) . /home/db2inst1/sqllib/db2profile db2 "catalog tcpip node aixbox1 remote db2.example.com server 50000 remote_instance db2inst1 ostype aix" db2 "catalog database sample as sample at node aixbox1 " 4. Test your connection from /var/www/html/index.php. $conn_resource = db2_connect($db2_name, $db2_user, $db2_pass); if ($conn_resource) { echo 'Connection to database succeeded.'; db2_close($conn_resource); } else { echo 'Connection to database failed.<br />'; echo 'SQLSTATE: ' . db2_conn_error() . '<br />'; echo 'Message: ' . db2_conn_errormsg(). '<br />'; } Hope that gets you on the right track. Thanks, -Dan Daniel Krook, IBM L2 Certified IT Specialist Software Engineer, Advanced Cloud Technology, GTS, IBM Cloud Architecture, Java EE, PHP, BlackBerry, DB2 & Solaris Certified Charles W Buege <cbuege@xxxxxxxxxxxxx> wrote on 05/11/2012 09:48:08 AM: > From: Charles W Buege <cbuege@xxxxxxxxxxxxx> > To: php-db@xxxxxxxxxxxxx > Date: 05/11/2012 09:52 AM > Subject: Installing IBM DB2 drivers onto an Apache Server > under Fedora 16 x64 to access IBM POWER7 DB2 via PHP.... > > All - > > I know that this topic only vaguely relates to this mailing list, > but I thought I'd start here. If anyone has a better location for > me to look at for this information, please feel free to tell me. > > Okay, here's my scenario. We are an IBM POWER7 shop and have > several instances of Apache running on our POWER7 for customer > information lookup, part ordering, etc. What I am attempting to do > is setup a web server as a virtual machine in Fedora 16 as a front- > end to all of these servers to perform the following tasks: > - centralized access to all of the sites - a table of contents/central portal > - a server that, when the POWER7 is down for backup and/or > maintenance, it can provide a 'Temporarily Out Of Service' message > to any users attempting to access these sites with a message of 'The > system is down for (whatever the reason). It will be back up by (time).' > - Another development/deployment platform other than our POWER7 for > testing/learning/etc. since setting up a virtual host on Apache > under Linux means that it is something that I can do instead of > involving our POWER7 administrator since he is as busy as I am > > Here is what I have done so far. I've got the Apache running on the > Fedora 16 box no problem. I'm getting good phpinfo() results, so > all good there. I'm trying to follow IBM's instructions for getting > DB2 drivers using the following sites: > Setting up the PHP environment on Linux or UNIX - http:// > publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=% > 2Fcom.ibm.swg.im.dbclient.php.doc%2Fdoc%2Ft0011926.html > which lead me to this page to get the IBM Data Server Driver Package > mentioned in bullet point three > Download initial Version 10.1 clients and drivers - http:// > www-01.ibm.com/support/docview.wss?uid=swg21385217 > which I did download and that page sent me to here: > Installing IBM Data Server Driver Package (Linux and UNIX) - http:// > publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=% > 2Fcom.ibm.swg.im.dbclient.install.doc%2Fdoc%2Ft0054799.html > where, after reading this page, I attempted to run the > installDSDriver which apparently requires ksh to be installed to run > so I downloaded and installed the ksh package. > Now, at this point, I will freely admit that I am not 100% sure what > is meant by step #3 on this page: For the Java and ODBC/CLI drivers > (which it says are needed for the PHP drivers), uncompress the > driver file into your chosen install directory on the target machine. > It's the verbage of 'chosen install directory' that is throwing me. > So, in an effort to move ahead and get the ODBC/CLI drivers loaded, > I went on to this page: > Installing the IBM Data Server Driver for ODBC and CLI - http:// > publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=% > 2Fcom.ibm.db2.luw.apdv.cli.doc%2Fdoc%2Ft0023864.html > At this point, I read these instructions which seemed to confuse me > even more since I wasn't working with a DB2 Version 9 cd at all and > thought I'd post to this list to see if anyone has any suggestions/ > recommendations. > > In an effort to answer some questions in advance, here's some things > that I can offer: > Why am I using Fedora 16? > We are an electronics manufacturing company and that is what my > Engineering department uses for their development purposes. I am > not married to using Fedora 16 - I have been working with > Engineering a lot in the last several months performing > virtualizations of several Linux boxes so in an effort to be of > better assistance to them, I decided to start this project using > Fedora and have learned a lot. > Am I open to other linux distros? > Sure. You've got another suggestion, please throw it my way. I'm > MORE than willing to listen > What are the specs of the Fedora box I'm using? > It's a Dell desktop, x64 with 8 Gig of RAM and a 2.8 (I'm pretty > sure) GHz processor. It's got a 2TB hard drive, but I doubt that'll matter > > If anyone would like any additional clarification/details or does > have any recommendations, please feel free to e-mail me directly as > I do only get this list in its digest form. > > Thanks in advance, > Charles Buege > > > > > > > _____________________________________________________________________ > Charles Buege | The Morey Corporation | Research and Development/IT > Special Projects > 100 Morey Drive | Woodridge, IL 60517 > Phone: 630-754-2181 | Fax: 630-754-2581 | Cell: 630-605-2077 > cbuege@xxxxxxxxxxxxx | www.moreycorp.com > > [image removed] > Follow us on Twitter! http://twitter.com/Moreycorp > > > > This e-mail, including attachments, may contain information that is > confidential and/or proprietary, and may only be used by the person > to whom this email is addressed. If the recipient of this e-mail is > not the intended recipient or an authorized agent, the reader is > hereby notified that any dissemination, distribution, or copying of > this e-mail is prohibited. If this e-mail has been delivered to you > in error, please notify the sender by replying to this message and > deleting this e-mail immediately.
