The DBCS option can be set either for all application requesters, or it can be set by an individual application requester. For more information see either Setting the DBCS Option for all Application Requesters, or Setting the DBCS Option for an Application Requester.
If you want to check the DBCS option, use SQLINIT QRY from an application requester.
When you run the SQLGLOB EXEC on a database machine, the EXEC sets the DBCS option for all application requesters that are linked to the production minidisk. You must have write access to the production minidisk to run the SQLGLOB EXEC.
To specify that the DBCS option is set to YES as the default for the application requesters, run the SQLGLOB EXEC as follows:
SQLGLOB DBCS (YES)
To specify that the DBCS option is set to NO as the default for the application requesters, run the SQLGLOB EXEC as follows:
SQLGLOB DBCS (NO)
The SQLGLOB EXEC defaults do not apply to application requesters that have already run the SQLINIT EXEC (and thereby have values in their LASTING GLOBALV file).
For more information, see Using Double-Byte Character Set (DBCS). For more information about the SQLGLOB EXEC, see the DB2 Server for VSE & VM Database Administration manual.
To use a DBCS option different from that specified by SQLGLOB, run the SQLINIT EXEC on the application requester and specify the DBCS parameter. The value specified for the DBCS option will override the database-wide default established by the SQLGLOB EXEC.
To set the DBCS option to YES, run the SQLINIT EXEC as follows:
SQLINIT DBCS (YES)
To set the DBCS option to NO, run the SQLINIT EXEC as follows:
SQLINIT DBCS (NO)
For more information about the SQLINIT EXEC, see the DB2 Server for VSE & VM Database Administration manual.