cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

About DB Collation query for PWH on DB2

dt_its3-1
Inactive

Hi all,
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.

Best Regards,
Takunobu Atsukawa

3 REPLIES 3

peter_karlhuber
Dynatrace Pro
Dynatrace Pro

Hi,

please refer to this IBM doc for collations:

https://www.ibm.com/support/knowledgecenter/SSEPGG...

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:

CLDR181_LJA_S2

Please note that I'm not a professional DB2 admin, treat my answer as "recommendation". Best regards,

Peter

PS: SYSTEM should also work, but I don't know if it supports Japanese.

dt_its3-1
Inactive

Hi, Peter

This is Ryotaro. I'm emailing you on behalf of Mr. Atsukawa

Thank you for your answer!

We'll check the URL, then we'll use CLDR181_LJA_S2.

Best Regards,
Ryotaro Natsume