Upgrading IBM Spectrum LSF Application Center from previous versions to 10.2

Upgrading from older versions of Platform Application Center or IBM Spectrum LSF Application Center to version 10.2 is a manual process.

1. Perform a fresh installation of IBM Spectrum LSF Application Center 10.2 using one of the following options:
   • Option 1: If you are installing 10.2 on the same host, and sharing the same database, set the parameter USE_REMOTE_DB=Y
     Note: You must use this option if you are using LSF Process Manager.
   • Option 2: If you are installing 10.2 on a different host, and are not sharing the previous database, set USE_REMOTE_DB=N, and jump to Step 4. With this option, some historical data such as permission settings will be lost. Administrators may recover them on the portal manually.
2. Copy the database connection file from the old version:

   #cp /opt/pac/perf/conf/datasource.xml    /opt/ibm/lsfsuite/ext/perf/conf/

3. Upgrade the database schema to the version you are upgrading to.
   1. Navigate to the patch directory:

      #cd /opt/ibm/lsfsuite/ext/gui/DBschema/MySQL/Patch

   2. Run the schema diff file to upgrade the schema version by version, starting from the version you are upgrading from:

      If you are upgrading from version 10.1 to version 10.2.0.7, run the following:

      # mysql -u root -p $rootpassword
      mysql>use pac;
      mysql>source pac101_to_10101.sql;
      mysql>source pac10101_to_10102.sql;
      mysql>source pac10103_to_102.sql;
      mysql>source pac102_to_10206.sql
      mysql>source pac10206_to_10207.sql
      

      If you are upgrading from version 9.1.5 to version 10.2.0.7, run the following:

      # mysql -u root -p $rootpassword
      mysql>use pac;
      mysql>source pac915_to_101.sql
      mysql>source pac101_to_10101.sql;
      mysql>source pac10101_to_10102.sql;
      mysql>source pac10103_to_102.sql;
      mysql>source pac102_to_10206.sql
      mysql>source pac10206_to_10207.sql
      

      If you are upgrading from version 9.1.4 to version 10.2.0.7, run the following:

      # mysql -u root -p $rootpassword
      mysql>source mysql>use pac;
      mysql>source pac914_to_9141.sql
      mysql>source pac9141_to_9142.sql
      mysql>source pac9142_to_915.sql
      mysql>source pac915_to_101.sql
      mysql>source pac101_to_10101.sql;
      mysql>source pac10101_to_10102.sql;
      mysql>source pac10103_to_102.sql;
      mysql>source pac102_to_10206.sql
      mysql>source pac10206_to_10207.sql
      

      If you are upgrading from version 9.1.3 to version 10.2.0.7, run the following:

      # mysql -u root -p $rootpassword
      mysql>source mysql>use pac;
      mysql>source pac913_to_914.sql
      mysql>source pac914_to_9141.sql
      mysql>source pac9141_to_9142.sql
      mysql>source pac9142_to_915.sql
      mysql>source pac915_to_101.sql
      mysql>source pac101_to_10101.sql;
      mysql>source pac10101_to_10102.sql;
      mysql>source pac10103_to_102.sql;
      mysql>source pac102_to_10206.sql
      mysql>source pac10206_to_10207.sql
      

4. Back up the new templates and copy over the previous version's Application templates one by one:

   #cp -R /opt/ibm/lsfsuite/ext/gui/conf/application/draft     /backup_directory/

   Repeat the following for each template:

   #cp -R /opt/pac/gui/conf/application/published/<TEMPLATE_NAME>  /opt/ibm/lsfsuite/ext/gui/conf/application/published/

   Check whether there is a duplicate template under /opt/ibm/lsfsuite/ext/gui/conf/application/draft/ and if yes, delete it.

5. Copy the LSF Process Manager flow definition drafts from the previous version of LSF Application Center.

   #cp -R /opt/pac/gui/pm_data  /opt/ibm/lsfsuite/ext/

6. Tune other system parameters in 10.2 if required, for example:
   • Parameters in pmc.conf
   • Global system parameters, such as ENABLE_USERGROUP=Y if HA is enabled
   • Configure the new HTTP Server as the previous one was configured
7. If the previous version of Platform Application Center or IBM Spectrum LSF Application Center has customized links in the navigation tree, customize the 10.2 navigation tree using the new way provided in the 10.2 interface.
8. To avoid port conflicts on the host, ensure that the previous version of Platform Application Center has been stopped. Only one instance of Platform Application Center may run on a host at a time.