The DBCS option for the application server is set by updating a field in the SYSTEM.SYSOPTIONS catalog table. You must have DBA authority to update the 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'
In both situations, the new setting does not become effective immediately. The new setting is not in effect until the next time the application server is started.
If you specify anything other than YES or NO for the DBCS option, NO is assumed and an error message is issued during startup.
For more information, see Using Double-Byte Character Set (DBCS).