WARNING MESSAGE PP217W

Document ID : KB000098654
Last Modified Date : 01/06/2018
Show Technical Document Details
Issue:
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                                                
Resolution:
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.