Configuring BLOB Data Compression

When process and instance attributes are written to the PVM tables in the BPM database, large string values are stored as BLOB data. Large string values are defined as:

  • greater than 512 on SQL Server
  • greater than 1792 on DB2
  • greater than 2048 on Oracle or PostgreSQL

If there are a lot of these large string values, significant amounts of BLOB storage can be used. You can use the following properties, in the pvm.properties file, to optionally compress large field values and so reduce the storage used.

JVM Property Default Description
blobCompress false Whether compression is enabled (true) or disabled (false).
blobCompressThreshold 4096 The threshold length above which a field value will be compressed.
blobCompressBufferSize 2048 Buffer size used by the internal compression algorithm.
Note: Do not change this value unless advised to do by TIBCO Support.