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
Article ID: 227680
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
Feedback
Yes
No
Powered by
