Use the Autonomus Schema Update (-SQLWidthUpdate) to resolve the SQL width problem by updating the SQL column width in schema automatically when Authorized Data Truncation (ADT) occurs for data in a column.

Operating system and syntax UNIX / Windows 
-SQLWidthUpdate ON
Use with Maximum value Minimum value Single-user default Multi-user default
DBS — — OFF OFF

Once the value of the parameter is set, it is remembered for the lifetime of the server and for all connections. If this parameter is set to ON during startup, the Authorized Data Truncation (_SQLTruncateTooLarge) parameter is also enabled irrespective of whether ADT was enabled during startup unless specified otherwise using connection URL.

The Autonomus Schema Update (-SQLWidthUpdate) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.