Re: looking for zend job log

[Larry Kleinman <larry@xxxxxxxxxxxxxxxxx>]

Thanks, Alan.  I already have code similar to slide 54, which would show 
an error in the browser.  I can't rule out that there is some message 
appearing which the users are not telling us about, but I don't think that 
is the case.  I don't see anything in the error log around the time that 
the problem has happened.    I just changed the EACJOBD job description to 
produce a job log when the job ends, and I am hoping to find something 
there when this happens again.  If you have any other suggestions about 
how to trace this, I would certainly appreciate it.

Larry Kleinman
Kleinman Associates, Inc.
212-949-6469




From:   Alan Seiden <alan@xxxxxxxxxxxxxx>
To:     Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
Cc:     Larry Kleinman <larry@xxxxxxxxxxxxxxxxx>
Date:   11/15/2012 05:30 PM
Subject:        Re: [WEB400] looking for zend job log



Larry, if you're doing DB2 inserts, check out slide# 54 here:
http://www.slideshare.net/aseiden/db2-and-php-best-practices-on-ibm-i

It shows how to check for errors and to find the exact error text for 
SQL queries to ibm_db2.

If you just want PHP errors, find the PHP log at 
/usr/local/zendsvr/var/log/php.log

Alan


On 11/15/12 3:38 PM, Larry Kleinman wrote:
> Does anyone know how to change the logging level of a job submitted from 
a
> PHP script using Zend Server that runs some SQL?   I have a script that
> does an SQL insert and 99% of the time it works fine.  Occasionally, the
> record that should have been added is not there, and occasionally I get
> several of the same record instead of just one.
>
> Larry Kleinman
> Kleinman Associates, Inc.
> 212-949-6469