Results 1 to 4 of 4

Thread: DB2 question

  1. #1
    Join Date
    Oct 2007
    Posts
    23

    Unanswered: DB2 question

    Which of the following occurs if an application ends abnormally during an active unit of work?
    A 、Current unit of work moves to pending state
    B、Current unit of work remains active
    C、Current unit of work is committed
    D、Current unit of work is rolled back
    answer is D or A ?
    Thanks any help would be great !

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    D、Current unit of work is rolled back
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    This is basic stuff for transaction management (not only for database systems). Since you are preparing for a DB2 certification, I recommend that you learn a bit about transaction handling in general and DB2 in particular.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Oct 2007
    Posts
    23
    thanks for reply

Posting Permissions

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