dpdbadmin addindex
- 08 Jan 2025
- 1 Minute à lire
- SombreLumière
- PDF
dpdbadmin addindex
- 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 addindex command adds indexing on searchable fields to enhance report performance. If this command is run against the your database it will have a minor effect on authentication performance. Increasing the level of indexing will negatively affect authentication performance.
Syntax
dpdbadmin addindex –d dsn –level lvl [OPTION]...
where:
- dsn is the ODBC data source name.
- lvl is the level of indexing to apply; this should be 0, 1, or 2.
Command-line options
| Option | Parameter | Description |
|---|---|---|
| ‑audit | Modify indexing for the audit message table. | |
| ‑auditfields | Modify indexing for the audit fields table. | |
| ‑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. |
| ‑level | level | Required. Set the level of indexing to apply. Possible values:
|
| ‑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 | Quiet mode. Do not output commentary text. | |
| ‑u, ‑user | dbusername | Optional. User name of a database administrator (if required). |
| ‑v, ‑verbose | Print verbose output. Can be specified twice to be more verbose. |
Index levels 1 and 2 are not available on the auditfields table if the database is Microsoft SQL Server. This is due to an index size limitation which exists within Microsoft SQL Server.
However, index levels 1 and 2 are available on the audit table on Microsoft SQL Server.
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 add an index of level 1 to the database using the data source name IAS embedded database and the user credentials digipass and digipassword type:
dpdbadmin addindex –u digipass –p digipassword –d "IAS embedded database" –level 1
Cet article vous a-t-il été utile ?