Search found 667 matches

by aseiden
Tue May 08, 2018 4:19 pm
Forum: Zend Server for IBM i
Topic: Library list issues
Replies: 2
Views: 623

Re: Library list issues

Longnoz, Best way to set up a liblist is via the user profile's job description, but what you did should work also. If you want the toolkit job to use the database connection to run programs in, you'll need to specify stateless mode. $obj->setOptions(array('stateless'=>true)); Try it. Alan Seiden Se...
by aseiden
Wed Dec 20, 2017 1:38 am
Forum: Zend Server for IBM i
Topic: Character set issues - random garbage characters returned
Replies: 8
Views: 2311

Re: Character set issues - random garbage characters returne

Longnoz, Working with IBM, we've found a simpler solution. In the file /usr/local/zendphp7/etc/conf.d/ibm_db2.ini (or equivalent for other versions of PHP), set this value: ibm_db2.i5_dbcs_alloc=1 and then restart the ZENDPHP7 (or equivalent) Apache instance. Or you can set this value from the Zend ...
by aseiden
Sat Dec 16, 2017 5:37 am
Forum: New Toolkit
Topic: XTOOLKIT Job ended in QSYSOPR
Replies: 2
Views: 2148

Re: XTOOLKIT Job ended in QSYSOPR

I use stateless mode, where possible, rather than stateful jobs that automatically end. When idleTimeout is used for stateful jobs, however, I don't know of a way to stop the timeout messages from appearing. I see various solutions on the web for removing certain messages automatically. E.g. https:/...
by aseiden
Sat Dec 16, 2017 5:28 am
Forum: Zend Server for IBM i
Topic: Character set issues - random garbage characters returned
Replies: 8
Views: 2311

Re: Character set issues - random garbage characters returne

Hi, Brad,

We've been seeing this issue recently. Our solution is to add a trim() in your SQL, such as

Code: Select all

select trim(myfield) as myfield
. Try it and let us know.

Alan Seiden
http://seidengroup.com
by aseiden
Sat Nov 11, 2017 3:44 am
Forum: Zend Server for IBM i
Topic: LIBL issues with UDFs
Replies: 2
Views: 2416

Re: LIBL issues with UDFs

Solution: Longnoz told me offline that his db2_connect, using i5_libl, worked after all.

Alan Seiden
http://www.seidengroup.com
by aseiden
Thu Nov 09, 2017 4:31 am
Forum: Zend Server for IBM i
Topic: LIBL issues with UDFs
Replies: 2
Views: 2416

Re: LIBL issues with UDFs

Dear Longnoz, The usual library list techniques should work. i5_libl (underneath it does CHGLIBL) JOBD (best way--set initial library list in the JOBD of the user profile) toolkit (yes, this works. If it didn't affect the library list then you may have made a mistake. Use stateless mode to work with...
by aseiden
Wed Oct 12, 2016 5:48 pm
Forum: New Toolkit
Topic: Problem with i5_pclose after Zend Server upgrade
Replies: 3
Views: 2998

Re: Problem with i5_pclose after Zend Server upgrade

Brandon, the i5_pclose ends the persistent database connection underneath. To allow PHP to regenerate the connection, add this line to /usr/local/zendsvr6/conf.d/ibm_db2.ini, then restart Zend Server:
ibm_db2.i5_check_pconnect = 1

Alan Seiden
http://www.seidengroup.com
by aseiden
Tue Jun 21, 2016 5:27 pm
Forum: Zend Server for IBM i
Topic: Toolkit simplexml_load_string parser error UTF-8
Replies: 8
Views: 4691

Re: Toolkit simplexml_load_string parser error UTF-8

Richard, the log you posted shows "A B" (with a space in between, rather than a hyphen or dash). Is that a quirk of the log or did you actually pass a space?

Thanks!
Alan
by aseiden
Tue Jun 21, 2016 5:22 pm
Forum: Zend Server for IBM i
Topic: Toolkit simplexml_load_string parser error UTF-8
Replies: 8
Views: 4691

Re: Toolkit simplexml_load_string parser error UTF-8

Thanks, Richard. I'm discussing with Rod (with whom you opened a case).
by aseiden
Fri Jun 10, 2016 2:56 am
Forum: Zend Server for IBM i
Topic: Slow PHP performance gengeneral
Replies: 4
Views: 2733

Re: Slow PHP performance gengeneral

When you use PHP-CLI (command line PHP), you're starting PHP and all its extensions from scratch. The extensions loaded by PHP.INI are what takes the time. Disable the extensions you don't need. That's the answer. Use a custom PHP.INI file if you like. Regular web-based FastCGI PHP is pre-started an...