--- title: "dpdbadmin checkauditpartitioning" slug: "oas-aref-dpdbadmin-checkauditpartitioning-3-29" updated: 2026-01-12T10:22:21Z published: 2026-01-15T08:08:04Z canonical: "docs.onespan.com/oas-aref-dpdbadmin-checkauditpartitioning-3-29" --- > ## 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. # dpdbadmin checkauditpartitioning The dpdbadmin checkauditpartitioning command is used to verify whether the audit tables (vdsAuditMsg, vdsAuditMsgField) are partitioned (using the dpdbadmin partitionaudittables command). It also verifies if you have created a scheduled stored procedure with the dpdbadmin scheduleauditpartitioning command. This command is only supported for MariaDB. ## Syntax dpdbadmin checkauditpartitioning –d dsn [OPTION]... where dsn is the ODBC data source name. ## Command-line options | Option | Parameter | Description | | --- | --- | --- | | ‑d, ‑dsn | dsn | Required. ODBC data source name (DSN), e.g. "IAS embedded database". | | ‑h, ‑help | | Show help and usage information. | | ‑l, ‑log | logfile | Write output to logfile. | | ‑p, ‑password | dbpassword | Optional. Password of the database administrator. This option can be omitted if the database administrator account has a blank password. | | ‑q | | Quiet mode. Do not output commentary text. | | ‑r, ‑range | range | Optional. Verify whether the audit tables are partitioned using the respective time range. Possible values: - daily - monthly | | ‑synctimeout | timeout | The timeout in seconds to synchronize with other dpdbadmin instances. | | ‑u, ‑user | dbusername | Optional. User name of a database administrator (if required). | | ‑unlockdb | | Unlock a database synchronization lock used to protect the database schema against concurrent schema modifications. | | ‑v, ‑verbose | | Print verbose output. Can be specified twice to be more verbose. | ## Exit codes | Exit code | Description | | --- | --- | | 0 | The command completed successfully. The audit table partitioning is enabled and correctly set up. | | 1 | The command has been aborted by the user. | | 2 | The command failed due to an unspecified error. | | 3 | The specified parameters are invalid. | | 4 | The command failed due to an error. | | 5 | The database authentication failed. | | 14 | The audit tables are not partitioned. To enable partitioning, run the dpdbadmin partitionaudittables command. | | 15 | The audit tables are partitioned, but either the daily partition event and/or the stored procedure has not been created. To create them, run the dpdbadmin scheduleauditpartitioning command. | | 16 | The audit tables are partitioned, but the database event scheduler is disabled. | | 17 | The audit tables are partitioned, but the specified range and the actual range mismatch. | | 18 | The application cannot establish a connection, because the database is unreachable or unavailable. | | 19 | The specified DSN is not configured. | ## Examples To verify the existing audit tables in the database that is connected via the data source name IAS embedded database and the user credentials digipass and digipassword type: dpdbadmin checkauditpartitioning –u digipass –p digipassword –d "IAS embedded database"