Updating the Sametime 8.5 database for the Sametime System Console on AIX, Linux, Solaris,
and WindowsAdded by IBM on November 23, 2011 | Version 1 (Original)
|If you are upgrading a Sametime System Console running on AIX®, Linux®, Solaris, and Windows® from Release 8.5 to 8.5.2, update the database that stores its data. This step does not apply if you are upgrading from 8.5.1 to 8.5.2.
If you are upgrading a Sametime System Console running on AIX
®, Solaris, and Windows
® from Release 8.5 to 8.5.2, update the database that stores its data. This step does not apply if you are upgrading from 8.5.1 to 8.5.2.
Before you begin
The DB2 administrator must have administrator rights to be able to create and update tables in the database. Make sure the DB2 server is running.
About this task
Run the scripts that come with Sametime in the DB2
® installation package to update the database before upgrading the Sametime System Console.
Parent topic: Upgrading the Sametime 8.5 or 8.5.1 System Console on AIX, Linux, Solaris, or Windows
Next topic: Upgrading a Sametime 8.5 or 8.5.1 System Console on AIX, Linux, Solaris, and Windows
- Back up the data stored in the Sametime System Console database.
- On the DB2 server, log in to the system as the DB2 administrator created during DB2 installation if you are not already logged in.
Linux and Windows: Now proceed to Step 4.
AIX and Solaris: Now proceed to Step 3.
- Download the DB2 installation package if you have not already done so.
- To download installation packages:
- To download installation packages, you must have an IBM Passport Advantage® account. For information on using Passport Advantage, see the topic Using Passport Advantage to download IBM products.
- Open the Download document for the release you want to install:
Sametime 8.5.2 Interim Feature Release 1 (Sametime 8.5.2 must be installed first)
Locate the components that you need in the document's listing, then download the packages labelled with the corresponding part numbers to the system on which you are installing.
When extracting downloads on Windows
operating systems, use a short path location such as C:\ and not a long path location such as the user's desktop
directories. When extracting to long path locations or deeply nested directories and using the built-in Windows
extract utility, corruption is sometimes seen without any warning. This corruption occurs when maximum path lengths on some Windows
versions are exceeded.
- If you are installing from physical media and your operating system mounts CDs or DVDs automatically with execution privileges turned off, mount the CD or DVD manually instead.
Mount the CD or DVD using the SMIT utility or the appropriate version of the following command:
mount -v cdrfs -o ro /dev/cd0 /cdrom
Mount the CD or DVD using a command similar to the following command:
mount /dev/cdrom /cdrom
Mount the CD or DVD.
- Open a command prompt and navigate to the folder where you extracted the DB2 installation package.
- Update the database by running one of the following commands from the SametimeDB2 folder:
AIX, Linux, and Solaris
./update_85_SCDb.sh STSC dbadmin
update_85_SCDb.bat STSC dbadmin
Replace "STSC" in the command if you used a different name when you created the database.
Replace "dbadmin" with the DB2 Application User ID you created when you installed DB2. This user has database administration authority.
- Close the command window.
- Open the DB2 Control Center.
AIX, Linux, and Solaris
Open the IBM DB2 folder on the desktop and click Control Center.
Click Start -> Programs -> IBM DB2 -> installed_DB2_instance -> General Administration Tools -> Control Center.
- Verify that the database was updated.
The update script adds the following to the database:
- A table called VERSIONINFO
- A field called DISPLAYVERSION in the DEPLOYMENT table
- A field called CLUSTERVERSION in the CLUSTERDEPLOYMENT table
By looking at these elements in the DB2 control center, you can confirm that the database was updated.