Data truncation error in Applications tool

For installations using DB2i, the default BLOB size of 1MB might not be enough and may trigger a data truncation error in the log. For troubleshooting, contact your database administrator and ask to change the size of the CONTENT column in the DATAFILES table.

Note: This procedure must be done by the database administrator.
  1. In the database, increase the maximum allowed size for the CONTENT column in the DATAFILES table to 10 MB by using this statement:

    ALTER TABLE <Schema>.DATAFILES ALTER COLUMN CONTENT SET DATA TYPE BLOB(10M)

  2. Replace <Schema> with the schema for the DATAFILES table.
  3. Execute the SQL command to update the column size.