Release Compatibility

This appendix discusses the compatibilities of various releases of Ingres with the current release.

Note: All nodes accessed by Ingres Star must be running Release 6.4 or higher.

It also discusses using the upgradedb and upgradefe utilities with Ingres Star.

Previous Topic

Next Topic

Utilities for Updating a Release 6.4 Star Database

Use the upgradedb and upgradefe utilities to update a Release 6.4 Star database to the current release.

The following sections discuss Ingres Star-specific usage of these conversion utilities. For complete details on using upgradedb and upgradefe, see the Migration Guide.

Previous Topic

Next Topic

Ingres Star and Upgradedb

Upgradedb converts distributed databases. You can specify the distributed database name with or without the /star flag.

You can run upgradedb regardless of whether the Star Server is running. However, if you use upgradedb without a Star Server, all tools catalog upgrades are skipped, and you must later run upgradefe through a Star Server to upgrade the tools catalogs.

Upgradedb cannot be used on coordinator databases.

Previous Topic

Next Topic

Upgradedb Command—Update a Distributed Database

The upgradedb command for distributed databases has the following format:

upgradedb distdbname [/star] | -all [-f product {product}]

Previous Topic

Next Topic

Examples: Upgradedb

This command upgrades distributed database mystardb and assures that all legal tools catalogs are upgraded (or created if they do not already exist). This is the most common use of upgradedb.

upgradedb mystardb

or

upgradedb mystardb/star

This command upgrades distributed database mystardb and bypasses upgrade operations on any tools catalogs that may exist in the database:

upgradedb mystardb -f nofeclients

or

upgradedb mystardb/star -f nofeclients

This command upgrades all databases in the installation, including any distributed databases that may reside in the installation. It upgrades only the core product tools catalogs (or creates them if they do not exist):

upgradedb -all -f Ingres

This command upgrades all databases in the installation, including any distributed databases that may reside in the installation. It upgrades or creates the tools catalogs for all products that this installation is authorized to use:

upgradedb -all

Previous Topic

Next Topic

Ingres Star and Upgradefe

Upgradefe converts or creates tools catalogs for any of the distributed Ingres products. These include Ingres, Ingres/DBD, and Ingres Vision. You may invoke upgradefe directly, using the command syntax described below. Upgradefe is also invoked indirectly by upgradedb.

A Star Server must be running in order to run upgradefe on a distributed database.

Upgradefe cannot be used on coordinator databases.

Previous Topic

Next Topic

Upgradefe Command—Update Tools Catalogs

The upgradefe command for distributed databases has the following format:

upgradefe distdbname/star {product}

Previous Topic

Next Topic

Examples: Upgradefe

upgradefe mystardb/star

Assure that the tools catalogs required for the OpenROAD product for distributed database mystardb are upgraded (or created if they do not already exist):

upgradefe mystardb/star windows_4gl


© 2007 Ingres Corporation. All rights reserved.