The present invention relates to workload management (WLM), and more specifically, to the integration of the WLM logic of a component in an information technology (IT) environment with cross-component WLM software.
Customer IT environments consist of multiple components including hardware platforms, with associated operating systems, and multiple software products. The objective of the customer in such an environment is to manage this heterogeneous mixture in an efficient and cohesive way in order to achieve their business objectives, which are usually expressed to the IT environment in terms of throughput and performance objectives. To aid the customer in this exercise, a number of the components in the standard IT environment have introduced a form of workload management (WLM) to help reflect business priorities and objectives onto the lower-level requests that they process.
In addition to the WLM logic in such standard IT components, new cross-component products, such as IBM's EWLM, have been introduced to help coordinate WLM efforts over the environment as a whole. One challenge posed by such products is to efficiently enable the individual components to tightly integrate their own internal WLM efforts with cross-component WLM software so that the overall effect is harmonious and the impact on the customer in terms of effort and maintenance is minimized. The cross-component WLM software has awareness of much more of the business than the individual component, while the individual component is the only one aware of how external requests map into its own internal processing mechanisms. The latter situation is particularly true in the case of relational database systems (RDBMS) where business requests almost always break down into one or more internal requests.
According to one embodiment of the present invention, a method comprises: receiving a request in a database component, the request including a cross component token; starting a new unit of work in workload management software in the database component, in response to the request; determining, from a cross component workload management unit, a transaction class and a synchronization code using the database component; finding an internal workload in the workload management software that matches the transaction class and the synchronization code of the cross component workload management unit; and using the matching internal workload for the new unit of work.
According to another embodiment of the present invention, a method comprises: receiving a request in a relational database management system, the relational database management system having internal workload management software, wherein the request includes an external workload management system token; starting a new unit of work in the internal workload management software in the relational database management system; the relational database management system contacting an external workload management system to determine an external workload management system transaction class and synchronization code; the relational database management system finding an internal workload in the internal workload management software that matches the transaction class and the synchronization code of the external workload management system; and the relational database management system using the matching internal workload for the new unit of work.
According to a further embodiment of the present invention, a system comprises: a relational database management system; internal workload management software within the relational database management system; an external workload management system; the internal workload management software receiving an incoming request which has been classified by the external workload management system and analyzing the request to determine the classification of the request.
According to another embodiment of the present invention, a computer program product for integrating an external workload manager and a database system comprises: a computer usable medium having computer usable program code embodied therewith, the computer usable program code comprising: computer usable program code configured to: receive a request in a database component, the request including a cross component token; start a new unit of work in workload management software in the database component; determine, from a cross component workload management unit, a transaction class and a synchronization code using the database component; find an internal workload in the workload management software that matches the transaction class and the synchronization code of the cross component workload management unit; and use the matching internal workload for the new unit of work.
Embodiments of the invention provide a system, method and computer program product for integrating a cross-component workload manger (WLM) with a component, such as a relational database management system (RDBMS). In particular, embodiments of the invention employ an efficient method for integrating both the WLM knowledge and handling performed by a cross-component WLM software product and a component WLM software product. In an exemplary embodiment, the cross-component WLM product is EWLM, and the component which also contains WLM logic is DB2 for Linux, UNIX, and Windows (DB2 for LUW). In embodiments of the invention, a component such as an RDBMS (e.g. DB2 for LUW) can discover what type of external requests it is receiving and can interact with an identified cross-component product like EWLM to acquire the definitions needed to synchronize its internal processing with the external WLM controls. In accordance with some aspects of the invention, this can be done in an RDBMS for both partitioned and non-partitioned databases.
Embodiments of the invention employ an algorithm by which component WLM logic can:
In terms of DB2 for LUW, embodiments of the invention the WLM logic within DB2 for LUW can automatically discover, acquire, and align DB2 WLM definitions with those being used by EWLM. Also, DB2 WLM and EWLM can cooperatively manage request processing within DB2 for LUW. In various embodiments of the invention this can be done for both partitioned and non-partitioned databases.
There are a number of benefits of the invention including:
In contrast, prior systems usually addressed the challenge of efficiently enabling individual components to tightly integrate their own internal WLM efforts with cross-component WLM software. in one of the following ways:
None of the three approaches offer a satisfactory solution. The first approach requires that the customer explain the business priorities and objectives to each WLM product and there is no sharing of information or cooperative handling of requests.
The second approach greatly increases the amount of information that the individual component must store and analyze when processing requests with much of this information perhaps being irrelevant to the component since it does not receive requests related to that information. This negatively affects the storage requirements and processing overhead of the component WLM logic. Also, this approach requires that the component WLM logic has the inherent capabilities needed to understand and enforce the stated objectives.
The last approach requires duplicate and inefficient use of system resources in order to create separate processing environments. It also increases the complexity and thus, the manageability, of the customer's environment. Furthermore when an RDBMS is acting as the component, an additional complexity arises in the area of a shared-nothing RDBMS where external requests come in from multiple database partitions and need to be treated properly and consistently regardless of where they arrive.
With the present invention, there is a partnership and efficient interaction between the cross-component and component WLM logic to minimize the interactions and effort required of the customer. Also, with the present invention, each part is allowed to do what it is good at, and system resources are used efficiently.
In the following discussion, the specific examples of EWLM and DB2 for LUW are used for illustration purposes. However, those skilled in the art will appreciate that the teachings of the present invention may be applied to other components besides DB2 for LUW including other types of RDBMS, and that the teachings of the present invention may be applied to other cross-component WLM products besides EWLM.
Referring now to
External business requests 24 are received by the component 12. Each external business request 24 contains an associated EWLM identification token 26. This EWLM identification token 26 represents how the request was identified and classified within EWLM 18. The EWLM 18 assigns work to a specific EWLM transaction class 28 within a specific EWLM service class in the EWLM service class unit 20. A business request usually breaks down into at least one distinct database unit of work (UOW) with one or more database requests being made to DB2 for LUW within that UOW.
There are two prerequisite changes that should be made to implements embodiments of the invention. These are:
Referring now to
Next, in steps 38 and 40, DB2 will search for a matching DB2 workload with the same synchronization code and same EWLM transaction class. If a different synchronization code is encountered, there is no match and DB2 will detect that a cleanup is required for this workload. The cleanup is performed in step 42, which is described in more detail in
If step 40 determines that there is a match, that workload is used for this UOW, in step 46. In step 48, the process uses the normal DB2 service class mapping from the workload definition. In step 50, if there is an EWLM service class associated with DB2 service class definition, the process 30 will automatically call the EWLM_API2 to associate the DB2 agent processing this database request with the related external EWLM service class. It is noted that a DB2 workload that is associated with an EWLM transaction class should have an associated DB2 service class with an EWLM service class association. If a request is mapped to a DB2 service class with no associated EWLM service class mapping, DB2 won't call EWLM_API2 to associate the agent working on that request with EWLM.
In one embodiment of the invention, an autonomous daemon performs a number of checks on a regular basis. In particular, the autonomous daemon checks the central discovery and clean up lists on a regular basis to sync up DB2's workload management configuration with EWLM's configuration. When a request is associated with an EWLM transaction class and EWLM service class, it is desirable for DB2 to have the associated DB2 workload and DB2 service class available for the request to execute in. In order to keep up with changes to the EWLM configuration, DB2 uses an autonomous daemon to check for new or updated EWLM transactions classes and associated EWLM service classes. Once information on a new or updated EWLM transaction class is retrieved from EWLM, an associated DB2 workload is created. An associated DB2 service class is also created if it does not already exist. The autonomous daemon checks the clean up list to remove stale DB2 workloads for which the associated EWLM transaction class no longer exists or has been modified. Stale DB2 service classes that are associated EWLM service classes may also be removed.
As will be appreciated by one skilled in the art, the present invention may be embodied as a system, method or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment (including firmware, resident software, micro-code, etc.) or an embodiment combining software and hardware aspects that may all generally be referred to herein as a “circuit,” “module” or “system.” Furthermore, the present invention may take the form of a computer program product embodied in any tangible medium of expression having computer usable program code embodied in the medium.
Any combination of one or more computer usable or computer readable medium(s) may be utilized. The computer-usable or computer-readable medium may be, for example but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, device, or propagation medium. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CDROM), an optical storage device, a transmission media such as those supporting the Internet or an intranet, or a magnetic storage device. Note that the computer-usable or computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via, for instance, optical scanning of the paper or other medium, then compiled, interpreted, or otherwise processed in a suitable manner, if necessary, and then stored in a computer memory. In the context of this document, a computer-usable or computer-readable medium may be any medium that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. The computer-usable medium may include a propagated data signal with the computer-usable program code embodied therewith, either in baseband or as part of a carrier wave. The computer usable program code may be transmitted using any appropriate medium, including but not limited to wireless, wire line, optical fiber cable, RF, etc.
Computer program code for carrying out operations of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages, such as the “C” programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet Service Provider).
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable medium that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable medium produce an article of manufacture including instruction means which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks.
The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The computer system can include a display interface 106 that forwards graphics, text, and other data from the communication infrastructure 104 (or from a frame buffer not shown) for display on a display unit 108. The computer system also includes a main memory 110, preferably random access memory (RAM), and may also include a secondary memory 112. The secondary memory 112 may include, for example, a hard disk drive 114 and/or a removable storage drive 116, representing, for example, a floppy disk drive, a magnetic tape drive, or an optical disk drive. The removable storage drive 116 reads from and/or writes to a removable storage unit 118 in a manner well known to those having ordinary skill in the art. Removable storage unit 118 represents, for example, a floppy disk, a compact disc, a magnetic tape, or an optical disk, etc. which is read by and written to by removable storage drive 116. As will be appreciated, the removable storage unit 118 includes a computer readable medium having stored therein computer software and/or data.
In alternative embodiments, the secondary memory 112 may include other similar means for allowing computer programs or other instructions to be loaded into the computer system. Such means may include, for example, a removable storage unit 120 and an interface 122. Examples of such means may include a program cartridge and cartridge interface (such as that found in video game devices), a removable memory chip (such as an EPROM, or PROM) and associated socket, and other removable storage units 120 and interfaces 122 which allow software and data to be transferred from the removable storage unit 120 to the computer system.
The computer system may also include a communications interface 124. Communications interface 124 allows software and data to be transferred between the computer system and external devices. Examples of communications interface 124 may include a modem, a network interface (such as an Ethernet card), a communications port, or a PCMCIA slot and card, etc. Software and data transferred via communications interface 124 are in the form of signals which may be, for example, electronic, electromagnetic, optical, or other signals capable of being received by communications interface 124. These signals are provided to communications interface 124 via a communications path (i.e., channel) 126. This communications path 126 carries signals and may be implemented using wire or cable, fiber optics, a phone line, a cellular phone link, an RF link, and/or other communications channels.
In this document, the terms “computer program medium,” “computer usable medium,” and “computer readable medium” are used to generally refer to media such as main memory 110 and secondary memory 112, removable storage drive 116, and a hard disk installed in hard disk drive 114.
Computer programs (also called computer control logic) are stored in main memory 110 and/or secondary memory 112. Computer programs may also be received via communications interface 124. Such computer programs, when executed, enable the computer system to perform the features of the present invention as discussed herein. In particular, the computer programs, when executed, enable the processor 102 to perform the features of the computer system. Accordingly, such computer programs represent controllers of the computer system.
From the above description, it can be seen that the present invention provides a system, computer program product, and method for implementing the embodiments of the invention. References in the claims to an element in the singular is not intended to mean “one and only” unless explicitly so stated, but rather “one or more.” All structural and functional equivalents to the elements of the above-described exemplary embodiment that are currently known or later come to be known to those of ordinary skill in the art are intended to be encompassed by the present claims. No claim element herein is to be construed under the provisions of 35 U.S.C. section 112, sixth paragraph, unless the element is expressly recited using the phrase “means for” or “step for.”
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used herein, the singular forms “a”, “an” and “the” are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms “comprises” and/or “comprising,” when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
The corresponding structures, materials, acts, and equivalents of all means or step plus function elements in the claims below are intended to include any structure, material, or act for performing the function in combination with other claimed elements as specifically claimed. The description of the present invention has been presented for purposes of illustration and description, but is not intended to be exhaustive or limited to the invention in the form disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the invention. The embodiment was chosen and described in order to best explain the principles of the invention and the practical application, and to enable others of ordinary skill in the art to understand the invention for various embodiments with various modifications as are suited to the particular use contemplated.