The ODBC database command-line utility (dpdbadmin) performs several tasks needed at various times during installation and upgrade, or afterward for maintenance. Some of the commands are run automatically by the installation program, while others are run manually. The commands that are run automatically can also be run manually, for example to troubleshoot why the installation is not succeeding. Table: dpdbadmin commands lists the available commands.
dpdbadmin only retrieves tables that are owned by the calling user. For this reason, you need to use either the table owner user to call dpdbadmin, or use consistently the same user for database schema creation, update, and/or validation.
| Command | Description |
|---|---|
| addindex | Enables indexing on searchable fields to enhance reporting performance (see dpdbadmin addindex). |
| addschema | Modifies the database structure to create the tables required by OneSpan Authentication Server (see dpdbadmin addschema). |
| checkauditpartitioning | Verifies whether the audit tables (vdsAuditMsg, vdsAuditMsgField) are partitioned (see dpdbadmin checkauditpartitioning). |
| checkschema | Verifies that the required database modifications and/or table name mapping have been completed (see dpdbadmin checkschema). |
| dropindex | Drops indexing for reporting performance (see dpdbadmin dropindex). |
| dropschema | Removes all database schema modifications from the database (see dpdbadmin dropschema). |
| partitionaudittables | Partitions the existing audit tables (vdsAuditMsg, vdsAuditMsgField) on a daily basis (see dpdbadmin partitionaudittables). |
| removeauditpartitioning | Removes any partitioning of the audit tables (vdsAuditMsg, vdsAuditMsgField) previously created using partitionaudittables (see dpdbadmin removeauditpartitioning). |
| scheduleauditpartitioning | Creates a stored procedure that is scheduled to run automatically each day to create new partitions for audit data in the future (see dpdbadmin scheduleauditpartitioning). |
To run the dpdbadmin utility, you need to copy dpdbadmin.exe to the computer from which the ODBC database can be accessed. You can retrieve dpdbadmin.exe from the product installation CD or the installation folder (by default %PROGRAMFILES%\VASCO\IDENTIKEY Authentication Server).