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.










