Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    34

    Unanswered: auto commit DB2 v9 for z/OS

    is there any possibility of using some kind of autocommit when doing one update without where clause or do we have to specify a where clause to
    do updates in smaller packages ?


    update table x set column y = 'NEWVALUE' ;
    .... table x is huge

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Swiss,
    I think you are asking if DB2 can commit updates that were performed in a single UOW, which the answer would be no. If you issue an update against a billion row table, there is nothing to commit until all billion rows have been updated, as you have a single update statement running.
    You will want to look into performing the updates in pieces/parts. Maybe you could load the data into another version of the table, with the update being what you selected from the orginal table, then rename the new version and drop the old. If you search through the forum here there have been past discussions on those types of topics.
    Dave

Posting Permissions

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