• Skip to content
  • Skip to footer

LzLabs

LzLabs Software Defined Mainframe

  • LzLabs Software Defined Mainframe®
    • LzBatch™
    • LzOnline™
    • LzRelational™
    • LzHierarchical™
    • LzWorkbench™
  • Services
    • LzDiscover™
    • LzEnable™
  • Use Cases
    • Legacy Workload Rehosting
    • Mainframe Modernization
  • About
    • About Us
    • Partners
    • Executive Team
    • Work for LzLabs
  • Media
    • News & Content
      • Press Releases
      • Reports
      • Blog
      • In the News
    • Videos
    • Webinars
  • Customer Support
  • Contact Us

LzRelational™ Product

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

Compatible Database image
Static SQL image

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.

Optimized for Performance image
SQL Explorer image

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
More Information

Related Products

LzBatch™ logo
LzBatch™ provides a batch job submission environment enabling existing JCL to drive job suites without changes, including support for spooled output, job scheduling and many commonly used batch utilities
Read more
LzOnline™ logo
LzOnline™ is a unified environment for rehosting CICS® and IMS™ TM applications, without source-code changes or recompilation, on x86 architecture computers running the Linux operating system
Read more
LzHierarchical™ logo
LzHierarchical™ is an implementation of a hierarchical database, based on PostgreSQL. It enables legacy applications, originally written to access IMS™ DB using the DL/1 access language, to work without source-code changes or recompilation on Linux. LzHierarchical enables PostgreSQL-skilled IT professionals to manage an organization's critical data, hitherto locked away in an impenetrable legacy database
Read more
LzWorkbench™ logo
LzWorkbench™ is an integrated set of tools , accessible from within Eclipse, to enable selective and graceful maintenance and modernization of legacy applications
Read more

Footer

Company Links

  • About Us
  • Our Partners
  • Executive Team
  • Careers
  • Media
  • Press Releases
  • Resources
  • Blog
  • In The News
  • Videos

Product Links

  • LzLabs Software Defined Mainframe®
  • LzBatch
  • LzOnline
  • LzRelational
  • LzHierarchical
  • LzWorkbench
  • Services
  • LzDiscover
  • LzEnable
  • Use Cases
  • Legacy Workload Rehosting
  • Mainframe Modernization
  • Customer Support

LzLabs on Twitter

LzLabsFollow

LzLabs

“What is possible with digital transformation if your perspective is rooted not only in legacy systems, but also legacy ideals of what technology can do for the organization?” – @briansolis provides his insight on business transformation in @TechRepublic: https://t.co/KRXbgBsA77

Reply on TwitterRetweet on TwitterLike on Twitter

Are you considering modernizing your legacy #mainframe environment? LzLabs CEO Mark Cresswell discusses the pros and cons of three strategies to take: https://t.co/pYAd4ffY7t #DX

Reply on TwitterRetweet on TwitterLike on Twitter

Contact Us

Richtiarkade 16
CH-8304 Wallisellen
Switzerland
+41 44 515 98 80
Duke St., 7th Floor, Block C
Duke's Court Building
Woking
GU21 5BH
United Kingdom
+44 (0)1483 319193

info@lzlabs.com
Contact Us
LzLabs on Twitter
LzLabs on LinkedIn

LzLabs Logo

© Copyright 2019 LzLabs • Zurich, Switzerland • All rights reserved.
LzLabs®, the LzLabs® logo, LzLabs Software Defined Mainframe®, LzOnline™, LzBatch™, LzRelational™ and LzHierarchical™ are trademarks or registered trademarks of LzLabs GmbH. z/OS®, RACF®, CICS®, IMS™, Db2® and z/Architecture® are registered trademarks of International Business Machines Corporation. All other product or company names mentioned in this publication are trademarks, service marks, registered trademarks, or registered service marks of their respective owners

Privacy Policy | Terms of Use | Open Source | Impressum

This website uses cookies, including third-party cookies, in order to obtain information about your visit to this website and to make the site better. You can click below to obtain more information about the cookies used on this website and how to change your cookie settings, if you don’t we will assume that you're okay to continue. Please, click here for more info