Serena DB2 option

Tasks:

The applications working at mainframes usually use IBM DB2 as the database management system. There is a quantity DB2 component, objects and configuration elements which the application should include for work with DB2. By analogy with changes in the software the packet with the new version of the code (ZMF change package) smoothly passes statuses of development and flows from one environment in another, usually, the development environment, the testing environment, the environment of commercial operation are used. At the same time, engineers and administrators should control and change manually appropriately configuration DB2 elements for use on different environments. It is quite labor-consuming and problematic set of procedures. Engineers sometimes even write the scripts, for the solution of this task. The option ZMF for DB2 provides additional tool kit for management and control of configuration objects DB2: DBRM's, Application Plans, Application Packages and Associated Bind Control Statements.

The option for DB2 supports such types of the stored DBMS objects as stored procedures, triggers and the functions determined by the user (User Defined Functions - UDFs) for increase in level of integrity and controllability of different environments. The users who are intensively using DB2 will be able significantly to reduce temporary costs due to such automation of actions with objects and configuration DB2 elements and also works with the system catalog (System Catalogue). In addition, if the option for DB2 is used, the file of a product for the analysis of impact of changes (Serena ChangeMan Impact Analysis) will be stored in DB2.

Use value:

The option ZMF for DB2 facilitates build process of DB2 modules on all steps of work with Wednesday (promote, demote, install, backout). The option helps to specify all plans and packets which need to be slinkovat. The option can change one selected set of operators of assembly for use on several environments and copies of DB2 databases. Thus, the product allows to reduce participation of the person in the course of transfer of a packet of changes between Wednesdays and to increase quality due to recurrence and controllability of the automated approach.

Key advantages:

Expands possibilities of ChangeMan ZMF for work with objects and configuration DB2 elements: DBRMs, Application Plans, Application Packages, stored procedures, triggers determined by the user of function (UDFs) - all with support of operators of a linkovaniye.

• Automates process of a linkovaniye of Plans of the application and Packets of the application as Paqueta of changes which then can be transferred and set on different environments (developments, testings, commercial operation) with a possibility of recovery of the previous version of a configuration.
• Allows to use a set of logical virtual environments of testing on one physical DB2 database server. When DB2 components transfer from a development environment to Wednesday testings, assertion statements automatically change for addressing up to 99 virtual environments of testing on one physical DB2 server for each controlled ChangeMan ZMF application.
• Supports objects DB2: the stored procedures, triggers determined by the user of function (UDFs).