dpdbadmin dropindex
- 08 Jan 2025
- 1 Minute à lire
- SombreLumière
- PDF
dpdbadmin dropindex
- 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 dropindex command is used to drop indexing on searchable fields which were added using dpdbadmin addindex to enhance report performance.
Syntax
dpdbadmin dropindex -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 drop the index to level 1 in the database using the data source name IAS embedded database and the user credentials digipass and digipassword type:
dpdbadmin dropindex –u digipass –p digipassword –d "IAS embedded database" –level 1
Cet article vous a-t-il été utile ?