Reviewing database settings and backups

Review database settings

To ensure a successful upgrade, compare the configuration settings of your existing database with the default configuration settings of Maximo® Manage. If your current values do not sufficiently match the default settings in Maximo Manage, it might cause problems during the upgrade process. Set configuration parameters that are equal to or greater than those parameters that required for Maximo Manage. For more information, see Preparing your database for deployment.

Disable custom triggers

Disable all custom triggers that exist for any table in your Maximo Asset Management database, for example, stored procedures, triggers, views, and synonyms. The upgrade process does not re-create or remove these objects. Reapply custom triggers after your database is upgraded as part of activating Maximo Manage.

Commit any database configuration changes

Commit any configuration changes to the Maximo Asset Management database before you upgrade to Maximo Application Suite. Configuration changes were part of the postinstallation tasks that were required when you installed Maximo Asset Management.

To confirm that all changes are committed, run the following SQL query against the Maximo Asset Management database:
SELECT count(*) from maxobjectcfg where changed != ’N’
SELECT count(*) from maxsysindexes where changed != ’N’

'N' indicates that a change is committed. If any positive row count values are returned for the query, you must apply or discard the configuration changes. Alternatively, you can use the configdb.bat command to commit configuration changes. For more information, see Configuring initial data.

Back up the existing database and other files

Back up the existing Maximo Asset Management database, the contents of the Maximo Asset Management installation folder, and the deployment engine. If a failure occurs during upgrade, you might be required to restore the Maximo Asset Management database. Some upgrade tasks cannot be rolled back after they are committed to the database. If you have a backup of the database, you can restore your environment. By default, files are found in the C:\ibm\smp directory. Backing up this directory can be useful if you must rebuild Maximo Asset Management EAR files. Back up the deployment engine registry as described in the Maximo Asset Managementinstallation information.

For more information, see Backup and restoration for WebSphere® Application Server and Backup and restoration for Oracle WebLogic Server.