What caused the warning message PP217W and what needs to be done?
PP217W: VSAM has been replaced with recommendation to create indexes.
VSAM has been replaced with a recommendation to create indexes for 3 DB2
catalog system tables. Once the indexes have been created, RUNSTATS
should be executed against the new indexes followed by binds of the
PPA/SQE plan and packages to utilize the new access paths.
SYSDBRM (PLNAME, NAME)
SYSSTMT (PLNAME, NAME, STMTNOI, STMTNO, SECTNOI, SECTNO)
SYSFIELDS (TBCREATOR, TBNAME, NAME)
These new catalog indexes will improve performance in these product areas:
- Quick Explain
- Explain Strategy Services
- Plan Reporting
- DBRM Reporting
- Statement Reporting
- Plan/Package Utilities
The PP217W is just a warning notifying of changes/recommendations that the suggested indexes could be created on the DB2 catalog tables to improve performance.