Setting Up a Custom ASE Database

To use Adaptive Server^® Enterprise (ASE), 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 ASE 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 ASE 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.
If you are not sure what values to specify when you install or configure your database, use the settings below to get started.
Setting Value

Page size 16 KB
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 ASE 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.
Edit the 001_SMP3_drop_and_create_user.DDL script:
1. Use a text editor to open the <installer_root>/db_tools/db/ase/smp3/sql/001_SMP3_drop_and_create_user.DDL file.
2. Locate the following two lines and replace c:\Sybase\data\ with the path to where you want your SAP Mobile Platform database to be created.
```
physname = "c:\Sybase\data\smp3.dat",
...
physname = "c:\Sybase\data\smp3.log",
```
  Note: The path for your SAP Mobile Platform data is independent of the path that you set for your SAP Mobile Platform installation directory. If you place your database files within the SAP Mobile Platform installation directory tree, the SAP Mobile Platform uninstaller will not remove them.
3. (Optional) Change database name, user name, and password.
  This example shows a contiguous block of the noncomment lines in the 001_SMP3_drop_and_create_user.DDL file for ASE:
  Replace:
  - smp3 with the new database name.
  - gomobile with the new database user name.
  - secret with the new database user password.
  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.
```
...
disk init
name = "smp3data",
physname = "c:\Sybase\data\smp3.dat"
size = "256M",
directio = true
go
disk init
name = "smp3log",
physname = "c:\Sybase\data\smp3.log",
size = "256M",
directio = true
go
sp_addlogin "gomobile","secret"
go
sp_configure "lock scheme", 0, datarows
go
drop database smp3
go
create database smp3
    on smp3data="256M"
    log on smp3log="256M"
go
exec sp_dboption 'smp3', 'select into/bulkcopy/pllsort', true
go
sp_configure 'enable functionality group', 1
go
use smp3
go
checkpoint
go
sp_adduser gomobile
go
grant all to gomobile
go
...
```
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/ase/smp3/sql
```
3. Enter:
```
isql -S<servername> -U<username> -P<password> -i001_SMP3_drop_and_create_user.DDL
```
  where:
  - <servername> is the server where ASE is installed.
  - <username> is an admin user, such as sa.
  - <password> is the password for <username>.
Make a minimum of 25 database connections available for SAP Mobile Platform Server.
(Optional) Configure your ASE database to support Mobiliser.
See Configuring ASE to Support Mobiliser.

Setting	Value
Page size	16 KB

Next

Running the Installer