BCV4
BCV5
BCV6
For more information about us and our offerings goto our Home index page BCV4 - BCV4 provides for fast copying of DB2 and IMS systems. Modern storage subsystems support mirroring of disk data where primarily you have the ability to separate and reconnect the mirror copy very quickly with your server (BCVs). However in the z/OS world such volumes are normally used only as backups. Duplicate VVDS names, duplicate VTOC index names and hundreds or thousands of duplicate dataset names prevent the immediate use of these target volumes. BCV4 offers the functionality to rename these volumes quickly and systematically. After processing through BCV4 the target volumes may be used by standard z/OS access methods. BCV4 offers complete "make usable" functionality after the creation of the mirrored environment, where all necessary work is carried out in a single job. BCV4 further offers the capability of adjusting DB2 system entries and internal catalog structures (catalog/index, Bootstrap, Logcopy, Logs, table spaces, ..) creating a "new" DB2 system on the mirror image. 
BCV5
- Provides
for fast copying of DB2
databases or tables within the same or
to another DB2 system.
Compared with other conventional copying methods, BCV5 saves
about 90% on elapsed copy time and over 90% on used resources (SSU, SRU).
BCV5 copies DB2 data, i.e. databases or tables, with or without auxiliary
objects - indexes, views, triggers, procs, runstats. The same is true for
copying between different DB2 subsystems – referred to commonly as migration
– where BCV5 automatically attends to OBID translation and RBA adaptation.
With BCV5, copy jobs are completed in minutes where before they took hours.
Weekend work can be executed within regular night shifts. Test data may be
refreshed any time.
BCV6 -
All the
functionality of BCV5 to do fast copies of DB2 data (databases and tables)
but with BCV6 the suspension of live databases in the copying process is no
longer necessary, i.e. no Quiesce or Shutdown required. The target
tablespaces are updated accordingly via the source DB2 log to a selected
point in time.
TUC – Total Utility Control for DB2
z/OS
-
TUC
is an advanced solution to
automate your database maintenance providing availability around the clock.
TUC provides features and services that allow you to create your set
of maintenance procedures
and define the rules needed to follow your maintenance policy. Real Time
Statistics are monitored and compared to predefined thresholds to trigger
utility execution and provide near real-time utility maintenance on an as
needed basis. TUC saves resources and minimizes costs by assuring
that only the utilities that really need to be done are triggered for
execution.
DB/IQ-QA - Automated Quality Assurance for DB2 SQL. Detects reliability or performance problems before they occur resulting in major savings in machine, programmer, DBA and user resources & cost. Validate static & dynamic SQL in ERP, purchased or in-house applications. Evaluate existing SQL against new standards. Check & track code quality over time by application, development team or site. Estimate future performance using data volumes that anticipate growth and execution frequency values predicting future usage.
Additional overview on DB/IQ
products -
DB/IQ-WL+
- Add-on to QA - The "Workload Detector" is based on QA's
SQL Monitor trace facility. WL+ will analyse the extracted trace data and present
results/reports to identify the most "costly" plans, packages and SQL
statements, taking the execution frequency into account. WL+ provides multi-dimensional
views of the workload by plan, package, table & SQL giving all information required by
developers/DBAs to improve application performance.
DB/IQ-IA+
- Add-on to QA - The "Index Administrator" analyses and
ensures optimal indexes. It's composed of a Repository database and facilities to perform
index analysis, index advice, index design and index impact analysis. The Repository
includes a unique cross reference facility between plans, programs, tables, views, indexes
and columns - originating from both static & dynamic SQL. It is able to drill down
column usage as far as indicating when used as a predicate or in sargable or indexable
functions - information not available in the DB2 Catalog. Future workloads can be
predicted with execution frequency values for SQL statements and for plans and packages.
Reports include cost and workload-based evaluations, impact on applications affected, TS
scans, internal sorts performed, non-used indexes ... and more.
DB/IQ-MA+
- Add-on to QA - The "Migration Aid and other Utilities"
is a selection of tools to re-engineer DDL, automatically generate threshold-driven REORG
jobs, maintain package versioning (FREE non-required versions) and more... MA+ provides
the essential information required by application developers and DBAs to improve database
administration.
BPA4DB2
- DB2 Bufferpool Analysis - Helps reduce the number of IOs in your
DB2 subsystems through measurement and analysis of the Bufferpools, Getpage and IO rates.
Presents the processed traced data on a GUI front-end offering multiple reports and
recommendations on your Bufferpools.
Batch Analyzer
- Identifies the most frequently executed and expensive SQL statements and
time-consuming contention problems hiding within the hundreds of DB2 batch
programs that run each night. Conventional DB2 monitors, with their enormous
overhead, means tuning efforts arise only on known problems - Batch Analyzer
however can be run across all systems with minimal impact. It collects
performance statistics for batch DB2 job streams and then provides you with
the actual SQL statements that cost you most in CPU utilization and elapsed
batch times. Batch Analyzer performance reports are presented in a simple
format allowing Application Developers as well as DBAs to locate their own
problems.
Checkpoint/Restart
- Allows you quickly insert COMMITs and CHECKPOINTs into your DB2
batch jobstreams - in some instances without editing These COMMITs will
often speed up DB2 batch programs and free up DB2 resources. It allows you
to quickly restart any abended production job from the point of failure,
re-establishing all positioning and resources within the problem program
including Cobol working storage and QSAM & VSAM file access.
CheckpontRestart also provides a powerful Variable COMMIT Frequency Option
that enables you to dynamically tune DB2 batch jobs by changing COMMIT
frequency as they run. All this means dramatically speeding up DB2 batch
jobs!
DDI (DDI - Dynamic Data Interface / DataSwitch) is the intelligent middleware for Euro and other major conversions or application upgrades requiring online & batch data changes, which also permits access by MQ-SERIES. Without further changes to programs, DDI allows the converted program through a simple JCL change to access the program files of pre and post conversion, i.e. different file lengths and data descriptions of archived, current, and future file formats. This allows the converted programs of the new world to continue to communicate with the data of the old world (and visa versa). It also allows you to take files (including those with multiple record types) and expand them into new pre-defined formats, inserting new data as required, also permitting data exchange such as Date Ageing.
HOTCOPY - Modern data processing environments like data warehouses, mobile computing, internet-commerce, data migration and high-availability all require an adequate mechanism when being synchronized. In this day and age the time is not simply available for a replication batch window and to transfer large data by ftp into remote databases. This is no longer considered to be efficient because in such a way data are provided neither timely nor consistent. Companies will continue to need an opportunity to propagate data changes from legacy systems like IMS, CICS and VSAM to databases on OS/390, OS/400, Unix, and NT. This needs to be done immediately, fast, without restrictions in the use of the central systems and not endangering data integrity. this is achieved with HOTCOPY.
ACM - Avoid Currency Mix. The final preparations are going ahead for the introduction of the EURO. This will induce the conversion of the local currency to EURO data and programs. Then, both data and programs from both currencies will be present. However, this gives rise to the danger that the "wrong" programs access the "wrong" data. ACM is needed! These convertors using DDI technology automate the rules process for source to target state using pre-existing file/table definitions, and enhance ordinary utilities like IEBGENER, REPRO and Unload/Reload to tranform them to data conversion tools. - Enables a programmer to generate consistently chained test data using SQL, even for non-relational datasets. Test data generator for integrated systems capturing your programs calls dynamically to DB2, IMS, VSAM & PS data structures.
|