Database Requirements

There are some limitations observed while working with DB2 and MS SQL Server.

DB2 Requirements

If you are using DB2 for data persistence, use the following configuration:

Set the table space size to 32k. For example,

CREATE DATABASE <spm db> AUTOMATIC STORAGE YES  ON 'C:/' USING CODESET IBM-1252 TERRITORY US COLLATE USING SYSTEM PAGESIZE 32768;

Enable SNAPSHOT transaction isolation for MS SQL Server database.
To enable READ_COMMITTED_SNAPSHOT for the Service Performance Manager database, run the following commands as Database System Administrator (sa):
```
ALTER DATABASE <spmDB name> SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE <spmDB name> SET ALLOW_SNAPSHOT_ISOLATION ON;
```
When using SQL Server, ensure that you use case sensitive collation. You may enable case sensitive collation using a command similar to the following:
CREATE DATABASE spm COLLATE SQL_Latin1_General_CP1_CS_AS;

Refer to the SQL Server documentation for more information regarding collation.