Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: update table out of uow

    Is it possible to have an operation out of the unit of work?

    I need to update a table regardless of the result of the whole uow. If, for any reason, I have to roll back, that update must be persistent.

    DB2 v7 on zOS

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I believe that you can START a new CICS tran asynchronously from your main program (passing the data needed to make the update), which will have a different unit of work. I did this about 10 years ago. Of course, if you are not using CICS in your main program, that may not very be convenient.
    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
    Oct 2004
    Posts
    3
    I cannot use any CICS sentences in my "subprogram"; only the main program is allowed to.

    My question was more directed to DB/2, because I think I heard something like you can put a table out of the scope of the unit of work.

Posting Permissions

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