Database Requirements for SPM

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;
  • Set the Bufferpool to 32k.

MS SQL Server Requirements

  • 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.