The first stage in the process of installing the Multi-Channel Server (MCS)
software on WebSphere® Portal for
use with DB2® is to configure the DB2 database.
Before you begin
- A supported version of WebSphere Portal for
use with IBM® Mobile Portal Accelerator version 8.0 must
be installed on the system where you install MCS.
(For supported versions of WebSphere Portal,
see the topic Software requirements.)
Note: For instructions
about installing WebSphere Portal and
required fixes, see the topic Performing required steps before Mobile Portal Accelerator.
Also, see the WebSphere Portal product documentation for
detailed planning and installation information.
- Make sure that you have unpacked wp.mobile.zip and
created the install images as described in the Performing required
steps before Mobile Portal Accelerator topic.
- You must use one of the supported versions of
DB2 as your database server. Refer to the list of supported databases
in the WebSphere Portal detailed
system requirements.
You
can install the database server on the system where you install
MCS,
or on another system.
Note: See the DB2 documentation
for detailed planning and installation information.
About this task
Perform this procedure on the database server, which can
be a different system than the system used to run
MCS.
Procedure
- Log in.
Log in
as the DB2 instance user. If you are logged in as root,
run the following command to change to the DB2 instance
user: su - db2instance_userID
Log in as a user with administrative
privileges.
- Run the db2start command
to ensure that the DB2 server is started.
- Create a new database using the following command.
db2 create db mcs using codeset UTF-8 territory us
In
this example, the database name is mcs. If you choose another
database name, use the chosen name instead of mcs in subsequent
steps.
- Update the new database configuration using
the following command.
db2 update db cfg for mcs using logfilsiz 10000 logprimary 10 logsecond 10
- Connect to the database using the following
command.
db2 connect to mcs user db2instance_userID using db2instance_password
- If your database server is on the same server as WebSphere Portal,
change the working directory to:
wp_root/wp.mobile/wp.mobile.mcs/repository/db2
Otherwise,
copy the file wp_root/wp.mobile/wp.mobile.mcs/repository/db2/create_vm_tables.sql and create_mdpr_tables.sql from
your WebSphere Portal server
to a directory on your database server. Then, make that directory
your working directory.
- Create the WebSphere Portal tables
using the following commands. Change to the user with which you created
the MCS database, for example db2admin or db2inst1. Change to the
DB2 command prompt then change the directory to the location where
you copied the sql files.
- Run create_mdpr_tables.sql. At
the DB2 prompt enter: db2> -tf create_mdpr_tables.sql
- Run create_vm_tables.sql. At the
DB2 prompt enter: db2> -tf create_vm_tables.sql
- If you used the su command
when you logged in as the DB2 instance user, issue the exit command.
What to do next
After the database is configured, you can install the
MCS software.
