Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    5

    Unanswered: Validate Multiple Views using a SQL script

    We have Db2 9.7 here and added a column in one of the table. This particular table has a summary table on top

    i.e. CREATE SUMMARY TABLE TOP_TABLE AS SELECT * FROM BASE_TABLE

    Our problem is, we found more views (almost 40) use the summary table in the SELECT queries and now shows status as X. Is there any easier way to set the status back to N (normal I guess?) without dropping / recreating the view(s)? We don't want to drop / re-create and mess things up further

    Any help would be appreciated.

    Thanks
    MMe

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    You don't need to drop the views. Just create them again. You'll get a warning that an inoperativ view has been replaced.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check out SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()

Posting Permissions

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