Update your IBM® Connections
4.0 or 4.5 databases by using the database wizard. Versions 4.0 GA,
4.0 with CRs, 4.5 GA, and 4.5 with CRs can be migrated using the database
wizard.
Before you begin
Before applying updates, back up your databases. For more
information, refer to Backing up IBM Connections.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.
You
should 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 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 4.0 and
4.5 databases manually topic. If you do not follow this recommendation
and you are migrating from Connections 4.0, you must run a Java migration
from 4.0 to 4.5 after using the wizard.
(SQL Server only)
Ensure that the name of the Home page database instance is not null.
If it is null, rename it to HOMEPAGE.
(DB2® 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 information center.
(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.
Note: Attempting to
delete existing 4.5 databases on a Microsoft SQL 2012 EE deployment
will fail because the Database wizard does not recognize the install
path. IBM Connections 4.5 did not support Microsoft SQL Server 2012
but Connections 5.0 does. The Database wizard does not support upgrading
4.5 databases to 5.0 automatically for Microsoft SQL 2012 EE. Instead,
you need to perform a manual upgrade as described in
Updating
4.0 and 4.5 SQL Server databases manually
.
Before
you can use the wizard to create databases for your IBM Connections
deployment, prepare the database server as described in the Installing
section in Preparing the database wizard.
About this task
Follow these steps to update your IBM Connections 4.0 or 4.5 databases to IBM Connections 5.0 databases.Note: As
an alternative to using the wizard, you can update the databases manually.
For more information, see the Updating 4.0 and 4.5 databases
manually topic.
To update your databases with the
database wizard, complete the following steps:
Procedure
- Stop the IBM WebSphere Application Server
instances that are hosting IBM Connections
version 4.0 or 4.5.
- Optional: If the database servers and IBM Connections are on different
systems, copy the 5.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:
- AIX or Linux: ./dbWizard.sh
- Windows: dbWizard.bat
- Select the Update 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.
Note: For SQL Server:
- If the default instance is used, then enter "\" into
the Database Instance field.
- If a nondefault instance is used, then enter the instance name
in the format "<instance name>" into the Database
Instance field; "\<instance name>" and ".\<instance
name>" are in the wrong format.
- Select the databases that you want to update and click Next:
- Activities: OPNACT
- Blogs: BLOGS
- Bookmarks: DOGEAR
- Communities: SNCOMM
- Files: FILES
- Forum: FORUM
- Home page: HOMEPAGE
- Metrics: METRICS
- Mobile: MOBILE
- Profiles: PEOPLEDB
- Wikis: WIKIS
Note: The database wizard disables the selection
of any applications that were not released in IBM Connections 4.0 or 4.5. If any application
databases were created in an earlier release of IBM Connections than 4.0 or 4.5, update that
database by using the IBM Connections
5.0 database wizard.
- (SQL Server only) Enter the password for the Home Page
database user.
- If you are updating the Home Page database, provide the
port, administrator ID, and administrator password for the database.
- 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.
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.
Note: If the database wizard encounters any
unexpected SQL error, it will stop execution and display the Post
Configuration Task Summary with details of the error. It also shows
which database upgrades were aborted so that you can correct the error
immediately, and then rerun the wizard to resume processing database
upgrades.
- 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 Connections
Content Manager. For more information, see the Creating database topic
- If you did not follow the recommendation to update the
Home Page database manually before using the wizard and you are migrating
from Connections 4.0, you must run a Java migration
from 4.0 to 4.5.
What to do next
(DB2 for Linux 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 topic.
Note: If
you have error when upgrading the database, you can check the log
in the <db_user_home>/lcWizard/log/dbWizard folder
to know what the error is.