Subsystem CCSIDs and encoding schemes
Each DB2® subsystem has a set of default CCSID and encoding scheme values. DB2 uses these values for objects and applications that do not otherwise have a CCSID associated with them.
The subsystem CCSIDs are listed in the following table.
Subsystem CCSID | Field on installation panel DSNTIPF where the value is set | Description | Corresponding dsnhdecp values1, 3 |
---|---|---|---|
Subsystem default ASCII CCSID | ASCII CCSID | Specifies the default CCSID for ASCII-encoded
character data that is stored in your DB2 subsystem
or data sharing group. For a MIXED=NO subsystem, specify the ASCII SBCS CCSID only. In this case, the mixed and graphic CCSIDs are set to 65534 in dsnhdecp. For a MIXED=YES subsystem, specify the ASCII mixed CCSID. Based on the value that you entered, DB2 determines the SBCS CCSID and graphic CCSID. 2 |
|
Subsystem default EBCDIC CCSID | EBCDIC CCSID | Specifies the default CCSID for EBCDIC-encoded
character data that is stored in your DB2 subsystem
or data sharing system. For a MIXED=NO subsystem, specify the EBCDIC SBCS CCSID only. In this case, the mixed and graphic CCSIDs are set to 65534 in dsnhdecp. For a MIXED=YES subsystem, specify the EBCDIC mixed CCSID. Based on the value that you entered, DB2 determines the SBCS CCSID and graphic CCSID. 2 |
|
Subsystem default Unicode CCSID | UNICODE CCSID | Specifies the default CCSID for Unicode
character data that is stored in your DB2 subsystem
or data sharing system. This field is pre-filled with the default value of 1208, which is the CCSID for UTF-8. You cannot change this value. |
Because the value of UNICODE CCSID is always
1208, the dsnhdecp values are always as
follows:
|
notes:
|
The subsystem encoding schemes are listed in the following table.
Subsystem encoding scheme | Field on installation panel DSNTIPF where the value is set | Description | Corresponding dsnhdecp values1 |
---|---|---|---|
Subsystem default encoding scheme | DEF ENCODING SCHEME | Specifies which default subsystem CCSID (ASCII, EBCDIC, or Unicode) DB2 is to use for objects. | ENSCHEME |
Subsystem default application encoding scheme | APPLICATION ENCODING | Specifies which default subsystem CCSID (ASCII, EBCDIC, or Unicode) DB2 is to use for application data. | APPENSCH |
notes:
|