The DBCS option is set by updating a particular row in the SYSTEM.SYSOPTIONS catalog table. The initial setting of the DBCS option is NO. To set the DBCS option to YES, issue:
UPDATE SYSTEM.SYSOPTIONS
SET VALUE = 'YES'
WHERE SQLOPTION = 'DBCS'
To reset the DBCS option to NO, issue:
UPDATE SYSTEM.SYSOPTIONS
SET VALUE = 'NO'
WHERE SQLOPTION = 'DBCS'
You must have DBA authority to issue either of the above commands.
The new setting of the DBCS option will be effective the next time that the application server is started. The new setting does not become effective immediately.
If anything other than YES or NO is specified for the DBCS option in the SYSOPTIONS table, NO is assumed, and an error message is issued during startup.
For more information, see Using Double-Byte Character Set (DBCS).