Method, system and article of manufacture for rolling back past a boundary generator to a savepoint located in a unit of work

1. A data processing-system implemented method for directing a data processing system to roll-back to a savepoint, having an associated savepoint status indicator, located in a unit of work having a boundary, the data processing system-implemented method comprising the steps of:

examining the savepoint status indicator; and

rolling-back past the boundary to the savepoint responsive to the examined savepoint status indicator indicating rolling-back past the boundary towards the savepoint is permitted,

wherein the boundary is generated by a boundary generator, and

wherein a user requests insertion of the boundary generator into the unit of work, and a name of the boundary generator is inserted into a boundary generator queue.

2. The data processing-system implemented method of claim 1 further comprising the steps of: associating a savepoint status indicator manipulation rule with the boundary generator; and manipulating the savepoint status indicator according to a current status of the savepoint status indicator manipulation rule, the manipulated savepoint status indicator indicating rolling-back past the boundary is permitted.

3. The data processing system-implemented method of claim 1 further comprising the steps of: locating a savepoint identifier associated with the savepoint from a savepoint queue; and associating the savepoint status indicator with the savepoint identifier.

4. The data processing system-implemented method of claim 1 further comprising the step of: determining whether the boundary generator is a boundary generating request.

5. The data processing system-implemented method of claim 4 further comprising the step of: determining whether the boundary generating request is an Atomic Compound SQL statement.

6. The data processing system-implemented method of claim 1 further comprising the step of: determining whether the boundary generator is a boundary generating routine.

7. The data processing system-implemented method of claim 6 further comprising the step of: determining whether the boundary generating routine is one of: a stored procedure STP 1 statement; a function f 1 statement; and a stored procedure STP 2 statement.

8. An article of manufacture for directing a data processing system to roll-back to a savepoint, having an associated savepoint status indicator, located in a unit of work having a boundary, the article of manufacture comprising:

a data processing system usable storage medium embodying one or more instructions executable by the data processing system, the one or more instructions comprising:

data processing system executable instructions for examining the savepoint status indicator; and

data processing system executable instructions for rolling-back past the boundary to the savepoint responsive to the examined savepoint status indicator indicating rolling-back past the boundary towards the savepoint is permitted,

wherein the boundary is generated by a boundary generator, and

wherein a user requests insertion of the boundary generator into the unit of work, and a name of the boundary generator is inserted into a boundary generator queue.

9. The article of manufacture of claim 8 further comprising: data processing system executable instructions for associating a savepoint status indicator manipulation rule with the boundary generator; and data processing system executable instructions for manipulating the savepoint status indicator according to a current status of the savepoint status indicator manipulation rule, the manipulated savepoint status indicator indicating rolling-back past the boundary is permitted.

10. The article of manufacture of claim 8 further comprising: data processing system executable instructions for locating a savepoint identifier associated with the savepoint from a savepoint queue; and data processing system executable instructions for associating the savepoint status indicator with the savepoint identifier.

11. The article of manufacture of claim 8 further comprising: data processing system executable instructions for determining whether the boundary generator is a boundary generating request.

12. The article of manufacture of claim 11 further comprising: data processing system executable instructions for determining whether the boundary generating request is an Atomic Compound SQL statement.

13. The article of manufacture of claim 8 further comprising: data processing system executable instructions for determining whether the boundary generator is a boundary generating routine.

14. The article of manufacture of claim 13 further comprising: data processing system executable instructions for determining whether the boundary generating routine is one of: a stored procedure STP 1 statement; a function f 1 statement; and a stored procedure STP 2 statement.

15. A data processing system for rolling-back to a savepoint, having an associated savepoint status indicator, located in a unit of work having a boundary, the data processing system comprising:

an examination module stored on a memory, for examining the savepoint status indicator; and

a rolling-back module stored on the memory, for rolling-back past the boundary to the savepoint responsive to the examined savepoint status indicator indicating rolling-back past the boundary towards the savepoint is permitted,

wherein the boundary is generated by a boundary generator, and

wherein a user requests insertion of the boundary generator into the unit of work, and a name of the boundary generator is inserted into a boundary generator queue.

16. The data processing system of claim 15 further comprising: an associating module of the memory for associating a savepoint status indicator manipulation rule with the boundary generator; and a manipulation module for manipulating the savepoint status indicator according to a current status of the savepoint status indicator manipulation rule, the manipulated savepoint status indicator indicating rolling-back past the boundary is permitted.

17. The data processing system of claim 15 further comprising: a locating module for locating a savepoint identifier associated with the savepoint from a savepoint queue; and an associating module for associating the savepoint status indicator with the savepoint identifier.

18. The data processing system of claim 15 further comprising: a determining module for determining whether the boundary generator is a boundary generating request.

19. The data processing system of claim 18 further comprising: a determining module for determining whether the boundary generating request is an Atomic Compound SQL statement.

20. The data processing system of claim 15 further comprising: a determining module for determining whether the boundary generator is a boundary generating routine.

21. The data processing system of claim 20 further comprising: a determining module for determining whether the boundary generating routine is one of: a stored procedure STP 1 statement; a function f 1 statement; and a stored procedure STP 2 statement.

22. The method according to claim 1 , wherein the unit of work contains a plurality of database statements to be executed by a database management system against a database.

23. The method according to claim 1 , wherein the savepoint is a marker within the unit of work.

24. The method according to claim 23 , wherein the savepoint is set by a user.

25. The method according to claim 1 , wherein the savepoint status indicator indicates whether the boundary exists in the unit of work.

26. The method according to claim 1 , wherein the savepoint status indicator indicates whether the boundary generator has been processed.