Setting Up a Custom DB2 Database

If you plan to use DB2, modify some properties files, and run scripts to configure it to work with SAP Mobile Platform.

Note: In the steps below, <installer_root> is the root directory in the installer image.

Verify that SAP Mobile Platform supports the version of DB2 you are planning to use.
1. Go to the SAP Product Availability Matrix (PAM) http://service.sap.com/pam. Click the Mobile link at the top of the page. Scroll to find the appropriate product and version in the product list.
2. Under the Essentials heading in the upper right corner, click the "Open in New Window" link to open the Support Matrices... PowerPoint file.
3. Click through to the SAP Note for persistence databases supported by SAP Mobile Platform 3.0.
Install DB2 anywhere on the same network where you will be installing SAP Mobile Platform. Consult with your company's database administrator, or have the database administrator perform the installation for you.
Record the values for these parameters:
- Host name – the host system on which the database software is installed.
- Login – the admin login for the database software.
- Port number – the port number the database software uses.
If you installed DB2 on a different server from the one where you will install SAP Mobile Platform Server, copy the db_tools directory (and all subdirectories) from the SAP Mobile Platform Server installer image to a temporary location on the database server.
In the steps below, <installer_root> will refer to the directory into which you copied db_tools.
(Optional) Change database name and user name.
1. Use a text editor to open the <installer_root>/db_tools/db/db2/smp3/sql/001_SMP3_drop_and_create_user.DDL file.
2. Change default values for database name and user name.
  This example shows a contiguous block of the noncomment lines in the 001_SMP3_drop_and_create_user.DDL file for ASE is shown below. Replace:
  - smp3 with the new database name.
  - gomobile with the new database user name.
  Be sure to:
  - Refer to your database documentation for limitations on length and allowable characters for these parameters.
  - Replace all instances of each default text string in the 001_SMP3_drop_and_create_user.DDL script with the same value.
  - Make note of the changes you make. You will need to enter the changed values during SAP Mobile Platform Server installation.
  Replace highlighted items below as needed to implement the changes you wish to make.
```
...
CREATE DATABASE smp3 AUTOMATIC STORAGE YES USINGCODESET UTF-8 TERRITORY US 
COLLATE USING SYSTEM PAGESIZE 32 K;
CONNECT TO smp3;
CREATE SCHEMA gomobile AUTHORIZATION gomobile;
CREATE ROLE SY365_OBJOWNER;
GRANT CREATEIN ON SCHEMA smp3 TO SY365_OBJOWNER;
GRANT SY365_OBJOWNER TO USER gomobile;
...
```
  Note: You create the DB2 user name and set the password at the operating system level and, by convention, DB2 uses the same name for the schema. The default 001_SMP3_drop_and_create_user.DDL file assumes that "gomobile" is the user name created for DB2.
3. Save and close the file.
Run the 001_SMP3_drop_and_create_user.DDL script.
1. Open a terminal window.
2. In the SAP Mobile Platform installer image, navigate to:
```
<installer_root>/db_tools/db/db2/smp3/sql
```
3. Enter:
```
db2 -tvsf 001_SMP3_drop_and_create_user.DDL
```
Make a minimum of 25 database connections available for SAP Mobile Platform Server.
(Optional) Configure your DB2 database to support Mobiliser.
See Configuring DB2 to Support Mobiliser.

Next

Running the Installer