What´s new on Version 5? – Highlights – New Features
- SQL Workload Set Analysis
- Plan Access Monitoring by Runtime Explain
- Change Log
More information see here: ITGAIN Speedgain V5.0 Whats New
Our experiences with Big SQL, both on IBM Open Plattform and Hortonworks HDP show that Big SQL is ideally suited for integration in SQL-based applications in the new Big Data World.
Two critical advantages stood out from the results of our extensive testing:
A) Compatibility with ANSI SQL is complete
B) Highly complex SQL queries ran with significantly faster execution times
With the general availability of IBM Big SQL on Hortonworks Data Platform (HDP) in addition to IOP, the adoption and use of Big SQL will explode.
Since its inception, ITGAIN has specialized in fully realizing the potential of systems for the efficient storage and evaluation of data using advanced and fully integrated performance monitoring solutions.
Today we are announcing the general availability of Speedgain for Big SQL for Hortonworks HDP, a key product in the Speedgain Monitoring family. We have leveraged our extensive experience in monitoring cluster systems to build a powerful, yet easy to use, tool to measure and evaluate the performance of the individual data nodes (worker nodes) and the workload distribution among them.
For more infomation about ITGAIN Speedgain for Big SQL see
Hot link to IBM’s Big SQL offering see
Easy approval and compilation of Legacy modules using z/Linux
The transfer of transactions and batch sequences from mainframe to z/Linux in order to reduce the workload is being considered more and more frequently (see also “Solve with z/Linux the challenges of digitization“).
A requirement for this is the compilation of Legacy modules (such as PL/I and COBOL) on the z/Linux platform. For easy entry and when transferring individual transactions or batches, the existing development environment and processes do not necessarily have to be changed. Rather, the existing deployment processes can simply be extended and the z/Linux platform attached as a new destination.
The processes behind it (source transfer, source code modifications if applicable, compilation, evaluation and return of the compilation notifications) are automated and remain transparent for application development. The administration of the source code therefore remains central and thereby follows the “single source – multi-platform” approach.
ITGAIN provides manufacturer-independent advice on selecting the right compiler for z/Linux and applies its experience in the creation of automated sequences that enable trouble-free compilation and execution of Legacy modules via z/Linux.
From the idea to a product – the origin lay in the requirement to conduct a review of lower-cost database alternatives.
Before investing in a new infrastructure (servers, network, storage, cloud services, …) often synthetic performance and load tests are performed. The SQLReplayer allows tests based on the actual workload. The aim is to take a look at the future infrastructure under real conditions and hedge eventually investing.
The new ITGAIN SQLReplayer can perform recording and reproduction of workloads to
Workloads can be played on all relational databases that support JDBC driver. In addition, recorded workloads of different databases can be played. Thus, it can e.g. answer the question, how behave a specific statement in another database configuration.
Save time and money – when carrying out the test and reviews of future workloads. There are no complicated test necessary.
Stable and secure – the results are based on the actual workload. It can be stimulating situations and future load.
Applying the recorded SQL workloads to another database and infrastructure also enables the evaluation of a change effort.
More information can be found at http://www.itgain-is.de/en/performance-monitoring/sql-replayer/ and get a trial version.
In many companies the digital transformation of business processes towards customers, has very concrete impact on the mainframe workload. If customers of banks and insurance companies use mobile apps to gather information or to apply for insurances, there are still “traditional” IMS or CICS transactions working in the background. And the number of executed transactions is not only increasing by the digitization of business processes, more and more there is a demand on 24/7 availability by this new target group.