You can verify the CCSID setting for a database by executing the following query:
SELECT * FROM SYSIBM.SYSDATABASE
WHERE NAME = 'database_name'
where database_name is the name of the database for which you are verifying the CCSID setting. You can also verify the CCSID settings for translation tables used by the LTM in character data conversions by executing the following query:
SELECT * FROM SYSIBM.SYSSTRINGS
WHERE INCCSID = inccsid AND OUTCCSID = outccsid
