modifyfe Command—Modify Storage Structure of Catalog
The modifyfe command modifies the storage structure of catalogs for Ingres querying and reporting tools such as Vision, Applications-By‑Forms, or OpenROAD. For more information on these user interface catalogs, see the Database Administrator Guide.
The modifyfe command (like upgradedb) takes an exclusive lock on the database.
Typically, you do not issue the modifyfe command directly; it is called by the upgradedb utility to perform the required catalog updates. For information on using upgradedb and modifyfe to upgrade the installation, see the Upgrade Guide.
The modifyfe command has the following format:
modifyfe dbname |vnode::dbname[/server_class] [-uusername] [+w|-w] {product}
dbname
Specifies the name of the database containing the catalogs to be modified, and if required, the
vnode and
server_class, as described in
Standard Flags and Parameters (see page
Standard Flags and Parameters).
-uusername
Specifies the effective user, as described in
Standard Flags and Parameters (see page
Standard Flags and Parameters). If you want to modify a database you do not own, you must use this flag to specify the user name of the DBA.
+w|-w
Waits (+w) or does not wait (-w) for the database to be free (not in use). The default is -w.
If you specify -w or if you do not specify this flag, then modifyfe aborts immediately if the database is not free (that is, another session has an exclusive connection).
If you specify +w then modifyfe waits for anyone with an exclusive connection to disconnect, then proceeds.
product
Specifies the products for which you want to modify catalogs. Valid product names are ingres, ingres/dbd, vision, and windows_4gl, as described in
Standard Flags and Parameters (see page
Standard Flags and Parameters).
If you omit this parameter, all user interface catalogs are modified.