/
Databases

Databases

Owned by Mustapha Zorgati
Last updated: Apr 15, 2021
1 min read

As mentioned in Supported Environments we support different databases.
In order to create the default TASKANA sort order (german, case insensitive) we recommend to configure the databases as followed. If the recommended settings are applied the sort order is equal across different database types.

option

reason

option

reason

PAGESIZE 32 K

needed for TASKANA (otherwise TASKANA will fail to create the database schema)

collate using 'CLDR181_LDE_AS_CX_EX_FX_HX_NX_S3'

required to get the default TASKANA sort order (german, case insensitive). If required other sort orders can be configured

Note: The provided options can only be set during database creation. Once a database exists, these options cannot be modified. Therefore, if you have an existing database without the recommended options, you should delete and recreate it.

We recommend creating the database with the following command

db2 create database TSKDB using codeset utf-8 territory en-us collate using 'CLDR181_LDE_AS_CX_EX_FX_HX_NX_S3' PAGESIZE 32 K

Set the LANG environment variable to de_DE.utf8

 

Related content