--- title: "dpdbadmin scheduleauditpartitioning" slug: "oas-aref-dpdbadmin-scheduleauditpartitioning-3-29" updated: 2026-01-14T13:06:59Z published: 2026-01-14T17:05:15Z canonical: "docs.onespan.com/oas-aref-dpdbadmin-scheduleauditpartitioning-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 scheduleauditpartitioning The dpdbadmin scheduleauditpartitioning command is used to have new partitions for the audit tables (vdsAuditMsg, vdsAuditMsgField) created on a daily basis in the future. It creates a stored procedure that is scheduled to run automatically each day at a specified time. This is required, because MariaDB does not create such partitions automatically. Execute this command after you have created the partitions for the existing data using dpdbadmin partitionaudittables (see [dpdbadmin partitionaudittables](/sec/docs/oas-aref-dpdbadmin-partitionaudittables-3-29)). You can schedule new partitions to be created only if you initially created partitions on a daily basis (with ‑range daily). If you created partitions on a monthly basis (‑range monthly), at the maximum 12 partitions in total will be kept. As a consequence you cannot use dpdbadmin scheduleauditpartitioning to automatically create additional partitions. This command is only supported for MariaDB. The stored procedure is triggered by a database event, which requires the event scheduler to be running. If the database event scheduler is disabled, dpdbadmin scheduleauditpartitioning issues a respective warning. ## Syntax dpdbadmin scheduleauditpartitioning –d dsn –scheduletime time[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. | | ‑scheduletime | time | Required. Specifies the time (UTC) of the day when a new daily partition should be created. Set this to a daytime in the future. Format: hh:mm | | ‑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. | | 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. | | 18 | The application cannot establish a connection, because the database is unreachable or unavailable. | | 19 | The specified DSN is not configured. | ## Examples To add the stored procedure to the database and schedule it to run each day at 20:00: dpdbadmin scheduleauditpartitioning –d "IAS embedded database" –scheduletime 20:00 ## Additional considerations You can remove the partitions and merge the data back into one big table again using the dpdbadmin removeauditpartitioning command (see [dpdbadmin removeauditpartitioning](/sec/docs/oas-aref-dpdbadmin-removeauditpartitioning-3-29)). This will also delete the stored procedure created by dpdbadmin scheduleauditpartitioning.