UFD AG is a Swiss-based company specializing in data management solutions, particularly for IBM's DB2 for z/OS environments. Their flagship product, DB2SQL, is a user-friendly tool designed to execute dynamic SQL statements securely and efficiently. Originally developed for UBS AG, Switzerland's largest bank, DB2SQL addresses stringent security requirements for dynamic data retrieval and manipulation across extensive DB2 production tables in complex parallel sysplex data-sharing environments.
Key Features and Functionality:
- Dynamic SQL Execution: DB2SQL provides an intuitive interface for executing all types of SQL statements (DML, DDL, and DCL) in both foreground and batch modes.
- Security Integration: The tool leverages existing DB2 security features and processing rules, enhancing overall data integrity and availability.
- Comprehensive Audit Trail: DB2SQL offers efficient, centralized logging of all dynamic SQL statements processed within the DB2 for z/OS environment, facilitating thorough auditing and compliance.
- Flexible Operation Modes: Users can execute multiple SQL statements separated by semicolons, each processed in its own unit of work, with control statements available to manage checkpoint pacing during mass deletions or updates.
Primary Value and User Solutions:
DB2SQL addresses the critical need for secure, dynamic SQL processing in large-scale DB2 environments. By integrating seamlessly with existing security protocols and providing a robust audit trail, it ensures data integrity and compliance. The tool's flexibility and user-friendly interface make it an invaluable asset for application developers, database administrators, operations teams, technical support, and systems programmers, streamlining SQL execution and management processes.