Technical Blog Post
Abstract
How can we change TERRITORY for Database e.g.TERRITORY TH to TERRITORY US
Body
Once the database has been created, the territory cannot be altered.
CREATE DATABASE
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
"TERRITORY territory
Specifies the territory identifier or locale identifier to be used
for data entered into this database. After you create the database, you
cannot change the specified territory. The combination of the code set
and territory or locale values must be valid."
You would have to create a new database with the needed territory then
use the EXPORT/IMPORT/db2move utilities.
Data movement optionshttps://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.dm.doc/doc/r0024482.html
Refer:
How can I change the DB2 database code page, territory code or collation?
/support/pages/node/547657
UID
ibm13286137