473,698 Members | 2,528 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

iSeries DB2/UDB V5R2 - troubleshooting system triggers

Hi Folks:

I've got this scenario:

User table/file....externa l 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
anyway.

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!

Dave
Nov 12 '05 #1
0 1758

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
7791
by: Thad Rizzi | last post by:
My webserver is an iSeries and I want to run some PHP scripts on it using SQL to access data on the iSeries. Does anyone have any exapmles or resources on the most effective way to do this? I am rather green with PHP. Any help would be appreciated, Thad Rizzi
4
18288
by: Dave Sisk | last post by:
Hi folks: We have a script containing DDL statements to create tables and indexes, etc. On DB2 for Unix, I'd do a "db2 -tvf script_name.sql -z logfile_name.log", but I don't think that works on the iSeries. I've found in the docs that you can run DDL scripts from a client application called "iSeries Navigator". I was wondering if there's an easier way. If I just FTP the script physically onto the host, then how can I run it? (I used...
5
11554
by: Dave Sisk | last post by:
Hey folks: I'm trying to do this: CREATE TRIGGER datawhse.emp_ti AFTER INSERT ON emp REFERENCING NEW AS n FOR EACH ROW MODE DB2ROW BEGIN DECLARE v_rrn DECIMAL(15,0);
0
7143
by: Dave Sisk | last post by:
I've created a system or external trigger on an AS/400 file a.k.a DB2 table. (Note this is an external trigger defined with the ADDPFTRG CL command, not a SQL trigger defined with the CREATE TRIGGER statement.) I've also defined a SQL stored proc, and the trigger is set to call this SP. I've posted the simplified source below. I can manually call the stored proc, and the external trigger is created without any errors. However, when I do...
4
5934
by: Dave Sisk | last post by:
Here's a simple function: CREATE FUNCTION datawhse.num2cdate( inval INT) RETURNS CHAR LANGUAGE SQL BEGIN RETURN(nullif(substr(CHAR(inval +19000000),1,4)||'-'||substr(CHAR(inval +19000000),5,2)||'-'||substr(CHAR(inval +19000000),7,2)||' 00:00:00:000', '1900-01-01 00:00:00:000')); END
1
14938
by: Yanik Reid | last post by:
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error:
1
2695
by: tom.eeraerts | last post by:
Hello, I have a problem migrating an application from v5r2 to v5r3. The problem is with the prepared statements. To see what the problem is, i extracted a small piece of code and debugged the application while running it on my local window machine (IBM WSAD) but still connecting to the AS400. For the local debugging I use "com.ibm.as400.access.AS400JDBCDriver"
2
4177
by: chmmr | last post by:
Hello, I would like to ask if there are any differences between DB2 in these versions (e.g. support of triggers, Java stored procedures and such). Also, does anyone know from which DB2 AS/400 version is Java officially supported? Thank you
1
8035
by: Saharian | last post by:
Hi all, I am new to DB2. I want to configure replication between DB2 9.5-C Express and DB2 Iseries V5R2. I am maintaining a small database(around 50 tables) on local DB2 9.5. I want to keep exactly the same copy on Iseries V5R2. According to my understand of DB2 I though replication could be an option. But when I try to connect from DB2 9.5 to Iseries I get following error. CLI connection failed. SQL8002N An attempt to connect to a host...
0
9030
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8899
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8871
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6528
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5861
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4371
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4622
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2335
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2007
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.