Accommodation of data definition statements in the sharing of dynamic SQL statements

摘要

A relational database management system which determines the shareable status of an executable object (section) in an cache. The shareable status is defined for a section in a cache by the system maintaining an identification list which has reference to database entities which are affected by a statement in the current unit of work. When a statement is compiled, the compiler generates a list of dependencies, which list is compared with the identification list. If the statement data dependencies are on the identification list, the statement will be treated as non-shareable until the completion of the current unit of work.