Skip to main content

Enterprise Systems Associates (ESAi)

Offering solutions for:
Application development, Database, Performance, Tools and utilities,
Enterprise Systems Associates (ESAi) has tools for database productivity, IT audits, 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 Enterprise Systems Associates (ESAi)

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 database administrators, 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 and 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 and 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 efficient way to audit and secure data from breach.