DB2 12 for z/os: migration step 26 (DSNTIJVR) vs DSNTIJPM report 22

Chris Hoelscher

DB2 12 for z/os: migration step 26 (DSNTIJVR) vs DSNTIJPM report 22
As I am revisiting the migration process after 2 years, I see the job DSNTIJVR, which seems to report views requiring regeneraton - I also note the newer report (22) added to DSNTIJMP which seems to address a similar issue

Will these 2 processes generate the same results? Or are they discovering 2 different issues with the same resolution?

Thank You,
Chris Hoelscher| HJumana Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

Perry Spada

RE: DB2 12 for z/os: migration step 26 (DSNTIJVR) vs DSNTIJPM report 22
(in response to Chris Hoelscher)

From reviewing the jobs I generated from a recent migration, Report 22 under DSNTIJPM lists expression-based indexes which was was created in DB2 9 and need to be regenerated under V12 (or V11 if running mixed data-sharing group) based on the report description . DSNTIJVR specifically lists views marked in error after V12 migration and need to be re-generated.