Extending database row sizes for the databases (Db2)

After you restore your IBM OpenPages® with Watson™ database to the supported version of IBM® Db2® you must manually enable the EXTENDED_ROW_SZ database configuration parameter.

Procedure

  1. If you are using Microsoft Windows, start the Db2 command line processor.

    From the command prompt, type db2cmd. Or, click Start > IBM Db2 > IBM Db2 Db2COPY1 > Command Line Tools > Db2 Command Window - Administrator.

  2. Connect to the OpenPages database.

    For example, type

    db2 connect to OPX user <userid>
  3. Enter the following commands: 
    db2 update db cfg using EXTENDED_ROW_SZ ENABLE
db2 update db cfg for OPX using APPLHEAPSZ 25600 APPL_MEMORY 320000