After Cap2212 was applied the following warning was received in the Explain output.
PPA 20.0.04 --------- Plan Analyzer Enhanced Explain ------------- Page 1
DATE 01-19-23 TIME 15:42
PP217W: VSAM has been replaced with recommendation to create an index.
VSAM has been replaced with a recommendation to create an index for DB2
catalog system table. Once the index has been created, RUNSTATS
should be executed against the new index followed by binds of the
PPA/SQE plan and packages to utilize the new access paths.
SYSFIELDS (TBCREATOR, TBNAME, NAME)
This new catalog index will improve performance in these product areas:
- Quick Explain
- Explain Strategy Services
- Statement Reporting
Release : 20.0
Removing the VSAM= Card from the Explain resolved the problem by removing the message warning issue.