Specifying subsystem CCSIDs

You specify the default subsystem CCSIDs when you install DB2®. DB2 uses these values for objects and applications if no other CCSID values are specified.

Before you begin

Before you specify subsystem CCSIDs, determine the CCSID of your data sources. Knowing the CCSID of your data sources helps you determine what the subsystem CCSIDs should be. Ideally, your subsystem CCSIDs should match the CCSIDs in the majority of your data sources. If you need help determining the correct values, contact IBM® Software Support.

About this task

Important: Never change CCSIDs on an existing DB2 subsystem without guidance from IBM Software Support. If you think you need to change your subsystem CCSIDs, first consider the effects on all of your tools, applications, and utilities. Then contact IBM Software Support.

Procedure

To specify subsystem CCSIDs:

When you install DB2, specify the CCSIDs for the subsystem by using installation panel DSNTIPF or installation job DSNTIJUZ.
  • For the subsystem EBCDIC and ASCII CCSIDs, you must specify values according to the following criteria:
    • You must specify valid, non-zero CCSIDs for single-byte character set (SBCS) data. You should specify the CCSID values that you want to use for EBCDIC and ASCII data and objects by default. For a list of valid CCSIDs, see EBCDIC and ASCII support.
    • If you use languages with double-byte characters, such as Chinese, Japanese, or Korean, you must also specify valid, non-zero CCSIDs for multibyte character set (MBCS) data and double-byte character set (DBCS) data. All three of these values, the single-byte CCSID value (SBCS), the mixed CCSID value, and the double-byte CCSID value (DBCS), that are associated with a particular encoding scheme are collectively called a CCSID set. If you set these three values by using the installation panel DSNTIPF, you need to explicitly specify only the MBCS value. DB2 calculates the value of the other two based on the MBCS value. If you specify these values in job DSNTIJUZ, you need specify all three values.
  • For the subsystem Unicode CCSIDs, the values are provided for you, and you cannot change them. These CCSIDs are the only ones that DB2 uses for Unicode objects.

All of these CCSIDs are stored in Start of changedsnhdecpEnd of change and must be valid. Start of changedsnhdecp is the DSNHDECP module or a user-specified application defaults module. End of change

During startup processing, if DB2 detects invalid CCSID values, DB2 issues a message and terminates.