What is DB2CPI

Features

Benefits

Case studies

Evaluation

 
user
password

Welcome
31/07/2010

Welcome to the DB2 Command Processor Interface web site. Thank you for your interest in our product.

DB2CPI is an ISPF based DB2 Command processor interface with integrated catalog management facilities and many automated functions and utilities that make daily DBA tasks easier.

DB2CPI was developed by DBAs to provide simple solutions to time consuming tasks and provide rapid information required for problem determination in an easy to interpret format.

We invite you to register and download DB2CPI today.

Announcements

01/05/2009 - What people are saying about DB2CPI:
Udo Reffke - Deutche Bank/Frankfurt/Germany

I have worked with DB2CPI since the second half of 2008.
I quickly realised it is really useful for both DB2 admin and DB2 sysprog people.
You can see that it was created by DB2 specialists for daily DB2 work and in my job it has become an indispensable tool.
The design and flexibility of DB2CPI could not be better, the handling in terms of DB2 dependencies is outstanding.
It's implementation of monitoring components as well as DPropR functionality has no other equal.
it is designed for the classic world with static SQL and also for the "new" world with dynamic SQL.
The installation is very quick and easy as are upgrades.
In conclusion: A highly recommended piece of software that no DB2 specialist should be without for their daily challenges.
 
01/04/2009 - V11 Released
DB2CPI Released May 2009.

New Table Editor, Easily Update and Delete records shown in a pivoted format. Insert new records modelled on existing records.

CPIDDL now has more flexibility.Choose to exclude Databases, Tablespace, Tables and/or Indexes. This allows you to reverse engineer specific objects dependent on Database, Tablespace or Table sets. For example reverse engineer all indexes for listed tables.
CPIDDL can now reverse engineer views directly as well as part of the hierarchical DDL that is part of Table definitions. This speeds up View Generation when just views are required.
You can now provide input lists that contain tables and views.
If the input list contains a view as well as a table that the view is dependent on, only 1 view is generated.
The simplest way to reverse engineer sets of views is to ensure that the required set is in the object list in Catalog Management Mode using object type VW.
These changes improves flexibility and time when reverse engineering DDL.


Support for User Defined Functions.

CPITMP is a background thread monitor program that can continually monitor and
check for long running threads. CPITMP will also optionally cancel threads if they conform to
certain parameters provided by the user.

CPIRECAL is an automated recall utility for migrated DB2 datasets.

Catalog management ‘Enhanced’ queries.
Catalog Management queries can now be enhanced manually and in query form for searches on individual object types.

DB2 9 Compatibility.

Fixes for any known issues.