LSPS requires an lsps database with a dedicated user to store its system data. To set up such a database, do the following:

Make sure the database is supported by your application server.

Create a database with the character encoding to UTF-8.

Example MySQL database setup with UTF-8

CREATE USER 'lsps' IDENTIFIED BY 'lsps';
CREATE DATABASE lsps DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON lsps.* TO lsps@'';
GRANT XA_RECOVER_ADMIN ON *.* TO 'lsps'@''; -- not on MySQL 5
SET GLOBAL log_bin_trust_function_creators = 1; -- not on MySQL 5
FLUSH PRIVILEGES;

Initialize the database with the db-migration tool from the runtime suite:

cli-tools$ java -jar lsps-db-migration-lsps-<VERSION>-full.jar --databaseUrl <DATABASE_URL> --user <DB_USER> --password <ESCAPED_DB_PASSWD>

(refer to documentation of the lsps-database migration script).

Initialize the database for the LSPS or other libraries you are going to use. For example, if you are planning to use the BAM Library, initialize the tables with bam-migration:
```
cli-tools$ java -jar lsps-bam-migration-lsps-<VERSION>-full.jar --databaseUrl <DATABASE_URL> --user <DB_USER> --password <ESCAPED_DB_PASSWD>
```
Configure your database:
- Microsoft SQL server:
  - Enable the XA transaction support. Refer to the relevant Microsoft documentation for information on your version of Microsoft SQL server and JDBC driver; for example, for Windows Server 2003 and sqljdbc4.jar, refer to http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 and http://msdn.microsoft.com/en-US/library/aa342335(v=sql.90).
  - It might be necessary to install MSDTC in Windows (Add/remove Windows components -> Application Server -> Details -> Enable network DTC access).
- On MySQL, set the allowed packet size to 512 MBs and the default time zone in the configuration file of your mysql server, typically, the my.cnf or mysqld.conf files:
```
[mysqld] 
  max_allowed_packet=512M
  default_time_zone="+0:00"
```