Determining current subsystem CCSID and encoding scheme values

For an existing subsystem, you can check the CCSID values, but do not make changes. If you suspect that the specified CCSIDs are incorrect or you need to change them, contact IBM® Support.

Procedure

To determine current subsystem CCSID and encoding scheme values, perform one of the following actions:

  • Use the GETVARIABLE function.
    Begin general-use programming interface information.

    In each of the following example GETVARIABLE calls, :hv3 is a varying-length character variable with a maximum length of 20.

    • The following example code retrieves the value of the subsystem EBCDIC CCSID, which contains three comma-delimited values that correspond to the SBCS, MIXED, and GRAPHIC CCSIDs for the encoding scheme:

      SET :hv3 = GETVARIABLE('SYSIBM.SYSTEM_EBCDIC_CCSID');

    • The following example code retrieves the value of the subsystem default encoding scheme:

      SET :hv3 = GETVARIABLE('SYSIBM.ENCODING_SCHEME');

    • The following example code retrieves the value of the subsystem default application encoding scheme:

      SET :hv3 = GETVARIABLE('SYSIBM.APPLICATION_ENCODING_SCHEME');
    End general-use programming interface information.
  • Run the DSNJU004 utility for the current subsystem or member, and look at the SYSTEM CCSIDS section in the output.
    Restriction: DSNJU004 does not return the subsystem encoding scheme values (DECP values ENSCHEME and APPENSCH). To get those values, use the GETVARIABLE function.
    For example, the following code shows example JCL to execute DSNJU004 and the relevant portion of the output.
    //PLM EXEC PGM=DSNJU004
//GROUP DD DSN=DBD1.BSDS01,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
MEMBER *
/*
…
SYSTEM CCSIDS
18:12:47 MAY 18, 2005
SYSTEM CCSIDS
--------------------
ASCII SBCS = 1252
ASCII MIXED = 65534
ASCII DBCS = 65534
EBCDIC SBCS = 37
EBCDIC MBCS = 65534
EBCDIC DBCS = 65534
UNICODE SBCS = 367
UNICODE MBCS = 1208
UNICODE DBCS = 1200
DSNJ200I DSNJU004 PRINT LOG UTILITY PROCESSING COMPLETED SUCCESSFULLY
    This output shows that the default ASCII CCSID is 1252 and the default EBCDIC CCSID is 37. This subsystem does not have CCSIDs defined for ASCII or EBCDIC data that is mixed or double-byte. The Unicode CCSIDs are the default CCSIDs that are predefined by Db2. You cannot change these values.
  • Run job DSNTEJ6Z, which calls the ADMIN_INFO_SYSPARM stored procedure to list your current subsystem parameter settings.
    To determine the subsystem CCSIDs, examine the values of the following subsystem parameters:
    • MIXED
    • AGCCSID
    • AMCCSID
    • ASCCSID
    • GCCSID
    • MCCSID
    • SCCSID
    • UGCCSID
    • UMCCSID
    • USCCSID