Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16 » MobiLink upgrades » Consolidated database upgrades

 

Upgrading an IBM DB2 LUW consolidated database

Before you can use the new MobiLink server with an existing IBM DB2 LUW consolidated database, run upgrade scripts to install new system objects.

Prerequisites

You must be the owner of the currently installed MobiLink system tables to run the setup scripts.

For DB2 LUW 10.1, permission to SELECT from SYSIBMADM.MON_LOCKWAITS, SNAPSHOT_APPL_INFO is required by the MobiLink server to invoke the locking/blocking detection logic.

For DB2 LUW 9, permission to SELECT from SYSIBMADM.LOCKWAITS, SNAPSHOT_APPL_INFO is required by the MobiLink server to invoke the locking/blocking detection logic.

Context and remarks

Upgrade your IBM DB2 LUW consolidated database if your previous version of the MobiLink server is earlier than version 16.0.

For information about how to run the IBM DB2 LUW setup script, see IBM DB2 LUW consolidated database.

You can also use the following methods to update the MobiLink system setup:

  • In the MobiLink plug-in for Sybase Central, click MobiLink 16 » Project » Consolidated Databases and right-click the database name and click Check MobiLink System Setup. If your database requires setup or upgrading, you are prompted to continue.

  • When you use the Deploy Synchronization Model Wizard, system setup is checked when you connect to your consolidated database. If your database requires setup or upgrading, you are prompted to continue. See Synchronization models.

 Task
  1. Locate the IBM DB2 LUW upgrade script.

    The upgrade script is called upgrade_db2.sql and is held in the MobiLink/upgrade/version subdirectory of your SQL Anywhere installation. The version directory refers to the version of MobiLink from which you are upgrading.

  2. Copy upgrade_db2.sql and modify the copy. Change the CONNECT statement at the start of the script so it works with the instance you want to connect to. Apply the copied SQL script to the consolidated database.

Results

The consolidated database can now be used with the new MobiLink server.