db2_connect & db2_pconnect problem

[ahaithcox]

Happy Monday Alan. Looks like the version of db2 is 1.9.2 on the iSeries that failed recently with db2_pconnect:

Code: Select all

Extension [ <persistent> extension #31 ibm_db2 version 1.9.2 ] {

Our development server here that we are currently running pconnect on is the exact same version.

[rangercairns]

Alan and Adam,

>> problem 1 mixing db2_connect/db2_pconnect:
Problem: There is a problem mixing db2_connect/db2_pconnect, IF you choose to use db2_pclose.
More: Technically problem exists when you do not consistently use both matching (p)connect/(p)close pairs in all scripts.
Work around: Do not use db2_pclose.
Fix: This will need a fix in an future release of ibm_db2.

>> problem 2 *LOCAL-*DEBUG:
Problem: PHP ibm_db2 version has no effect on *LOCAL-*DEBUG, as this function is purely IBM i DB2 PTFs.
Fix: Most likely your machine DB2 PTFs are out of date, so please update to latest DB2 PTF group and retry test.

[ahaithcox]

Thanks for the reply rangercairns. In all of our scripts we use either connect or pconnect exclusively. Typically, if the script has more than one call to the dB, we use pconnect and we don't ever use (p)close. I had read before about that causing issues. I will double check the PTFs, but our hardware guys say that we have the latest and the greatest.

[rangercairns]

Oh i see you already answered not using db2_pclose() in a previous post (i have to train myself to read backward in these things) ...

Another possibility comes to mind ... there is a old/bad version of the PASE libdb400.a driver that got accidentally shipped with Zend Server. I suggest you remove the stale version of libdb400.a and retry:

Code: Select all

call qp2term
> mv /usr/local/zendsvr/lib/libdb400.a /usr/local/zendsvr/lib/libdb400.a-zend


Unfortunately you will have to restart Zend Server and/or Apache instances using PHP, so FastCGI php-cgi jobs will pick up real PASE version of libdb400.a.

[rangercairns]

DB2 PTFs for *LOCAL-*DEBUG ...

Code: Select all

v6r1 SI45121
v7r1 SI45862
Fix base release beyond V7R1


[rangercairns]

Also this Yips link may be helpful for additional DB2 connection information.

http://www.youngiprofessionals.com/wiki ... Connection