| |
- Causa
- TYPE 1 INDEXES WITH SUBPAGES GREATER THAN 1 CANNOT BECOME GROUP BUFFER POOL DEPENDENT IN A DATA SHARING ENVIRONMENT
A SUBPAGES value of greater than 1 was specified on a CREATE INDEX or ALTER INDEX statement in a data sharing environment.
Type 1 indexes with a SUBPAGES value greater than 1 can only be accessed in a data sharing environment in non-group buffer pool dependent mode.
Any read or update request that would cause the index to become group buffer pool dependent will be denied with a 'resource unavailable' condition.
Only type 2 indexes or type 1 indexes with SUBPAGES 1 can become group buffer pool dependent.
- Ação do sistema
- The statement is successfully executed.
If ALTER INDEX was performed, then the index is placed in recovery pending status.
SQLSTATE: 01638
|
| |
