Start of change

Migration step 26: Verify viewsStart of change: DSNTIJVREnd of change

During migration to Db2 12, 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.
End of change