Running the Upgrade

You should upgrade the database only when necessary.

This task shows you how to:

Related Topics
Upgrade Warnings
Oracle Configuration
Upgrading the Database after Installing a New Version of ENOVIA Live Collaboration

Upgrade the Database

Before you begin: Before upgrading the database, install the new ENOVIA Live Collaboration software.
  1. Enable SQL tracing as follows:

    mql< > trace type sql filename sqlupgrade.log;

  2. Modify the command line that starts MQL so that an error log is generated. For example, on Windows, change the shortcut for MQL as follows:

    ENOVIA_INSTALL\Mql.exe -stdout:c:\temp\upgrade.txt -stderr:c:\temp\upgrade.err.
    

    On UNIX, use this MQL command syntax to generate an error log:

    mql INPUTFILE 2> LOGFILE
    

  3. Set context to a System Administrator user (for example, creator). Then run the upgrade with:

    mql< > verbose on;
    mql< > upgrade;
    

To verify that the upgrade succeeded, make sure no errors resulted from running the upgrade command. To see a complete list of tables, run the validate upgrade command after the upgrade is complete (see Upgrade Analysis).

Then perform the postprocessing of the database described in Upgrade Postprocessing.