Error in upgrading the HCL Workload Automation database when using a DB2 database

When you run the configureDB script to upgrade DB2 when upgrading to HCL Workload Automation 9.5 or later, the following error messages are returned:
  • ALTER TABLE LOG.LLRC_LOG_RECORDS ADD COLUMN LLRC_DIFFERENCE VARCHAR (4095) DB21034E. The command was processed as an SQL statement because it was not a valid Command Line Processor command.
  • QL0670N The statement failed because the row or column size of the resulting table would have exceeded the row or column size limit: "8101". Table space name: "LOG_DAT_8K". Resulting row or column size: "10000". SQLSTATE=54010

Cause and solution:

If you try to upgrade HCL Workload Automation to version 9.5 or later, and the HCL Workload Automation database was created with DB2, the DB2 option EXTENDED_ROW_SZ remains set to DISABLE during the upgrade process.

Starting from HCL Workload Automation version 9.5, the LOG. LLRC_LOG_RECORDS table exceeds the table space or buffer pool page size which was previously set to 8 kilobytes and this causes the upgrade process to fail.

You can solve the problem by either changing the EXTENDED_ROW_SZ DB2 configuration parameter or, if you do not want to change this parameter, migrate the tables to a new buffer pool and table space with a page size of 16 kilobytes:
Change the DB2 configuration parameter
Change the DB2 configuration parameter EXTENDED_ROW_SZ to ENABLE.

OR

Create a new buffer pool and table space and migrate the tables to the new table space
  1. Create a new buffer pool and table space with a page size of 16 kilobytes instead of 8 kilobytes.
  2. Migrate the involved tables, which are defined in the LOG schema, to the new table space.