Upgrading the database with a fix or feature pack

Use this procedure to upgrade the database with a fix or feature pack.

Ensure that the fix or feature pack is applied to the environment.

  1. Right-click your environment and select Database > Upgrade Database with Fix/Feature Pack.
    Note:  You can also open the task by clicking Database > Upgrade Database with Fix/Feature Pack on the dashboard.
  2. Perform either of these options depending on the status of the environment:

    • If the environment is running, the message "Set M3 BE in maintenance mode" is displayed. Click Next.

    • If the environment is stopped, the environment will be started in maintenance mode.

      Note: The environment is in maintenance mode until the application is started or set online.
  3. Specify the user name and password of the database administrator.
  4. Click Next. The Component window is displayed.
  5. Specify this information:
    Component

    Select the component related to the feature pack

    The component is specified in the Environment Configurator Components pane (MNS104). For standard M3 Business Engine, select the MVX component.

    System configuration

    Select the system configuration where the selected component is connected.

    The system configuration is specified in the Environment Configurator Configurations pane (MNS102). For the component MVX, the system configuration MVX is set by default.

    Number of threads

    Select the number of threads used for a parallel execution. The recommended number of threads is 2-3 threads per CPU.

    Pre-analyze

    To see the changes made on the database before you do the actual upgrade, select Pre-analyze. If you do not want the upgrade tasks to be performed, click Cancel.

  6. Click Next. If Pre-analyze is selected, the Upgrade Tasks window is displayed.
  7. Specify this information:
    Filter

    To help you navigate through all the database changes, there is a dropdown list with different filters that groups tables with common upgrade characteristics together. These options are available:

    • ALL - This is the default value. All tables are selected.

    • INDEX UPGRADE - Tables with indexes (logical files) that have been changed

    • LAYOUT UPGRADE - Tables with new layout (DDL)

    • NEW TABLES - New tables

    • NOT SUPPORTED - Tables that need a layout upgrade that is not supported, those tables are not upgraded.

      These layout changes are supported:

      • New columns with blank default value

      • Extended columns

      • Truncated columns

      • Removed columns.
        Note:  A column cannot be renamed; a renamed column is treated as a new and a removed column.

        The only data type changes that are supported are from numeric to string or from string to a numeric data type with no decimals.

    • TABLES WITH DATA - Tables that contain record

    • TRUNCATED - Tables that have removed or truncated columns

    • VIEW UPGRADE - Tables with changed views (join logical files)

    Tables

    You can view different tables depending on the filter that you select. The upgrade details of a selected table are presented in the table details list.

    No of tables

    The number of tables selected with the filter field.

    No of rows

    Total number of rows for the tables selected with the filter field.

    Table details

    This list contains upgrade details for a selected table. These are the available details:

    • Path - The database definition file has been loaded from this location

    • Schema - Database schema for the table

    • No of rows - Number of rows in the table

    • Layout - The table layout can be changed or unchanged

    • Upgrade method - If the table layout has been changed, the sql statement used to upgrade the table is specified in this field.

    • New Columns - A list of the new columns

    • Extended columns - A list of the extended columns

    • Truncated columns - A list of the truncated columns

    • Removed columns - A list of the removed columns

    • Data type changed columns - A list of the columns with changed data types

    • New indexes - A list of the new indexes

    • Changed indexes - A list of the changed indexes

    • Removed indexes - A list of the removed indexes

    • Recreate indexes - A list of the indexes that have not been changed but need to be recreated of some reason

    • New views - A list of the new views

    • Changed view - A list of the changed views

    • Removed views - A list of the removed views

    • Recreate views - A list of views that have not been changed but need to be recreated of some reason

  8. Click Next. The Summary window is displayed.
  9. Verify the values provided and click Finish.
  10. When the task is finished, a window is displayed. Click OK or click View log. You can also go to the Logs tab to view the log file.