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