---
title: "How to: Condense XACCLOCK Table"
description: "# How to: Condense XACCLOCK Table In IBM Controller, the **XACCLOCK** table records company lock activity each period. As this table grows over time, it can affect the efficiency of the database, particularly noticeable in larger databases. To address this, IBM…"
url: "https://www.aramar.co.uk/knowledge-share/ibm-controller/how-to-condense-xacclock-table/"
updated: "2025-09-16"
category: IBM Controller
---

# How to: Condense XACCLOCK Table

# How to: Condense XACCLOCK Table

In IBM Controller, the **XACCLOCK** table records company lock activity each period. As this table grows over time, it can affect the efficiency of the database, particularly noticeable in larger databases.

To address this, IBM Controller version **11.1.11** introduces a new feature: **Condense XACCLOCK Table**.

### What does it do?

The function reduces the volume of records stored in the XACCLOCK table without impacting the integrity of your locked data. This means you retain all the essential lock information but avoid the performance issues caused by unnecessary build-up.

### Where to find it

You’ll find this feature under the **Optimize Database** menu in Controller Classic.

![](https://www.aramar.co.uk/wp-content/uploads/2025/08/Screenshot-2025-08-26-at-12.15.03-1005x1024.png)

### How it works

When you run **Condense XACCLOCK Table**, the system condenses records for all periods **up to and including the period you select**. After completion, your database is leaner and more efficient, with no detrimental effect on locked data.

### Learn more on our You Tube channel

[YouTube video player](https://www.youtube.com/embed/yHHFJvxFSR4?si=QlVLXIOKf0OHVPSe)

###### *Last updated: Sep 2025*