search cancel

Virtual Index Maintenance

book

Article ID: 227680

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS

Issue/Introduction

Re Virtual Indexes.
Can not select (Cmd) the PPI indexes as shown. 

Environment

Release : 20.0

Component : CA Plan Analyzer for DB2 for z/OS

Resolution


DB2 only supports Type-2 non partitioned indexes 
and data partitioned secondary indexes (DPSI) as virtual indexes. 

See the INDEXTYPE column description in the DSN_VIRTUAL_INDEXES table 
at

DSN_VIRTUAL_INDEXES