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

You don't need to drop the views. Just create them again. You'll get a warning that an inoperativ view has been replaced.

Check out SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()