Results 1 to 2 of 2

Thread: old image

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: old image

    Hi

    orcale, have undo tablespace which provide old image user and avoid lock's for the readers ?

    DB2 stores transactions committed and uncommitted data in log files, nothing like old image, until db2 9.7 which has currently committed option which also stores the old image in logs which allow the user to read this.

    Please correct me.

    regds
    Paul

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    i don't know the exact details, but you are right.
    DB2 keeps the old versions in the Transaction-Logs.

    SQL-Server uses tempdb for it's snapshot-isolation.

Posting Permissions

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