Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I get php to talk to an IBM AS/400 running DB2?

April 26, 2017db2 IBM php running talk

0

Posted

How can I get php to talk to an IBM AS/400 running DB2?

1 Answer

0

Posted

A draft of my experiences are here at http://www.php-faq.com/as400.php Basic php/db2 walkthough: http://www7b.boulder.ibm.com/dmdd/library/techarticle/scott/0614_scott.html IBM db2 on Linux How To: http://www.linuxdoc.org/HOWTO/DB2-HOWTO/index.html Nice step by step guide for db2 on Linux: http://www.e-gineer.com/instructions/installing-ibm-db2-for-php4x-with-apache13x-on-linux.phtml Tips and Techniques for DB2 Connect: http://www-1.ibm.com/servers/eserver/iseries/db2/db22drda.htm The AS/400 uses port 446 to listen for db2 requests. There’s a special section on connecting a working db2 client to an AS/400 at http://www.linuxdoc.org/HOWTO/DB2-HOWTO/db2trouble.html#AEN1242 If you get a message that says: SQL7008N REXX variable “TABLENAMEHERE” contains inconsistent data It means that the DB2 UDB for iSeries tables being accessed on the server are not being journaled. To correct the SQL7008N error, you need to start journaling your tables or change the isolation level to No Commit. The AS/