dpdbadmin removeauditpartitioning
The dpdbadmin removeauditpartitioning command removes any partitioning of the audit tables (vdsAuditMsg, vdsAuditMsgField) previously created using dpdbadmin partitionaudittables. The partitions are merged back into one big table, all data is preserved.
If you have created a scheduled stored procedure with the dpdbadmin scheduleauditpartitioning command, the stored procedure and the database event to trigger it are removed as well.
If you have a lot of audit data, this operation can take some time to complete.
This command is only supported for MariaDB.
Syntax
dpdbadmin removeauditpartitioning –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. | |
| ‑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. | |
| ‑y, ‑assume‑yes | Run the command non-interactively and assume Yes as answer to all confirmation prompts. |
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. |
Examples
To remove any partitioning of the existing audit tables in the database connected to using the data source name IAS embedded database and the user credentials digipass and digipassword type:
dpdbadmin removeauditpartitioning –u digipass –p digipassword –d "IAS embedded database"