Using the DB2 UDB Option for CICS with utf8

The DB2 UDB Option for CICS can be configured to use utf8 for communication with DB2 and clients. This configuration gives the greatest flexibility for using different character sets when communicating with DB2 because most character sets can be converted to and from utf8. All the accessed DB2 tables should be single-byte EBCDIC tables or should have Unicode encoding schema.

To configure the DB2 UDB Option for CICS to use utf8, set these configuration parameters in the Server Option for CICS SYGWMCST macro of the SYGWXCPH options module:

USEIBMUNICODE=Y
CHARSETSRV=utf8

You must also bind the AMD2DB2 and AMD2DBA DBRM packages with “encoding(unicode)” because all communication between the DB2 UDB Option for CICS and DB2 UDB are now in utf8.

NoteTo retain MDI legacy RSP feature functionality for the Server Option for CICS, do not set the CHARSETSRV parameter to “utf8” if RSPs are run through the DirectConnect for z/OS Option or if they are run as a use procedure command in a gateway-less environment. The CHARSETSRV parameter must be set to iso_1 for RSPs to work.