Where is the error log of an AS/400 trigger?

25 pts.
Tags:
AS/400 errors
AS/400 triggers
IBM iSeries
Trigger failure
  • when a trigger added to a file on the iseries generate execution errors the log of the program where it is ? 
  • if the trigger program has an internal list where I look?
Gracias por su ayuda

Software/Hardware used:
ISERES 5.3 RPG

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    That depends... What kind of trigger -- SQL or external? What kind of job -- interactive, batch or server (e.g., ODBC)? What kind of error -- did the trigger programming run into an error or did DB2 encounter an error when trying to invoke the trigger or when processing the file? Was there any trigger programming that handled errors, e.g., to direct spooled debug output with OVRPRTF or other mean? Tom
    125,585 pointsBadges:
    report
  • WilsonAlano
    Hi, Triggers are fired by a system task aso any error will logged on the joblog of the job that made the operation over the file. If the job is interactive, DSPJOBLOG will contains any trigger error. Regards, Wilson
    2,485 pointsBadges:
    report
  • TomLiotta
    ...any error will logged on the joblog of the job that made the operation over the file. Unfortunately, that's not totally true. First, an error will not be logged in a joblog if the error and message are handled and removed, which should be a reasonably common practice (though it's not). Numerous "errors" are expected, such as existence of temporary objects in QTEMP. But more importantly for debugging, a trigger failure in a server job, e.g., *DATABASE, may report errors through spooled dump or log report output. This will most often not be created under the server job. More likely it will be created under a separate QPRTJOB job for the user running the client function. ...unless the job or the trigger program has previously issued a OVRPRTF for SPLFOWN(*JOB) or taken similar action. That's why it can be important to know details such as "what kind of job" when someone can't determine where output might be. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following