472,145 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

iSeries DB2/UDB V5R2 - troubleshooting system triggers

Hi Folks:

I've got this scenario:

User table/file....external triggers declared for *AFTER *INSERT, *AFTER
*UPDATE, and *BEFORE *DELETE. The 3 external triggers call a SQLRPG ILE
stub program which catches the trigger buffer and drops it into a data
structure, then the SQLRPG ILE program calls a SQL stored proc with the
right parameter list. The SQL stored proc actually does the work, which
includes inserting or updating rows in a change queue table.

The problem I'm having is that there may be 50 rows in the change queue, but
if I query the table the triggers are attached to I find that maybe 100 rows
have an updated date column (they should be 1:1...each updated row in the
user table should have one corresponding row in the change queue
table...there are almost no deletes). Apparently, the triggers are
encountering errors in some cases when they fire. Since the application
software does not run under commitment control, the application operation
completes OK, but the trigger operation does not. Or this is my best guess

So, here's the question: where would I look to find errors from triggers
regardless of what called them on an iSeries platform? Is there one
location or CL command that I can use to scan all interactive and batch job
logs for trigger errors?

Any suggestions greatly appreciated!

Nov 12 '05 #1
0 1667

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Thad Rizzi | last post: by
1 post views Thread by Yanik Reid | last post: by
1 post views Thread by tom.eeraerts | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.