Search found 99 matches

by rangercairns
Fri Jun 26, 2015 9:50 pm
Forum: Zend Server for IBM i
Topic: ibm_db2 1.9.7 (CPF4328)
Replies: 5
Views: 2277

Re: ibm_db2 1.9.7 (CPF4328)

FYI -- If you are a larger site administrator, and, need to isolate PHP QSQ server workload in a subsystem, please consider using i5_servermode_subsystem=NAME. ibm_db2.i5_servermode_subsystem=ADC Of course, still have to set-up subsystem, start pre-start QSQ jobs, but i5_servermode_subsystem=NAME ma...
by rangercairns
Fri Jun 26, 2015 9:38 pm
Forum: Zend Server for IBM i
Topic: ibm_db2 1.9.7 (CPF4328)
Replies: 5
Views: 2277

Re: ibm_db2 1.9.7 (CPF4328)

FYI -- A few ibm_db2 applications choose programmable switch user profile within persistent connection QSQ jobs. Connecting initially by 'generic or blank' profile, and, switching persistent QSQ job to other profiles by stored procedure, etc.. Consider using 1.9.7 i5_guard_profile. Before each reque...
by rangercairns
Fri Jun 26, 2015 9:25 pm
Forum: Zend Server for IBM i
Topic: ibm_db2 1.9.7 (CPF4328)
Replies: 5
Views: 2277

Re: ibm_db2 1.9.7 (CPF4328)

FYI -- Sites using DRDA persistent connections to remote IBM i machines (wrkrdbdire), and, experience network issues, may consider using i5_check_pconnect. The idea is simple, i5_check_pconnect runs a test against remote connection before doing your work (assumes not a disaster network). Setting hig...
by rangercairns
Fri Jun 26, 2015 8:49 pm
Forum: Zend Server for IBM i
Topic: ibm_db2 1.9.7 (CPF4328)
Replies: 5
Views: 2277

Re: ibm_db2 1.9.7 (CPF4328)

FYI -- For site with heavy web traffic, and, needing persistent connection for fastest possible speeds, please consider using 1.9.7 new persistent connection counter setting in ibm_db2.ini to recycle persistent connection once in a while. In the example below, every 1000 use of connection will close...
by rangercairns
Fri Jun 26, 2015 8:37 pm
Forum: Zend Server for IBM i
Topic: ibm_db2 1.9.7 (CPF4328)
Replies: 5
Views: 2277

Re: ibm_db2 1.9.7 (CPF4328)

FYI -- Many people do not understand difference between topics auto-commit and isolation level (i5_commit). Please refer to http://yips.idevcloud.com/wiki/index.php/PHP/DB2Connection (section Commit/Isolation level control). Briefly, i5_commit=0-4 controls isolation level, which, when uses by ALL pr...
by rangercairns
Fri Jun 26, 2015 8:29 pm
Forum: Zend Server for IBM i
Topic: ibm_db2 1.9.7 (CPF4328)
Replies: 5
Views: 2277

ibm_db2 1.9.7 (CPF4328)

There have been some modernization default changes in ibm_db2 1.9.7. Some, older database site may experience issues (CPF4328), you can return to old behaviours with settings in the ibm_db2.ini file (see older IBM i tables — below). IBM i ibm_db2.ini defaults changed: 1) Default setting ibm_db2.ini ...
by rangercairns
Fri Sep 26, 2014 6:08 pm
Forum: Zend Server for IBM i
Topic: simplexml_load_string error when '&' is in the parameter dat
Replies: 17
Views: 6833

Re: simplexml_load_string error when '&' is in the parameter

Alan pinged me about oyur cdata issue ... He says that CDATA works under Apache but not under PHP-CLI. Customer ... I run the job from a browser (ok), but NOT when I run it as CLI So wild guess using 99% rule of PASE works here, but not there ... problem is CSSID settings. Porbably looks like this: ...
by rangercairns
Tue Apr 01, 2014 3:40 pm
Forum: Zend Server for IBM i
Topic: Apache job hanging when shutting down Zend Server
Replies: 3
Views: 3894

Re: Apache job hanging when shutting down Zend Server

>>> ... waiting for QSQSRVR to complete some work, yes? Correct. Still missing data (sigh) ... Unfortunately, we have only 1/2 stack equation to understand hang, to wit, php-cgi<>QSQSRVR are a pairing of jobs (server mode), therefore we need to see both php/QSQ job stacks to understand a hang of thi...
by rangercairns
Mon Mar 24, 2014 4:18 pm
Forum: Zend Server for IBM i
Topic: Apache job hanging when shutting down Zend Server
Replies: 3
Views: 3894

Re: Apache job hanging when shutting down Zend Server

we can only speculate due to lack of data ... guess #1) 'hung' php-cgi is a worker job, waiting to finish an operation (SQL operation uncompleted, XMLSERVICE called customer program msg qsysopr, etc.) guess #2) 'hung' php-cgi is mother job, waiting for missing php-cgi child exited without leaving ex...
by rangercairns
Mon Aug 12, 2013 2:32 pm
Forum: Zend Server
Topic: i5_libl option is apparently not working.
Replies: 4
Views: 2049

Re: i5_libl option is apparently not working.

Not short sighted, more near sighted, but i will add a i5_curlib next release. Meantime, i5_libl and i5_curlib function easy on your own ... $naming = array("i5_naming"=>DB2_I5_NAMING_ON) $conn = db2_connect("*LOCAL","DRAMA","GUY",$naming); $chglibl = "CHGLIBL LIBL(QTEMP FRED)" $sobig1 = strlen($chg...