before db2 9.7, we had to turn to C/Java sleep functions with a wrapped stored procedure. in db2 9.7, an alternative comes out from the DBMS_ALERT.WAITONE or its peer DBMS_ALERT.WAITANY.
With special respect to Serge Rielau, who is the known db2 hero in the community. His threads on the usenet and developerworks have taught me a lot in the past 8 years. I wish I could have chance to work with him together some day. --the string in RED is some ALERT you will never receive in your system. make it unique by any means. time db2 "call... [More]