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:
|
| ‑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. |
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"