Content Management and Capture

Expand all | Collapse all

the summation of column length exceeds the capacity of the underlying database

  • 1.  the summation of column length exceeds the capacity of the underlying database

    Posted Mon December 28, 2020 10:30 AM
      |   view attached

    Hello Forum members.

    I am trying to create a ICF setup (Non Prod) with following product line :

    Websphere 8.5.5.16

    DB2 Enterprise Server Edition 10.5.0.4

    CPE : 5.5.6

    Case Foundation : 5.3.0

    I am facing a problem when creating the first object store:

    Error reads : Product name: "DB2 Enterprise Server Edition"

    Has anybody faced this issue before? Can anyone suggest any steps to remediate the issue.

    I have also checked that EXTENDED_ROW_SZ ENABLE is set.



    ------------------------------
    Samarth Saxena
    ------------------------------


  • 2.  RE: the summation of column length exceeds the capacity of the underlying database

    Posted Tue December 29, 2020 05:12 AM

    Do you have the tablespace configured with 32k page size?



    ------------------------------
    Mike
    ------------------------------



  • 3.  RE: the summation of column length exceeds the capacity of the underlying database

    Posted Tue January 05, 2021 03:25 AM

    Hello,

    On this you would want to make sure first, that the database and the tablespaces have been created with a pagesize of 32K, as it is documented.

    Best regards, Matthias



    ------------------------------
    Matthias Jung
    ------------------------------



  • 4.  RE: the summation of column length exceeds the capacity of the underlying database

    Posted Thu January 07, 2021 10:49 PM
    Hi All,

    Correct, that was the issue. The Table spaces were not properly set to 32K, I recreated the DB with 32K table spaces and it worked without issues.

    Thanks,
    Samarth Saxena
    Senior Datacap and FileNet Administrator
    IBM India Software Labs