db2_connect & db2_pconnect problem

General discussion on Zend Server for IBM System i

Re: db2_connect & db2_pconnect problem

Postby ahaithcox on Mon Dec 17, 2012 3:16 pm

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.
ahaithcox
 
Posts: 43
Joined: Mon Oct 03, 2011 5:22 pm

Re: db2_connect & db2_pconnect problem

Postby rangercairns on Mon Dec 17, 2012 6:51 pm

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.
rangercairns
 
Posts: 215
Joined: Fri Jul 24, 2009 6:28 pm

Re: db2_connect & db2_pconnect problem

Postby ahaithcox on Mon Dec 17, 2012 7:46 pm

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.
ahaithcox
 
Posts: 43
Joined: Mon Oct 03, 2011 5:22 pm

Re: db2_connect & db2_pconnect problem

Postby rangercairns on Mon Dec 17, 2012 8:32 pm

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
 
Posts: 215
Joined: Fri Jul 24, 2009 6:28 pm

Re: db2_connect & db2_pconnect problem

Postby rangercairns on Mon Dec 17, 2012 9:05 pm

DB2 PTFs for *LOCAL-*DEBUG ...
Code: Select all
v6r1 SI45121
v7r1 SI45862
Fix base release beyond V7R1
rangercairns
 
Posts: 215
Joined: Fri Jul 24, 2009 6:28 pm

Re: db2_connect & db2_pconnect problem

Postby rangercairns on Mon Dec 17, 2012 9:38 pm

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

http://www.youngiprofessionals.com/wiki ... Connection
rangercairns
 
Posts: 215
Joined: Fri Jul 24, 2009 6:28 pm

Previous

Return to Zend Server for IBM i

Who is online

Users browsing this forum: Yahoo [Bot] and 5 guests