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
Back to discussions
Expand all | Collapse all

replace data in column organized tables

  • 1.  replace data in column organized tables

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