DB2 Object Alteration

Altering and converting Db2 objects is an exhausting task. This can be even more difficult when modifying attributes that cannot be changed using a simple Db2 ALTER command. Backing up the object‘s data before dropping, recreating and reloading the data into the modified objects requires a uniform and accurate procedure. Care must be taken to backup and restore authorizations,  packages and auxiliary objects (triggers, views, synonyms, etc..). This process consumes too much time and resources to be feasible for many sites facing tight production windows.

TCONV fully automates the process of altering and converting Db2 objects. It generates the required DDL, backs up all related objects, drops them, recreates the objects and reloads the data into the new environment. Simply use the integrated ISPF interface to identify the objects to be converted. TCONV generates the job stream required to accomplish the task. The process has been optimized to convert the objects with minimum resources and downtime.

How TCONV Reduces Usage of System Resources
An expert system engine drives the optimization process. TCONV evaluates which of the many possible conversion solutions fits the attributes of the Db2 objects best. Some modifications require a complete drop and redefine while others only need a REORG. Some changes simply use the integrated conversion facility of TCONV. The complete decision process yields an optimized solution that guarantees the cheapest, fastest and most efficient solution which customers can easily benchmark.


The Automated Conversion Process
TCONV generates a job chain that includes all of the required utility invocations, the DDL generation, the alters and the necessary steps. Staff is freed from having to search for the conversion information. The DDLs with the altered attributes are product generated. All tasks are managed by TCONV to produce the desired results.

Converting to a Db2 Universal Tablespace
Each new Db2 version introduces enhancements and improvements. To take advantage of the performance improvements it is often necessary to consider modifying the current data model. The internal structure of a tablespace impacts the performance of applications. The Db2 version 9 universal tablespace improves   performance and makes maintenance easier. This type of tablespace benefits from all the new improvements and simplifies dealing with legacy issues. The CPU and resource consumption of the Db2 system is reduced through enhanced data processing. TCONV converts and migrates the tablespaces. Even simple tablespaces that have been created with previous Db2 versions can be directly converted to segmented or universal tablespaces.

ISPF and Batch Interface
TCONV uses an integrated ISPF interface to make setting up conversions easy. Enter information on a couple of panels and TCONV generates the solution job stream. An alternate interface allows defining a batch conversion task using a regular JCL job.

Maintaining Referential Integrity
Data models are not always simple. Many mainstream data structures have hundreds of connected tables that are cross linked by referential constraints. This complicates the conversion process because modifying a single tablespace may influence the availability of many others. Dropping and recreating a  tablespace will cause referential dependencies to be lost. TCONV ensures that after the conversion all referential dependencies will remain intact.

Reduced Object Downtime
Users depend on data availability to get their jobs done. SLA‘s generally make this an enterprise recognized priority. TCONV customer benchmarks attest to the benefits this product delivers in the trenches. [/slider]