Wednesday, March 10, 2010
 

Headquarters
Kilcolta House
Crosshaven
Co. Cork
Ireland

Tel. +353 21 4832131
Email.
sales@fitzsoftware.com

For local UK access:
Tel. +44 20 73320222

Technical Support:
Tel. +353 21 4832131
Email.
support@fitzsoftware.com

Database Productivity (DB2, IMS)

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 (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!

DATA Converter - 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.

D-SECT - 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.

Privacy StatementTerms Of UseCopyright 2009 by Fitz Software