Unsupported Features in Dynamic Cluster Tables

You cannot directly append or update data in a dynamic cluster table. To append a new member table to a dynamic cluster table, create the new member table with the data to append. Then use the CLUSTER ADD statement to add the new member to the table.

To update an individual member table in a dynamic cluster table, create the new member table with the data to append. Then use the CLUSTER REPLACE statement to replace the old member table with the new one. For more information, see Example of Refreshing a Dynamic Cluster Table with CLUSTER REPLACE .

To refresh a dynamic cluster table by removing numerous old member tables and replacing them with new member tables, create the new member tables with the data to append. Then use the CLUSTER ADD and CLUSTER REMOVE statements to first remove and then replace the old member tables with new ones. For more information, see Example of Refreshing Dynamic Cluster Tables with CLUSTER REMOVE and CLUSTER ADD.

You can still use classic server PROC SPDO CLUSTER UNDO and CLUSTER CREATE statements to refresh the member tables in a dynamic cluster table by unbinding the dynamic cluster table and then re-binding it using new member tables. This process temporarily makes the cluster table unavailable to other users, unlike the process used by the CLUSTER REPLACE and CLUSTER REMOVE / ADD statements.

Record-level locking is not allowed.

The server backup and restore utilities are not available.