LzRelational™
LzRelational™ is a database implementation built upon standard PostgreSQL facilities and interfaces. The product leverages user-defined data types, functions, operators and SQL dialect conversion to enable PostgreSQL to behave the same way as Db2® for z/OS® at its interface
Compatible Database
Enables applications, developed to use data stored in Db2® for z/OS®, to be migrated to Linux on x86 without any source-code changes or recompilation. Data is stored in PostgreSQL using the same datatype formats as exist on the mainframe. Sorting, grouping, arithmetic operations and other database functions behave in a compatible manner
Static SQL
Modern databases are able to run transactional workloads without static SQL. Mainframe applications that exploit static SQL do not contain the SQL within the program; instead it is maintained within a database catalog. LzRelational enables these applications to run without any requirement to modify the application source-code, even though modern database do not need to support static SQL.
Optimized for Performance
LzRelational minimally extends PostgreSQL to ensure compatibility with applications originally written for Db2. Consequently it is able to take advantage of the many performance optimizations and tuning options available with PostgreSQL. PostgreSQL underpins many high-throughput Online Transactional Processing (OLTP) systems, providing users of LzRelational with an architecture capable of supporting such demanding OLTP workloads. Also, by using PostgreSQL in as conventional a way as possible, LzRelational ensures a modern workforce is able to manage this crucial resource.
SQL Explorer
SQL Explorer is a highly intuitive and interactive facility to navigate the relational schema, issue queries and process result sets. At a high-level it provides the same features as the SPUFI capability found on legacy mainframes, albeit in a fundamentally modern form. Queries can be created from table structures; saved for later use and results sets exported directly to the desktop for processing in spreadsheets and other formats. Interactive SQL syntax checking and highlighting makes the creation of queries a natural experience for modern IT professionals.
Specifications
-
DRDA
An integrated DRDA server enables existing client applications, built to use JDBC or ODBC, to access LzRelational data without changes.
-
Transactional support
Transaction management capabilities of PostgreSQL are used extensively to support traditional database transactions and recovery. PostgreSQL transactions are also used to coordinate message queues and several other recoverable resources within SDM.
-
Utility Support
Support for the most common use-cases of LISTDEF, CHECK, LOAD, REORG, REPAIR, UNLOAD (via DSNTIAUL).
-
Db2® SQL Dialect
Dynamic and static conversion of Db2® SQL dialect to PostgreSQL dialect.
-
Db2® Datatypes
Mainframe EBCDIC and Decimal datatypes, implemented using PostgreSQL user-defined datatypes.
-
Db2® Functions
Many mainframe SQL functions implemented using PostgreSQL user-defined functions. Arithmetic and messaging functions are included.
-
Stored Procedures
Both legacy and Java stored procedures are supported.
More Information
Go to our download portal for immediate access to our Product Data Sheets. Please note that Data Sheets are available for download in English language only at present.
Visit Download Portal
Related Products
LzBatch™
LzOnline™
LzHierarchical™
