Symptom
The following SQL1763N error is reported when attempting to reclaim space with REDUCE MAX.
ALTER TABLESPACE <tablespace> REDUCE MAX fails with either of the following reason codes.
SQL1763N Invalid ALTER TABLESPACE statement for table space "TABSPACE_NAME" due to reason "10"
Reason code 10 means:
The REDUCE MAX clause or the REDUCE with a specified size clause can only be used with table spaces having the Reclaimable Storage attribute and managed by automatic storage.
SQL1763N Invalid ALTER TABLESPACE statement for table space "TABSPACE_NAME" due to reason "11"
Reason code 11 means:
Table spaces without the Reclaimable Storage attribute cannot use clauses to reduce or lower the high water mark.
Read more...
Environment
Db2 v9.7 or higher
Product
Keywords
SQL1763N -1763 extent container high water mark hwm reclaimable storage , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview