Trigger performance DB2 v6 OS/390 
Author Message
 Trigger performance DB2 v6 OS/390

**** Post for FREE via your newsreader at post.usenet.com ****

We've created a simple before update trigger to set a timestamp so we can
avoid modifying legacy code (see below), however in tests we've found it
takes 3 times the CPU as doing the same thing through SPUFI DDL, I expected
a bit of performance hit but this seems extreme, anybody have any similar
experience?

The trigger itself doesn't do any I/O or create a transition table so I
don't know were the resources are being consumed...

 CREATE TRIGGER TRANTRIG
   NO CASCADE BEFORE UPDATE ON TRIG_TRAN_LOG
   REFERENCING NEW AS N
   FOR EACH ROW MODE DB2SQL
      BEGIN ATOMIC
         SET N.LAST_UPDT_TMESTMP = CURRENT TIMESTAMP;
      END#

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
                      http://www.***.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



Tue, 11 May 2004 04:41:13 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DB2 v6.1 os/390 - DELETE BEFORE - Trigger question

2. Trigger working in DB2 for NT but not in DB2 on an OS/390-machine

3. DB2 V6.1 OS/390 - LIKE predicat with CASE expression

4. DB2 V6.1, OS/390 - LIKE predicat with CASE expression - problem

5. REORG Problems (DB2 V6.1 OS/390)

6. Net.Data V2R2 on OS/390 and DB2 V6

7. DB2 V6.1 OS/390 - Drop or add tablespace partitions

8. DB2 v6 OS/390 SMP/E zones?

9. Problem with BLOBs (DB2 V6.1 on OS/390)

10. Sybase stored procs converting to DB2 OS/390 V6

11. REORG Unload External, on DB2 V6 for OS/390

12. Q: DB2 v6 for OS/390, ALTER INDEX + REORG


 
Powered by phpBB® Forum Software