upgradedb Command--Upgrade a Database
The upgradedb command installs and upgrades one or all databases in the Ingres installation.
Upgradedb triggers upgradefe. For more information, see the upgradefe command description.
If upgradedb cannot upgrade the user interface catalogs for a database, it prints a warning and marks the database operative. You can then either run upgradefe directly on the database, or rerun upgradedb, specifying the database individually with the dbname parameter.
Note: Upgradedb takes a lock on iidbdb (unless you use the -c flag). Make sure rmcmd is shut down (that is, set to zero in CBF) before running upgradedb.
The upgradedb command has the following format:
upgradedb dbname |vnode::dbname[/server_class]|-all [-f product {product}] [-modify] [-c]
[-tree] [‑help]
dbname
Specifies the name of the database (one name only) to be upgraded, and if required, the
vnode and
server_class, as described in
Standard Flags and Parameters.
-all
Causes upgradedb to operate on all databases in the installation that have not already been upgraded to the new release level. With this flag, upgradedb skips any databases already at the current release level.
Note: You can specify either dbname or all, but not both.
-f product
Specifies the user interface products for which you want to upgrade the database. Allowable product names are ingres, ingres/dbd, vision, windows_4gl and nofeclients, as described in
Standard Flags and Parameters. If you omit this parameter, all Ingres tools for the database are processed.
Note: We advise, in most cases, to use the same -f command to upgrade the database that was used to create it initially. If you are upgrading a pre-6.3 database, the -fingres command upgrades your existing user interface catalogs without creating the catalogs for the Ingres tool products that were new with 6.3 (Vision and Windows 4GL).
-modify
Runs a MODIFY command only on tables that are affected by the W_DM9C94 TBL_OLD_FORMAT message. Rebuilds the tables to their current storage structure. For more information, see Release-specific Upgrade Issues in the Upgrade Guide.
Note: When using -modify, allow additional time for the upgradedb operation.
-c
Runs upgradedb concurrently from multiple sessions. To use this feature, run upgradedb on iidbdb before concurrently upgrading the user database. Specify flag -c in every upgradedb session.
-tree
Recreates query tree objects including views, procedures and rules.
-help
Displays command syntax online.
Last modified date: 08/29/2024