SQL/MP Messages Manual
SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-98
SQL 1636
Cause. The operation failed because the table or index has unreclaimed freespace.
This can happen if a previous ALTER TABLE or ALTER INDEX operation caused
unreclaimed freespace to be generated and a FUP RELOAD operation was not
executed.
Effect. The statement fails.
Recovery. Run FUP RELOAD to reclaim space, and reissue the request.
SQL 1637
Cause. There are several scenarios that might cause this error:
•
A split and move boundary operation deletes the data that has been copied to the
new or existing partition with a special partial purgedata request. This partial
purgedata request failed.
•
This error can also occur after a failed merge or move boundary request.
•
A reuse operation deletes the data in the reused partition. The purgedata request
failed.
Effect. The statement fails.
Recovery. Fix the file system error condition, and reissue the request.
SQL 1638
Cause. The merge or move boundary operation issued a request to start and stop key
range checking on the above named table or index partition. This request failed.
Effect. The statement fails.
Recovery. Fix the file system error condition, and reissue the request.
1636 Cannot perform requested operation because value-1 has
UNRECLAIMED FREESPACE set. Space needs to be reclaimed
before continuing.
1637 An unexpected error occurred while purging data from
value-1.
1638 An unexpected file system error occurred on value-1
while performing a Merge or Move Boundary request.