ITGAIN Speedgain now supports IBM BigInsights Big SQL for Hortonworks HDP

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

Single source – multi-platform: z/Linux deployment made simple

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.


You want to repeatedly play and compare your DB workload?

If test runs with the real workload be carried out?

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

  1. to find the optimal setup for a database infrastructure.
  2. perform a simulation of current and planned requirements.
  3. test and evaluation of alternatives under real conditions to achieve.
  4. to test assessment of cost database alternatives.
  5. minimize costs and risks.

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 and get a trial version.