Check DB2 UDB DBMS Code Page
The character set for a DB2 UDB database is based on a code page setting when the database is created. A code page is a table with a mapping of alphanumeric code and its binary representation. If no code page is set, the default code page is determined by the operating system's information. To check the code page of the DB2 UDB DBMS, issue the following command:
get db cfg for DBNAME
You can also issue one of the following commands using the db2look utility:
Windows
db2look -d DBNAME -i USERNAME -w PASSWORD | findstr Database
UNIX
db2look -d DBNAME -i USERNAME -w PASSWORD | grep Database
