Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

replace data in column organized tables

  • 1.  replace data in column organized tables

    Posted Thu April 29, 2021 04:01 AM
    we are using column organized tables and do not have indexes/pk on these tables
    now we want to refresh these tables, and tried to use export from source and import insert_update to target
    but this is not supported if PK is available
    I tried :
    truncate target table - insert.. select into target table
    but in this case we have a time that no data is available
    do you think of any other method we could use to replace data with minimum outage ?

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    #Db2


Related Content