Actian X 11.1 | Propagate In-memory Updates to Disk

Database Administrator Guide > Database Administrator Guide > Updating Data in X100 Tables > MODIFY...TO COMBINE Statement--Merge and Update Data > Propagate In-memory Updates to Disk

Was this helpful?

Propagate In-memory Updates to Disk

During batch operations X100 automatically propagates the changes buffered in memory to the disk-resident table.

To do this manually, use the MODIFY...TO COMBINE statement. Doing so frees this memory, which is shown as memory.update_allocated in the vwinfo output.

Use the following SQL statement:

MODIFY table_name TO COMBINE

Last modified date: 11/09/2022