Configuring a DB2 database for MAP

When installing the Media Access Proxy (MAP) software for use with DB2®, you must configure the DB2 database.

Before you begin

Make sure that you have created the install image as described in the Creating the MAP install image on your application server topic.
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.

Perform this procedure on the database server, which can be a different system than the system used to run MAP.

Important: Do not create any tables manually within the MAP database.

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 mapdb using codeset UTF-8 territory us
```
In this example, the database name is mapdb. If you choose another database name, use the chosen name instead of mapdb in subsequent steps.

Update the new database configuration using the following command.

db2 update db cfg for mapdb using logfilsiz 10000 logprimary 10 logsecond 10

Connect to the database using the following command.

db2 connect to mapdb user db2instance_userID using db2instance_password

If you used the su command when you logged in as the DB2 instance user, issue the exit command.

After the database is configured, you can install the MAP software.