dpdbadmin checkauditpartitioning
- 08 Jan 2025
- 1 Minute à lire
- SombreLumière
- PDF
dpdbadmin checkauditpartitioning
- Mis à jour le 08 Jan 2025
- 1 Minute à lire
- SombreLumière
- PDF
The content is currently unavailable in French. You are viewing the default English version.
Résumé de l’article
Avez-vous trouvé ce résumé utile ?
Merci pour vos commentaires
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"
Cet article vous a-t-il été utile ?