ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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