RESOURCE_CONTENT_MAX_SIZE

Description:

This parameter specifies the maximum file size, in bytes, for attachments in time off requests. The default value is 5242880, which is 5 MB in bytes. To accommodate larger files, you can increase the value of the parameter. In the database, the files are stored as BLOBs.

In DB2, the value of the registry parameter cannot exceed the size of the WB_RESOURCE.WBR_CONTENT column. By default, the size of the column is 5 MB, which is the same as the registry parameter.

To increase the file size limit in DB2, you must alter the size of the WB_RESOURCE.WBR_CONTENT column. For example, to increase the size to 10 MB (10485760), use this statement:

ALTER TABLE WB_RESOURCE 
   ALTER COLUMN WBR_CONTENT SET DATA TYPE BLOB(10485760)

Decreasing the size of the column is not supported.

Note: The preceding statement does not work on older versions of DB2 (before DB2 10). Alternatively, you can recreate the table using EXPORT, DROP TABLE, CREATE TABLE, and IMPORT.

Valid Values:

Any positive number, measured in bytes.

Default Value:

5242880 (5 MB)

Location:

system/WORKBRAIN_PARAMETERS/

Effective:

6.2.1