Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Trigger invalidated, when ??

    Guys,
    Can someone give me a hint how we can find when trigger was invalidated ??

    Thanks
    DBFinder

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Take a look at when the table was altered.

    Dave Nance

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Well,
    I believe that this trigger was invalid even before last alter on the table.

    Any other way ?

    Regards

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Have you tried using "invalid trigger" as a search on the IBM site? If not, you might be surprised what you find

    DB2 Database for Linux, UNIX, and Windows
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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