Db2 (On Premises and Cloud)

Expand all | Collapse all

Error for Batch Element #481

  • 1.  Error for Batch Element #481

    Posted Thu February 04, 2021 11:29 AM
    Hi Community!

    Trying to install the DMC 3.1.4 on Linux. After setup.sh start the Web application to configure the DMC repository.

    After testing the Connection and clicking on "weiter" (the german version) I get the following Error Message:

    Error for batch element #481: The statement failed because the row or column size of the resulting table would have exceeded the row or column size limit: "32677". Table space name: "TS4CONSOLE". Resulting row or column size: "63309".. SQLCODE=-670, SQLSTATE=54010

    any ideas?

    regards
    Joerg

    ------------------------------
    Jörg Burdorf
    ------------------------------


  • 2.  RE: Error for Batch Element #481

    Posted Fri February 05, 2021 10:26 AM
    Hello Joerg,
    After DMC V3.1.4, there is an additional step to configure the DMC repository database, for more details, please refer to the DMC manual at:
    https://www.ibm.com/support/knowledgecenter/SS5Q8A_3.1.x/com.ibm.datatools.dsweb.ots.installconfig.doc/topics/creatingrepo_DB2_LUW.html
    Make sure that the DMC repository database has the following configuration:
    db2 UPDATE DATABASE CONFIGURATION FOR repodb USING EXTENDED_ROW_SZ enable
    I hope that helps!

    ------------------------------
    Cintia Ogura
    ------------------------------



  • 3.  RE: Error for Batch Element #481

    Posted Tue February 09, 2021 03:07 AM
    Hey Cintia!

    Thanks a lot! It works!

    regards 
    Joerg

    ------------------------------
    Jörg Burdorf
    ------------------------------