Verifying Schema Updates

For most database setups, the schema extension does not finish instantaneously after executing the addschema command. Wait several minutes for the schema extensions to replicate across the system before verifying the schema updates using checkschema.

Verifying schema updates

After performing an ODBC data store extension, wait several minutes for the schema extensions to replicate across the system.

To check whether ODBC schema updates have been completed

• Use the following command:

  dpdbadmin checkschema –u db_username –p db_password -d dsn

  where:

  • db_username is the user name of the database user account.
  • db_password is the corresponding password of db_username.
  • dsn is the ODBC data source name.

Do not continue with the installation until checkschema returns a successful result!