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
-
- Create a new buffer pool and table space with a page size of 16 kilobytes instead of 8 kilobytes.
- Migrate the involved tables, which are defined in the LOG schema, to the new table space.