Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    30

    Unanswered: regarding delete statement

    db2v8.2 fp4Aix
    Hi I have a question regarding delete statements
    i think that by default delete statement will hold xclusive lock may be on the rows its trying to delete.
    if suppose a backup(online) and a delete statment runs simultaneously then will there be any locking issues?

    thanks...

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not think so. If the delete have not been committed yet, then there will be the log entries for the deletes. If you "include logs" in your backup then this information is also in the backup image. If the delete are then subsequently committed during the backup, that will also be in the log and included in the image. Restoring the image will have the deleted rows still there and then rollforward will perform the deletes.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •