---
title: "ODBC database command-line utility (dpdbadmin)"
slug: "oas-ag-odbc-database-command-line-utility-dpdbadmin-3-28"
updated: 2025-07-07T13:30:59Z
published: 2025-07-07T13:30:59Z
canonical: "docs.onespan.com/oas-ag-odbc-database-command-line-utility-dpdbadmin-3-28"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.onespan.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ODBC database command-line utility (dpdbadmin)

The ODBC database command-line utility (dpdbadmin) performs several tasks needed at various times during installation and upgrade, or afterward for maintenance. Some of the commands are run automatically by the installation program, while others are run manually. The commands that are run automatically can also be run manually, for example to troubleshoot why the installation is not succeeding. [Table: dpdbadmin commands](/sec/docs/oas-ag-odbc-database-command-line-utility-dpdbadmin-3-28#Tab_dpdbadminCommands) lists the available commands.

> dpdbadmin only retrieves tables that are owned by the calling user. For this reason, you need to use either the table owner user to call dpdbadmin, or use consistently the same user for database schema creation, update, and/or validation.

| Command | Description |
| --- | --- |
| addindex | Enables indexing on searchable fields to enhance reporting performance (see [dpdbadmin addindex](/sec/docs/oas-aref-dpdbadmin-addindex-3-28)). |
| addschema | Modifies the database structure to create the tables required by OneSpan Authentication Server (see [dpdbadmin addschema](/sec/docs/oas-aref-dpdbadmin-addschema-3-28)). |
| checkauditpartitioning | Verifies whether the audit tables (vdsAuditMsg, vdsAuditMsgField) are partitioned (see [dpdbadmin checkauditpartitioning](/sec/docs/oas-aref-dpdbadmin-checkauditpartitioning-3-28)). |
| checkschema | Verifies that the required database modifications and/or table name mapping have been completed (see [dpdbadmin checkschema](/sec/docs/oas-aref-dpdbadmin-checkschema-3-28)). |
| dropindex | Drops indexing for reporting performance (see [dpdbadmin dropindex](/sec/docs/oas-aref-dpdbadmin-dropindex-3-28)). |
| dropschema | Removes all database schema modifications from the database (see [dpdbadmin dropschema](/sec/docs/oas-aref-dpdbadmin-dropschema-3-28)). |
| partitionaudittables | Partitions the existing audit tables (vdsAuditMsg, vdsAuditMsgField) on a daily basis (see [dpdbadmin partitionaudittables](/sec/docs/oas-aref-dpdbadmin-partitionaudittables-3-28)). |
| removeauditpartitioning | Removes any partitioning of the audit tables (vdsAuditMsg, vdsAuditMsgField) previously created using partitionaudittables (see [dpdbadmin removeauditpartitioning](/sec/docs/oas-aref-dpdbadmin-removeauditpartitioning-3-28)). |
| scheduleauditpartitioning | Creates a stored procedure that is scheduled to run automatically each day to create new partitions for audit data in the future (see [dpdbadmin scheduleauditpartitioning](/sec/docs/oas-aref-dpdbadmin-scheduleauditpartitioning-3-28)). |

To run the dpdbadmin utility, you need to copy dpdbadmin.exe to the computer from which the ODBC database can be accessed. You can retrieve dpdbadmin.exe from the product installation CD or the installation folder (by default %PROGRAMFILES%\VASCO\IDENTIKEY Authentication Server).