Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    23
    Provided Answers: 1

    Answered: Experience with STMT_CONC-LITERALS and triggers?

    Hi!

    DB2 10.1 on Windows. Application is Weblogic 11g on the same machine.

    We recently found that some of our transactions are greatly accelerated by changing STMT_CONC from OFF to LITERALS.

    But, when we did so, another transaction began failing:

    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-723, SQLSTATE=09000, SQLERRMC=schema.triggername;-724;54038;schema.triggername, DRIVER=4.15.113

    It looks like 724 is related, which says

    The activation of object-name of type object-type would exceed the maximum level of indirect SQL cascading.

    The trigger is aimed at updating a timestamp column to the current time when there is an update.

    This does not happen with STMT_CONC set to OFF.

    Has anyone run across this sort of thing?

    Thanks,
    Art

  2. Best Answer
    Posted by mark.b

    "Hi,

    Do you use 'after update' trigger for that?
    If yes, try to use 'before update' one instead."


  3. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Do you use 'after update' trigger for that?
    If yes, try to use 'before update' one instead.
    Regards,
    Mark.

  4. #3
    Join Date
    Oct 2010
    Posts
    23
    Provided Answers: 1
    Yes, we were using 'after', and yes, it runs well after the change to 'before'. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •