UDCC r11.2 Upgrade Considerations

Document ID : KB000055390
Last Modified Date : 14/02/2018
Show Technical Document Details

UDCC r11.2 Upgrade Considerations

  • Migration is only possible if you are upgrading from r11.1 English release to r11.2 English release and chose to maintain the existing Ingres MDB from your UDCC r11.1 environment.
  • If you have r11.1 Localized release and to upgrade to r11.2, note that upgrade from r11.1 localized release to r11.2 English only release is not supported. You will either have to uninstall r11.1 localized copy to install r11.2 English release or wait until r11.2 localized release becomes available.
  • If you want to use Oracle or Microsoft SQL Server for MDB, MDB migration from one RDBMS to another RDBMS is not supported in release. You must uninstall r11.1 first and install r11.2. Refer to "Steps to Uninstall UDCC r11.1 for fresh installation of DCC r11.2".
  • If you want to move Ingres MDB to different system, MDB migration from an IngresEI to another IngresEI is not supported. You must uninstall r11.1 first and install r11.2. Refer to "Steps to Uninstall UDCC r11.1 for fresh installation of DCC r11.2".
  • Due to architectural difference in r11.2, migration from Unicenter Database Management r11.0 or lower releases to r11.2 is not supported. You must first uninstall older releases and to install r11.2. Refer to "Steps to Uninstall UDM r11.0 (or older releases) for fresh installation of DCC r11.2".
  • When upgrading from Unicenter Fast Unload r11.0 or v4.2.x to Unicenter Fast Unload r11.2, you must first uninstall Unicenter Fast Unload r11.0 and v4.2.x.
  • When upgrading from Unicenter TSreorg r11.0 or v3.2.x to Unicenter TSreorg r11.2 for Oracle, you must first uninstall Unicenter TSreorg for r11.0 and v3.2.x.
Migrating UDCC r11.1 to r11.2
  • Remove dbm folder from %HOMEPATH%\Local Settings\TEMP. (Refer to Pre-Upgrade Notes section)
  • Apply Ingres RDBMS Patch. (Refer to Apply Ingres RDBMS Patch section)
  • Apply Ingres MDB Patch. (Refer to Apply Ingres MDB Patch section)
  • Install r11.2 to upgrade UDCC from r11.1 to r11.2. (Refer to Unicenter DCC r11.2 Upgrade Installation Notes)
  • Modify UDCC Portal's default workplace as needed. (Refer to Post-Upgrade Notes)

Steps to Uninstall UDM r11.0 (or older releases) for fresh installation of UDCC r11.2

  • Uninstall Unicenter Database Management products such as TSreorg, Fast unload, etc. from Windows "Add or Remove Programs"
  • Uninstall CA Unicenter Database Management Console using Windows "Add or Remove Programs"
  • Uninstall CA Unicenter Database Management Common Services using Windows "Add or Remove Programs"
  • Uninstall CA CleverPath Portal using Windows "Add or Remove Programs". Before uninstalling CleverPath Portal, you should ensure that it is not being used by CA Products or teams in your organization.

    NOTE: This applies to UDM r11.0 only and it was an optional UI in r11.0 release.

  • Uninstall CA Advanced Ingres [CP] Enterprise Edition using Windows "Add or Remove Programs". Before uninstalling Ingres [CP], you should ensure that it is not being used by CA Products.

    NOTE: This applies to UDM r11.0 only and it was an optional UI in r11.0 release.
  • You are now ready to install r11.2

Steps to Uninstall UDCC r11.1 for fresh installation of UDCC r11.2

  • Uninstall CA Unicenter Database Command Center from Windows "Add or Remove Programs".
  • Uninstall CA CleverPath Portal from Windows "Add or Remove Programs". Before uninstalling CleverPath Portal, you should ensure that it is not being used by CA Products or teams in your organization.
  • Uninstall Ingres [EI] using Windows "Add or Remove Programs". Before uninstalling Ingres [EI], you should ensure that it is not being used by CA Products.
  • Remove udcc folder from %CommonProgramFiles%\InstallShield\Universal if present.
  • You are now ready to install r11.2

Pre-Upgrade Notes

  • Before running the Unicenter DCC r11.2 installation, remove dbm folder from %HOMEPATH%\Local Settings\TEMP if present. Presence of this folder may hinder the upgrade.
  • When upgrading to Unicenter DCC r11.2 (Ingres MDB), you must first patch the MDB and the Ingres RDBMS itself before running the Unicenter DCC r11.2 installation. See below.

Apply Ingres RDBMS Patch

To apply the Ingres RDBMS patch, do the following:

  1. Stop the following services in the Windows Services applet:
    CA CleverPath Portal
    Ingres Intelligent Database [EI] service (You will also need to stop the CA Unicenter DCC Job Administration service when you stop Ingres.)
  2. From the command prompt window, run the following commands in respective order to launch the Ingres [ei] InstallShield Wizard.

    SET II_SYSTEM=EI
    cd <media_root>\INGRES\WIN32\mdb\IngresPatch
    PatchUpdate /id %II_SYSTEM%

  3. Follow the wizard steps until the patch installation is complete.

  4. Restart your computer.

Apply Ingres MDB Patch

  1. Launch Ingres Visual SQL and verify if the patch exists, as follows:
    Change <Please Select A Database> to MDB.
    Change <Default User> to mdbadmin.
    Execute the query: Select * from MDB_PATCH
    If no rows are returned, continue with the remaining steps.
    If any rows are returned and patch #15259492 is found, exit.
  2. From the command prompt window, run the following commands to apply the patch.
    cd <media_root>\INGRES\WIN32\mdb\CumulativePatch
    patchmdb -II_MDB_NAME=mdb -II_MDB_PATCH=15259492 -II_MDB_PATCH_MODE=online -II_MDB_CHECKPOINT=none
    ckpdb mdb

    Note: Execution of patchmdb and ckpdb commands may take a while to complete.

Unicenter DCC r11.2 Upgrade Installation Notes

When you run the Unicenter DCC r11.2 installation, consider the following items.

  1. When upgrading Unicenter DCC, do not select the MDB checkbox - you need not re-install MDB.
  2. The CA ODBC component is not automatically upgraded. After upgrading Unicenter DCC, you must upgrade CA ODBC manually as follows:
    Stop the CA Unicenter DCC Job Administration service in the Windows Services applet.
    Run the following installation wizard: <media_root>\ODBC\WIN32\setup.exe and follow the wizard steps as prompted.
    The ODBC version should be updated from r3.11 2005\02\04 22:09 to r3.11 2006\12\13 20:19. You can view the ODBC version information under About on the Unicenter DCC workplace.

Post-Upgrade Notes

  • By default, UDCC r11.2 migration keeps user's previous default Workplace settings.
  • You can still access the new r11.2 workplaces that get installed when you upgrade on the workplace bar drop-down menu without making this change. However, you can change the order of the workplaces so the r11.2 workplace links appear ahead of others on the workplace bar in the portal by following steps.
    Clicking Edit Workplaces.
    Move up the following r11.2 objects in respective order.

    DCC Databases
    DCC Servers
    Insight
    DCC Configuration
    DC Job Administration
    DCC About

  • Click OK to save the change.

  • If you have upgraded to r11.2 English release from r11.1 English release, UDCC Portal r11.2's default template is available. Do the following for the portal template to display the latest r11.2 template instead of the r11.1 template that will appear by default after upgrade:

  1. Click My Profile in Unicenter DCC.
  2. Click on Portal Administration.
  3. Click on Manage Users.
  4. Select the user you want to change in the list of users on the left and click Edit.
  5. In the User/Personal Profile, Template, Menu, select Unicenter DCC(10).
  6. Click Save. The new template will appear the next time you log in as that user.
    Note: This is only a cosmetic change.