Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »


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 'UCA500R1_CX' 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.

  • No labels