Helix Core is now P4. Product user interfaces will be updated soon. Learn more >>

P4 CLI Reference | 2025.1

# p4 dbverify

Perform low-level verification of the database tables.

## Syntax

    p4 [g-opts] dbverify [-t db.tablename] [-U][-v]

Syntax conventions

## Description

The `p4 dbverify` command performs a series of low-level structural integrity checks on the database tables. Run this command periodically to determine if tables have become damaged.

By default, all current tables are verified. This can be computationally expensive and might require scheduled user downtime on large systems. To restrict verification to a specified table, use the name of the corresponding `db.`tablename`` file in the P4 Server root.

For a faster integrity check, use the `-U` option, which looks for tables with non-zero unlock counts. Each database table has an accompanying unlock count; when data is ready to be written to a table, the table’s unlock count is incremented and the table is locked. When the write is complete, the table is unlocked and its unlock count is decremented. If the process that writes the data does not unlock the table (or cannot, if, for example, the system goes down before the write is complete), the unlock count remains incremented.

Although the presence of a non-zero unlock count does not positively indicate corruption (and the presence of a zero unlock count does not guarantee data integrity), `p4 dbverify -U` has minimal performance impact.

Run the following commands during production downtime or quiet periods. These commands lock tables and therefore might block user commands.

Option | Table locking behavior
--- | ---
`p4 dbverify -U` | Tables are locked and unlocked one at a time as they are being checked. See p4 dbverify.
`p4 dbverify` | Tables are locked and unlocked one at a time as they are being validated.

## Options

`-t db.`tablename`` | Restrict verification to the specified table name.
`-U` | Perform a less-detailed validation
`-v` | Provide verbose information on the verification.
`g-opts` | See Global options.

## Usage notes

Can File Arguments Use Revision Specifier? | Can File Arguments Use Revision Range? | Minimal Access Level Required
--- | --- | ---
N/A | N/A | `super` available to an operator user

`p4 dbverify` is equivalent to `p4d -xv`.

Your search for returned results