Click4DB : a scalable suite of more than 100 solutions covering all database domains:
Administration
Comparison of intra/inter-environment definitions, installation verification plans, message tracking, structure documentation
Installation
List of parameters (complete or specific), inter-system comparison, checking internal standards
Statistics
Description of active classes, system trace levels, inter-environment comparisons
Applications tuning
Detailed access paths, access paths intra/inter-environment comparisons, potential performance issues, feature automation (e.g. Virtual Indexes)
Recovery
Compliance of backups strategy, objects potentially at risk, log tracking with modification simulation
Utilities
Comparison of inter-environment statistics, propagation of statistics, management of the Module Entry Point List (MEPL) utility: inter-system formalisation and comparison, RUNSTATS management
Data sharing
Tracking directory ratios and optimisation proposals, caching efficiency of Global Buffers, castout tracking
Security
Inventory of authorisations according to different types of criteria, intra/inter-environment privilege comparisons
System tuning
Predefined reports (with ratio calculation included) based on your monitor, feature automation (e.g. BP simulation), bufferpools tracking, caches
Due to its general technical architecture, Click4DB is also able to address non-database domains:
File tailoring
No more headaches using the complicated ISPF file tailoring
JCL generation
JCL generation: generate and optionally submit your JCLs in 1 Click
Dynamic text parsing
Benefit from our generic parser to transform any text in a usable relational format
SYSLOG eye watcher
Get the richness of the system log
Click4DB, a concept based on 3 classes of components : Collect, Transform & Build
Collects
data from any source and in any format. It very simply links actions to your database systems such as queries, commands or utilities
Transforms
data into information via structuring, comparison, formatting, calculation of derived areas, consolidation …: a large range of predefined functions facilitate data exploitation
Builds
an analytical report based on the best practices in the field, generates these reports in professional and exportable formats
Key features
Transversal approach
A cross-domains tool that addresses any DBA pain with ease.
Scripting into Scenario
In addition to the suite of more than 100 solutions, you can build your own scripted solutions so there is no limit to your requirements.
Useful History view
Every action and output is saved and available for later review.
Support for multiple subsystems
No limit to data comparisons within your configuration.
Team oriented
Ability to share components (DB2 SQL queries, commands, scenarios,…) and output reports.
Use of native or external browser
A cross-domains tool that addresses any DBA pain with ease.
Intuitive User Interface
A “Keep it simple” design so that you don’t have to search for what you need.
Easy and fast Deployment
No specific privilege required. Installed within a few minutes.
Advantages
- Solutions catalog is constantly enlarged
- Solution can be customized for specific needs
- Central repository : share executions and results among the team
- Resource optimization via recommendations
- Nothing to install on the mainframe
- No special rights required to install on the PC