Re: Remote db2_connect in PHP

Hi Mike -

Thanks for the reply. So if I have zend_optimizerplus.validate_timestamps
set to ON, and zend_optimizerplus.revalidate_freq set to 2 (both defaults I
believe), then a script will be reloaded if the date/save time of the script
file differs by 2 seconds or more from the last save date/time of the script
file? Am I understanding that correctly?

- Michael

On Wed, Jun 16, 2010 at 3:38 PM, Mike Pavlak <Mike.Pavlak@xxxxxxxx> wrote:

Michael,

Here is where you can manipulate the script caching:

Server Setup -> Components -> Zend Optimizer+ -> Directives ->
zend_optimizerplus.validate_timestamps

This directive should be set to ON to enable the script cache to check
for time stamps. The interval that a scripts stays in cache is
determined by this directive on the same page:

zend_optimizerplus.revalidate_freq



Regards,

Mike

mike.p@xxxxxxxx Cell: (408)679-1011 Office: (815)722-3454

Zend Server for IBM i Beta avilable at
http://www.zend.com/en/products/server/zend-server-5-new-ibmi



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Michael Ryan
Sent: Wednesday, June 16, 2010 1:16 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Remote db2_connect in PHP

I want what I want and I want it right now! :)

Ok...I see that caching is turned on...data cache and page cache.

I did try it with a renamed copy, and was facing the same problem.
But...I
fixed it. The problem is that I'm not sure how. It worked with a
technique
that I had tried yesterday and it failed. I may have been thrashing, and
then combined it with suggestions that may not have been correct or that
I
may not have implemented correctly. Here's my connect now...

<?php

function RTRGetSystemName() {
$systemname = "MYRMTSYS";
//$systemname = "*LOCAL";
return $systemname;
}

function RTRdb2Connect() {
// Establish connection to database
$systemname = RTRGetSystemName();
$username = "MYUSER";
$password = "MYPASS";

// Connect with db2 functions for everything that's NOT a program call.
$conn = db2_connect($systemname, $username, $password);
if (!$conn) {
echo 'Connection failed: '.db2_stmt_error().':'.db2_stmt_errormsg();
}
return $conn;
}

$db2connection = RTRdb2Connect();

?>

And then I use $db2connection throughout the rest of the script. This
works
fine. I've gone through permutations of db2_connect and i5_connect, but
this
simple was is the way that works. Cleaning up to do, and simplifying and
moving stuff around but it's doing what I want.

Thanks for the help Jon and Mike, and thanks to all for the suggestions.

- Michael

On Wed, Jun 16, 2010 at 1:46 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

Three identical postings - you must really want this answer Michael!!
<grin>

For me the URL is http://xxxx.com:10088/ZendServer/ - that will ask
you to sign on as the Admin and you'll find the config settings there.
I can't be more detailed because my experience in this area was with
Zend Platform and the settings are very different. But caching does
appear to be on by default - can't see any way to get the granularity
the old Platform stuff did - But Mike will be able to tell you more.

Did you try it with a renamed copy of the script?

Jon Paris

www.Partner400.com
www.SystemiDeveloper.com



On Jun 16, 2010, at 1:00 PM, web400-request@xxxxxxxxxxxx wrote:

Where are these settings maintained? How do I view/change them?

Thanks...

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.