I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files, including the monitor file have to be journalled. To stress test the performance, I am inserting 5 million records in total into the 50 files. If I remove the trigger from the 50 files, this takes 140 seconds. If I change the trigger program so that it issues a return before the write to the log file, then the time goes up to 245 seconds, which seems reasonable. If I let the trigger program write to the monitor file having ended journalling on the monitor file, then it takes 380 seconds. However, when I start journalling the monitor file, the time taken goes up to 1650 seconds (ouch). As I said previously, monitor file stores record images, so the record size is big - 3030 bytes.
I poked around with using SQL triggers, which would be easy enough to generate in an RPGIV program, But they also seem slow.
I would really like some help on this one, so if you have any idea on what I should do, please let me know.
Thanks in advance,
August 11, 2012 12:57 PM