Re: Remote db2_connect in PHP

[Michael Ryan <michaelrtr@xxxxxxxxx>]

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.