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) against the PPI indexes.
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
