Releasing LOB space in Microsoft SQL Server databases

You can release the large object (LOB) storage in the Microsoft SQL Server database.

Before you begin

Plan downtime for upgrading HCL Launch and releasing LOB space.

About this task

Release LOB storage for Microsoft SQL Server database using the following steps:


  1. Set the experimental.vcUpgrade.enabled=true parameter in the conf/server/ file.
  2. Restart the HCL Launch server.
  3. Check on the progress of the conversion:
    select count(*) from vc_persistent_record where persistent_data is not null

    The compression process is complete when the row count reported by the query is 0.

  4. Check the database size:
    EXEC sp_spaceused @updateusage = N'TRUE';
  5. Compress the database table:
    DBCC SHRINKDATABASE (dbname, 0);

What to do next

  1. Verify that the space is reduced:
    EXEC sp_spaceused @updateusage = N'TRUE';
  2. Set the experimental.vcUpgrade.enabled parameter back to false in the conf/server/ file.