Re: Connect to DB2 with PHP
All of the documentation that I have found indicates that the DB2 Application Development Client needs to be installed before php can be built with Db2 support. I am struggling to get the development client installed because it is in rpm format and my Slack system does not use rpm's. Can anyone verify if the DB2 Application Development Client is the only way to achieve a php to DB2 connection? Is it required to use the DBI support mentioned below? Thanks, Russell Jones ANPAC -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of David Boyes Sent: Thursday, October 23, 2008 3:36 PM To: LINUX-390@VM.MARIST.EDU Subject: Re: Connect to DB2 with PHP Yes. Use the DBI support for PHP; that makes your code generic to arbitrary databases. -Original Message- From: Linux on 390 Port on behalf of Jones, Russell Sent: Thu 10/23/2008 3:15 PM To: LINUX-390@VM.MARIST.EDU Subject: Connect to DB2 with PHP Does anyone have any experience using php on linux to access DB2 on MVS? Can it be done? Thanks in advance, Russell Jones ANPAC System Programmer -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
Hello! Russ, typically Slack contains a command to translate those RPM files into TGZ ones. Look for the rpm2tgz command, and follow its instructions. As for your question regarding PHP and DB2, on that issue I'm not sure. I do know that PHP does support the MySQL database product. -- Gregg C Levine [EMAIL PROTECTED] The Force will be with you always. Obi-Wan Kenobi -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Russell Sent: Tuesday, October 28, 2008 10:24 AM To: LINUX-390@VM.MARIST.EDU Subject: Re: [LINUX-390] Connect to DB2 with PHP All of the documentation that I have found indicates that the DB2 Application Development Client needs to be installed before php can be built with Db2 support. I am struggling to get the development client installed because it is in rpm format and my Slack system does not use rpm's. Can anyone verify if the DB2 Application Development Client is the only way to achieve a php to DB2 connection? Is it required to use the DBI support mentioned below? Thanks, Russell Jones ANPAC -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of David Boyes Sent: Thursday, October 23, 2008 3:36 PM To: LINUX-390@VM.MARIST.EDU Subject: Re: Connect to DB2 with PHP Yes. Use the DBI support for PHP; that makes your code generic to arbitrary databases. -Original Message- From: Linux on 390 Port on behalf of Jones, Russell Sent: Thu 10/23/2008 3:15 PM To: LINUX-390@VM.MARIST.EDU Subject: Connect to DB2 with PHP Does anyone have any experience using php on linux to access DB2 on MVS? Can it be done? Thanks in advance, Russell Jones ANPAC System Programmer -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
Thanks, this should put me on the right track. Russell Jones ANPAC -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Stewart Thomas J Sent: Thursday, October 23, 2008 4:06 PM To: LINUX-390@VM.MARIST.EDU Subject: Re: Connect to DB2 with PHP With more recent versions of DB2, a TCP/IP based listener is built right in, if configured by your DB2 admins. I can do a netstat on our z/OS system and all of the DB2 for z/OS subsystems are listening on some ports we defined. I can connect directly to DB2 from say, a WebSphere server on Linux box using a Type 4 JDBC driver. So if it you have the right driver (don't know what exists for PHP on Linux besides what others have mentioned) and right DB2 on z/OS setup, you can go straight into DB2 without needing something like DB2 Connect. Since I brought it up, this link from IBM has a PDF that explains the PHP for z/OS to DB2 interface in one of the chapters: http://www-03.ibm.com/servers/eserver/zseries/zos/unix/ported/php/index. html -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Rich Smrcina Sent: Thursday, October 23, 2008 3:35 PM To: LINUX-390@VM.MARIST.EDU Subject: Re: Connect to DB2 with PHP Jones, Russell wrote: Thanks, Is there a listener that has to be set up on the DB2 side? Is DB2 Connect required? Russell Jones ANPAC Traditionally DB2 Connect has been a requirement, I don't know if that requirement has changed in recent releases. If you're going to run PHP right on z/OS (like Thomas mentioned), then it probably just talks directly to the database. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2009 - Orlando, FL - May 15-19, 2009 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
I don't have experience from Linux, but PHP on z/OS has a DB2 driver. Just wanted to make sure you knew that. So you could do your PHP-ing on z/OS (if feasible) or an ugly solution might be to do a PHP to PHP call from Linux to z/OS. Although I'm guessing there is some kind of driver to remotely call into DB2 from Linux directly that someone will point out. __ Tom Stewart Infrastructure Analyst John Deere - z/OS Support Services em: [EMAIL PROTECTED] __ -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Russell Sent: Thursday, October 23, 2008 2:16 PM To: LINUX-390@VM.MARIST.EDU Subject: Connect to DB2 with PHP Does anyone have any experience using php on linux to access DB2 on MVS? Can it be done? Thanks in advance, Russell Jones ANPAC System Programmer -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
Stewart Thomas J wrote: I don't have experience from Linux, but PHP on z/OS has a DB2 driver. Just wanted to make sure you knew that. So you could do your PHP-ing on z/OS (if feasible) or an ugly solution might be to do a PHP to PHP call from Linux to z/OS. Although I'm guessing there is some kind of driver to remotely call into DB2 from Linux directly that someone will point out. __ Tom Stewart Infrastructure Analyst John Deere - z/OS Support Services em: [EMAIL PROTECTED] __ I'm fairly certain PHP as a set of DB2 functions. My guess is that they will require the DB2 client to be installed to function properly. If the client is set up properly and can return data via the command line or control center (whatever they're calling it these days), then PHP should return data. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2009 - Orlando, FL - May 15-19, 2009 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
Thanks, Is there a listener that has to be set up on the DB2 side? Is DB2 Connect required? Russell Jones ANPAC -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Rich Smrcina Sent: Thursday, October 23, 2008 2:44 PM To: LINUX-390@VM.MARIST.EDU Subject: Re: Connect to DB2 with PHP Stewart Thomas J wrote: I don't have experience from Linux, but PHP on z/OS has a DB2 driver. Just wanted to make sure you knew that. So you could do your PHP-ing on z/OS (if feasible) or an ugly solution might be to do a PHP to PHP call from Linux to z/OS. Although I'm guessing there is some kind of driver to remotely call into DB2 from Linux directly that someone will point out. __ Tom Stewart Infrastructure Analyst John Deere - z/OS Support Services em: [EMAIL PROTECTED] __ I'm fairly certain PHP as a set of DB2 functions. My guess is that they will require the DB2 client to be installed to function properly. If the client is set up properly and can return data via the command line or control center (whatever they're calling it these days), then PHP should return data. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2009 - Orlando, FL - May 15-19, 2009 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
Yes. Use the DBI support for PHP; that makes your code generic to arbitrary databases. -Original Message- From: Linux on 390 Port on behalf of Jones, Russell Sent: Thu 10/23/2008 3:15 PM To: LINUX-390@VM.MARIST.EDU Subject: Connect to DB2 with PHP Does anyone have any experience using php on linux to access DB2 on MVS? Can it be done? Thanks in advance, Russell Jones ANPAC System Programmer -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
Jones, Russell wrote: Thanks, Is there a listener that has to be set up on the DB2 side? Is DB2 Connect required? Russell Jones ANPAC Traditionally DB2 Connect has been a requirement, I don't know if that requirement has changed in recent releases. If you're going to run PHP right on z/OS (like Thomas mentioned), then it probably just talks directly to the database. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2009 - Orlando, FL - May 15-19, 2009 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
Re: Connect to DB2 with PHP
With more recent versions of DB2, a TCP/IP based listener is built right in, if configured by your DB2 admins. I can do a netstat on our z/OS system and all of the DB2 for z/OS subsystems are listening on some ports we defined. I can connect directly to DB2 from say, a WebSphere server on Linux box using a Type 4 JDBC driver. So if it you have the right driver (don't know what exists for PHP on Linux besides what others have mentioned) and right DB2 on z/OS setup, you can go straight into DB2 without needing something like DB2 Connect. Since I brought it up, this link from IBM has a PDF that explains the PHP for z/OS to DB2 interface in one of the chapters: http://www-03.ibm.com/servers/eserver/zseries/zos/unix/ported/php/index.html -Original Message- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Rich Smrcina Sent: Thursday, October 23, 2008 3:35 PM To: LINUX-390@VM.MARIST.EDU Subject: Re: Connect to DB2 with PHP Jones, Russell wrote: Thanks, Is there a listener that has to be set up on the DB2 side? Is DB2 Connect required? Russell Jones ANPAC Traditionally DB2 Connect has been a requirement, I don't know if that requirement has changed in recent releases. If you're going to run PHP right on z/OS (like Thomas mentioned), then it probably just talks directly to the database. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2009 - Orlando, FL - May 15-19, 2009 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
