Migration step 25: Verify views: DSNTIJVR

During migration to Db2 13, some views might be marked with view regeneration errors. If any views are marked with view regeneration errors, you can regenerate those views again.

Procedure

Begin general-use programming interface information.To identify views that are marked with regeneration errors, and generate the ALTER VIEW REGENERATE statements to correct them:

  1. Run job DSNTIJVR.
  2. Use dynamic SQL processing tools, such as SPUFI or DSNTEP2, to process any statements that are generated by DSNTIJVR.End general-use programming interface information.