Database Configuration

Taskana uses a database to persist the managed entities. When creating this database, you should consider the following items:

• We recommend to create the database with a page size of 32 k
• Be aware that the sort order of query results is governed by the collation sequence that is specified at database creation. The default for the most databases is a case sensitive sort order. If you want query results to be sorted case insensitively, you should specify an appropriate collation sequence.

For DB2, a database create command with case insensitive collation would be

CREATE DATABASE <dbname> USING CODESET UTF-8 TERRITORY <territory> COLLATE USING 'CLDR181_LDE_AS_CX_EX_FX_HX_NX_S3' PAGESIZE 32 K <additional parameters>

The database schema can be changed by setting the parameter "taskana.schema" in the "application.properties" file. This applies to Spring environments, only.

Taskana connects to the database via a DataSource. It does not support XADataSources for connections to databases.