Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What's the mean "NOTRUNCATE TABLE"?
- Thread starter jip102
- Start date
Without the additional clause DB2 will try to reclaim space by truncating the table. (This is not a truncate as known with Oracle that deletes all data)
This last action will lock the table and this will prevent writing to the table.
So by adding the NOTRUNCATE clause the table will stay unlocked during the entire process and data can be written to it..
Ties Blom
This last action will lock the table and this will prevent writing to the table.
So by adding the NOTRUNCATE clause the table will stay unlocked during the entire process and data can be written to it..
Ties Blom
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question