Home
Administering
Learn how to administer settings in HCL DevOps Deploy (Deploy) elements and communication between the elements.
Managing data
Releasing VC LOB space
You can compress the amount of large object (LOB) storage space that Deploy uses in the vc_persistent_record database table.
Releasing LOB space in Microsoft SQL Server databases
You can release the large object (LOB) storage in the Microsoft SQL Server database.

Administering
Learn how to administer settings in HCL DevOps Deploy (Deploy) elements and communication between the elements.
- Backup and recover
  You can back up and recover the contents of your HCL DevOps Deploy (Deploy) installation.
- High availability and failover
  You can configure clustered HCL DevOps Deploy (Deploy) servers, and agents for high availability. You can also configure agents and agent relays for failover.
- Setting up high-availability clusters
  To configure a high-availability cluster, you store shared files on network storage. Then, you configure multiple servers, set each server to access the same files and database, and configure a load balancer to distribute the traffic between the servers.
- Adding cold standby servers
  You can add cold standby servers to serve as a backup server or for disaster recovery. You must start the secondary server or servers when the active server fails, and network traffic is routed to the secondary servers.
- Server settings and configuration
  After you install HCL DevOps Deploy (Deploy), you can modify the server configuration and configure more options.
- Setting user preferences
  Each user can specify display options for the server, including the language for the server and how the server shows times and dates.
- Agents and agent relay configuration
  After you install an agent for HCL DevOps Deploy (Deploy), you can modify its configuration or create an agent relay to facilitate communication to remote relays.
- Licensing
  HCL DevOps Deploy (Deploy) provides a 60-day license-free evaluation period. To use all product features after the evaluation period, you must have a license.
- Setting up the wizard for new users
  HCL DevOps Deploy (Deploy) includes a wizard to help users become familiar with the procedures and steps in creating a deployment. Some configuration is required before the wizard can be used.
- Customizing the table views
  Customize a table view in the HCL DevOps Deploy (Deploy) application by hiding or showing, and reordering of the table columns.
- Managing data
  - Migrating Codestation from filesystem repositories to S3 repositories
    Migrate your Codestation artifacts from filesystem to S3 using the S3 migrator tool.
  - Relocating CodeStation
    You can move the CodeStation artifacts to a different location on the server.
  - Caching artifacts on agent relays
    Agent relays can cache downloaded artifacts. Caching artifacts in this way improves performance because agents retrieve artifacts from agent relays instead of from the server.
  - Releasing VC LOB space
    You can compress the amount of large object (LOB) storage space that Deploy uses in the vc_persistent_record database table.
    - Releasing LOB space in Oracle databases
      You can release the large object (LOB) storage in the Oracle databases.
    - Releasing LOB space in MySQL or Maria databases
      You can release the large object (LOB) storage in the MySQL or Maria databases.
    - Releasing LOB space in Microsoft SQL Server databases
      You can release the large object (LOB) storage in the Microsoft SQL Server database.
    - Releasing LOB space in DB2 databases
      You can release the large object (LOB) storage in the DB2 database.
  - Scanning and removing orphaned Codestation blob files
    The csorphanscan tool in the /bin directory scans for orphaned Codestation blob files and relocates them to an orphan’s directory.
  - Cleaning up targets

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 DevOps Deploy (Deploy) and releasing LOB space.

About this task

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

Procedure

Set the versioned_config.upgrade.enabled=true parameter in the conf/server/installed.properties file.
Restart the Deploy server.
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.

Check the database size:

EXEC sp_spaceused @updateusage = N'TRUE';

Compress the database table:

DBCC SHRINKDATABASE (dbname, 0);
DBCC SHRINKDATABASE (dbname);

What to do next

Verify that the space is reduced:
```
EXEC sp_spaceused @updateusage = N'TRUE';
```
Set the versioned_config.upgrade.enabled parameter back to false in the conf/server/installed.properties file.