What is DB2CPI

Features

Benefits

Case studies

Evaluation

 
user
password

Welcome
05/07/2008

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

19/05/2008 -***V10 Released***
Additional ZCPIPARM parameters: LPAR
Allows you to specify what LPAR a DB2 SubSystem resides on.

DB2CPI can now be invoked from multiple LPARs in a syplex at the same time.

More features and support for monitoring and tuning Dynamic SQL.
DB2CPI Version 10 introduces Dynamic Statement Cache Management.
DBAs now have the ability to quickly and easily monitor the Dynamic Statement Cache.
SQL statements can be organised to show high consumers and problematic queries quickly.
The statements can then be edited or explained with the ability of generating OPTHINTs as well.
In addition, the Dynamic Statement Cache can also be easily flushed for subsets of Tables.

Online Updates of DB2 Catalog Statistics.

Migration of RTS (Real Time Statistics) using CPISTATS.

Utilities now support in-stream SYSIN statements: SYSIN DD *