--- title: "dpdbadmin addindex" slug: "oas-aref-dpdbadmin-addindex-3-28" updated: 2025-10-13T10:43:13Z published: 2025-10-13T10:52:13Z canonical: "docs.onespan.com/oas-aref-dpdbadmin-addindex-3-28" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.onespan.com/llms.txt > Use this file to discover all available pages before exploring further. # dpdbadmin addindex 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: - 0. Do not apply any indexing to searchable fields. - 1. Apply standard reporting indexing to searchable fields. - 2. Apply full reporting indexing to searchable fields. | | ‑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. | | 18 | The application cannot establish a connection, because the database is unreachable or unavailable. | | 19 | The specified DSN is not configured. | ## 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