---
title: "dpdbadmin scheduleauditpartitioning"
slug: "oas-aref-dpdbadmin-scheduleauditpartitioning-3-28"
updated: 2025-10-13T10:50:17Z
published: 2025-10-13T10:52:13Z
canonical: "docs.onespan.com/oas-aref-dpdbadmin-scheduleauditpartitioning-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.

# 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-28)). 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-28)). This will also delete the stored procedure created by dpdbadmin scheduleauditpartitioning.