Before you begin
Before applying updates, back up your databases. For more information, see the Backing up IBM Connections
Do not use the database wizard on a system that does not have UTF-8 encoding. Running the database wizard on a system where the default encoding is not UTF-8 corrupts non-ASCII characters. To discover the default encoding on the system where you intend to run the wizard, complete the following steps:
- Download the EncodingCheck.class file from the Non-ASCII characters might not be displayed correctly technote.
- Open a command prompt and change to the directory where the EncodingCheck.class file is located.
- Type java -cp . EncodingCheck and press Enter.
The output of the command indicates the default encoding on the system:
charset: charset encoding: encoding lang: lang region: region
If the charset
value is not UTF-8, update your databases manually instead of using the wizard. For more information, see the Updating 3.0.1 databases manually
If you use different database instances for the Home page and Profiles database, run the wizard first on the instance that hosts the Home page database.
Find out the value of the storyLifetimeInDays parameter in the news-config.xml
file. You must enter this value when you migrate the Home page database. The default value is 30. News stories and notifications that are older than this value are purged from the Home page database during migration. For more information, see the Accessing the News configuration file
recommends that you update the Home page database manually. By using the manual method, you can back up the Home page database after each step. This precaution is useful because updating the Home page database, if it is very large, can take considerably more time than the other databases. If you choose this option, update the Home page database before updating any other database. After updating the Home page database, you can use the wizard to update the remaining databases. For more information about manually updating databases, see the Updating 3.0.1 databases manually
(SQL Server only) Ensure that the name of the Home page database instance is not null. If it is null, rename it to HOMEPAGE.
® only) If you use only one database instance and if that instance includes other databases besides IBM
Connections, configure the numdb parameter to match the total number of databases on the instance. For more information, go to the numdb
webpage in the DB2
(Oracle only) Ensure that the Statement cache size for the data sources on WebSphere Application Server is no larger than 50. A higher value could lead to Out Of Memory errors on the application server instance.
(SQL Server only) Ensure that Named Pipes is enabled in the SQL Server Network Configuration for all instances. For more information, refer to your SQL Server documentation.
About this task
Follow these steps to update your IBM
Connections 3.0.1 databases to IBM
Connections 4.0 databases.
As an alternative to using the wizard, you can update the databases manually. For more information, see the Updating 3.0.1 databases manually
To update your databases with the database wizard, complete the following steps:
- Stop the IBM WebSphere® Application Server instances that are hosting IBM Connections 3.0.1.
- Optional: If the database servers and IBM Connections are on different systems, copy the 4.0 database wizard to the system that hosts your IBM Connections databases.
- Log in as the database administrator.
- (DB2 on Windows™ 2008 64-bit.) On Windows 2008, you must perform DB2 administration tasks with full administrator privileges.
- Logged in as the instance owner, open a command prompt and change to the DB2 bin directory. For example: C:\Program Files\IBM\SQLLIB\BIN.
- Enter the following command: db2cwadmin.bat. This command opens the DB2 command line processor while also setting your DB2 privileges.
- Change to the directory where the database wizard is stored. The default location is the Wizards directory on the installation media.
Note: (AIX® and Linux™ only) Ensure that the database administrator has all permissions for the IBM Connections Wizards directory.
- Enter the following command and then click Next:
Select the Upgrade task and click Next.
Specify the database type, database instance, and the installation location, and then click Next. The wizard detects the current database version.
Select the databases that you want to update and click Next:
- AIX or Linux: ./dbWizard.sh
- Windows: dbWizard.bat
Note: The database wizard disables the selection of any applications that were not released in IBM Connections 3.0.1. If any application databases were created in an earlier release of IBM Connections than 3.0.1, update that database by using the IBM Connections 3.0.1 database wizard.
(SQL Server only) Enter the location of the data files for the Home page application.
(SQL Server only) Enter the password for the Home page database user.
(Oracle only) Enter the password for the Communities database user.
If you are updating the Activities, Blogs, Bookmarks, or Home page database, provide the port, administrator ID, and administrator password for the database.
Enter the connection information for the Profiles database user.
- (Oracle only) The database wizard presents two options for password selection. If your Oracle environment does not use the same password for all schema user IDs, choosing either of these options leads to an error. To avoid this error, modify your schema user IDs to use the same password. When the migration process is complete, restore the original passwords.
Review the Pre Configuration Task Summary to ensure that the values you entered are correct. If you want to change any values, click Back to edit the value. To continue, click Update.
- Enter the Oracle SID in the Database name field.
- This information is used during the migration of the Home page database to copy data from the Profile database.
- If you use different instances to host the Home page and Profiles databases, this step is displayed only when you run the wizard on the instance that hosts the Home page database.
Note: Click Show detailed database commands to display the commands. To save the commands, ensure that the user who is running the database wizard has write access to the destination folder. Click Execute to run the commands.
After the update task finishes, review the Post Configuration Task Summary. Click Finish to exit the wizard.
Run the database wizard again to create databases for Metrics, Cognos®, and Mobile. For more information, see the Creating database topic
What to do next
on System z
® only.) To improve database performance, enable the NO FILE SYSTEM CACHING option. For more information, see the Enabling NO FILE SYSTEM CACHING for DB2 on System z
Parent topic: Updating 3.0.1 databases
Updating IBM Connections 4.0
Updating 3.0.1 databases manually
Backing up IBM Connections
Accessing the News configuration file
Updating 3.0.1 databases manually
Enabling NO FILE SYSTEM CACHING for DB2 on System z