Troubleshooting
Problem
When you migrate or upgrade from IBM Business Process Manager (IBM BPM) earlier than V8.5.5 to IBM Business Automation Workflow or a later version of IBM BPM, some BLOB columns in the Oracle database might be in BASICFILE format instead of SECUREFILE format.
Cause
In all versions of IBM Business Automation Workflow, and versions of IBM BPM since V8.5.5, Oracle SecureFiles LOBs are used for all IBM BPM LOB columns. In earlier versions, however, Oracle BasicFiles LOBs were used.
When you migrate or upgrade, only new LOB columns are created in SECUREFILE format. Existing columns are not upgraded from BASICFILE to SECUREFILE storage based on the following considerations:
- IBM BPM uses the default table space values, so the hints for the UNIFORM SIZE are relevant.
- Reclaiming space can cause problems.
- From a performance perspective, not all LOB columns need to be changed.
Resolving The Problem
You can change the storage option for LOB columns using proven procedures provided by the database vendor. Changing the LOB columns with high load, such as EXECUTION_CONTEXT in the LSW_TASK_EXECUTION_CONTEXT table and DATA in the LSW_BPD_INSTANCE_DATA table, is a good starting point.
Make sure you have a backup before you change the LOB storage options.
If you change the LOB storage options, put every LOB in a dedicated table space.
The following table shows the LOB columns you might want to change based on your usage.
|
Table Name |
LOB Column |
|
LSW_BPD_INSTANCE_DATA |
DATA |
|
LSW_TASK_EXECUTION_CONTEXT |
EXECUTION_CONTEXT |
|
LSW_BPD_NOTIFICATION |
DATA, ERROR, ERROR_STACK_TRACE |
|
LSW_TASK_NARR |
I18N_NARRATIVES, NARRATIVE, NARRATIVE_RAW |
|
LSW_EM_TASK |
TASK_ARGUMENTS |
|
LSW_PO_VERSIONS |
PO_DATA, VALIDATION_ERRS |
|
LSW_PO_REFERENCE |
TARGET_SUMMARY_DATA |
|
LSW_BPD_INSTANCE |
ERROR, ERROR_STACK_TRACE |
|
LSW_INST_MSG_INCL |
CORRELATION_BLOB |
|
LSW_DUR_MSG_RECEIVED |
CORRELATION_BLOB, VALUES_DATA |
|
LSW_EPV_VAR_VALUE |
REASON, VALUE |
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
14 September 2022
UID
ibm11102263