I think there is no way implemented by the docker people for
custom territory/codeset.
Maybe the sample Database - provided by IBM -- is better for your needs??
https://www.ibm.com/docs/en/db2/11.5?topic=commands-db2sampl-create-sample-database
on my docker / macOS the sample DB has the following:
db2 get db cfg for sample | grep -i terr
Database territory = US
db2 get db cfg for sample | grep -i code
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1
Best regards
------------------------------
Jürgen Jost
DB2 DBA (LUW / zOS)
------------------------------
Original Message:
Sent: Tue November 08, 2022 03:16 AM
From: Tvrtko Mrkonjić
Subject: Set territory and collation on docker db2
thanks,
so there is no way that initial database created by docker run... -e DBNAME=testdb ...
can get custom territory/codeset?
------------------------------
Tvrtko Mrkonjić
Original Message:
Sent: Mon November 07, 2022 03:31 AM
From: Jürgen Jost
Subject: Set territory and collation on docker db2
Hi,
if you login to your docker container with the instance owner
docker exec -ti mydb2 bash -c "su - db2inst1"
you can create any database with the parameters you prefer
--CREATE DATABASE MYDB ... USING CODESET 1252 TERRITORY XX
------------------------------
Jürgen Jost
DB2 DBA (LUW / zOS)
Original Message:
Sent: Thu November 03, 2022 03:11 AM
From: Tvrtko Mrkonjić
Subject: Set territory and collation on docker db2
I am running ibmcom/db2 image from dockerhub and am unable to determine how to set territory and collation for newly created database in container.
any advice?
------------------------------
Tvrtko Mrkonjić
------------------------------
#Db2