DB2 for z/OS Database Support
Direct SQL Access to Valuable Mainframe Data
Employing the Progress DataDirect industry-standard ODBC, JDBC, and ADO.NET database drivers, DataDirect Shadow provides developers with direct SQL access to valuable DB2 for z/OS data. With Shadow, organizations leave mainframe data in place and avoid the cost of data replication or migration, ultimately relying on the mainframe as a true enterprise data server.
- Comprehensive support for DB2 for z/OS versions 9, 8 and 7 with full backwards compatibility
- Supports extended limits for names, columns, and tables; performance enhancements such as DYNAMIC SQL caching, and 64-bit virtual storage support
- Provides Web services access to mainframe business logic implemented as DB2 stored procedures
- Makes underlying mapping transparent to the developer who simply codes standard SQL calls
- At runtime, translates the standard SQL from the ODBC, JDBC and ADO.NET client driver into the appropriate calls for the underlying database
- Converts dynamic SQL to higher-performing static SQL when using ODBC driver, simplifying administration and improving performance up to 70%
- Diverts processing-intensive DB2 data mapping and transformation away from the mainframe's General Purpose Processor to IBM’s zIIP specialty engine
- Lowers MIPS capacity usage and reducing Total Cost of Ownership (TCO)
