This is Takunobu Atsukawa.
We are requested from our Customers to use DB2 as the performancewarehouse of dynatrace v6.5.
What is the DB collation query generally set?
The locale will be in Japan.
The document has the following description.
"Create the database with insensitive collation"
In this case,Should We Choose "SYSTEM"?
Please give me some advice.
please refer to this IBM doc for collations:
Note that you have to choose the correct db2 version at the top to get the correct identifiers.
If I understand it correctly, to get a Japanese collation that's case insensitive, you could use this identifier:
Please note that I'm not a professional DB2 admin, treat my answer as "recommendation". Best regards,