Skip to main content

ESAi–Enterprise Systems Associates, Inc.

Offering solutions for:
Database, Performance,
ESAi has tools for database productivity, IT audit, test data management, and performance for mainframe and distributed systems.

Our mission is to help IT get the job done, maintain service-level agreements and realize operational savings. Qualified database and IT staff resources are in short supply. Workloads are increasing, yet there are still only 24 hours in a day. Our innovative solutions help you meet the challenge through automation as well as optimizing workloads, cost, machine and staff efforts.

Solutions include database access auditing, data security, test data management, data masking, fast cloning / refresh tools, Db2® bufferpool tuning, SQL performance, CICS® APM, cost-containment and more.

Solutions by ESAi–Enterprise Systems Associates, Inc.

BCV5 / XDM - Rapid Copy, Clone, Mask for Provisioning and Test Data Management

BCV5/XDM is a test data management, masking, and cloning tool for ultra-fast, automated data provisioning.   It supports Db2 z/OS, Db2 LUW, Oracle, SQL Server, PostgreSQL, IMS, VSAM, etc.  BCV5 and Masking Tool components provide speedy copy/migrate/refresh that are fully automated and take 1/10th of  manual efforts, CPU and runtime when compared to unload/load-based solutions or  Db2 cloning tools. BCV5/XDM enables DBAs, developers and testers to spend less time provisioning and running refreshes of target environments. Improve delivery and project timelines in today’s fast paced DevOps world. Make repeatable refresh of test environments simple and error free.

BPA4DB2 / SQLQC - Buffer Pool & SQL Performance Analysis & Alerts

BPA4DB2/SQLQC is a buffer pool advisor and SQL performance/tuning solution for Db2® z/OS®. It replaces old, dated vendor solutions with a new level of expert analysis.  It easily identifies, recommends and performs ongoing monitoring and alerting to ensure optimum performance and responsive Db2 systems. The SQLQC component easily identifies and analyzes problem SQL from mainframe or distributed systems, and offers actions for improvement, simulation and overall performance advice. Users rate BPA4DB2/SQLQC as the top bufferpool and SQL tuning solution in head-to-head competitions. It offers modern, powerful analysis with low overhead and low trace data volume.

DBARS – Audit, Alert, & Security for Db2 Data

In today’s distributed environments, protecting sensitive corporate data is of vital importance. While mainframe security software and Db2 privileges protect against unauthorized access to Db2 tables, they do little to comprehensively report all accesses to Db2 tables, and see what was read and changed within those tables.

DBARS uniquely solves this problem!  Its real-time database access monitoring and reporting technology has powerful audit, alert, and blocking capabilities without the overhead of Db2 audit tracing or log processing usually required. Thus, shops now have a more powerful, timely, and truly efficient way to audit and secure data from breach.