Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Error for Batch Element #481

    Posted 02/04/21 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
    ------------------------------

    #Db2


  • 2.  RE: Error for Batch Element #481

    Posted 02/05/21 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 02/09/21 03:07 AM
    Hey Cintia!

    Thanks a lot! It works!

    regards 
    Joerg

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

    Original Message


Related Content