• 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
    • Application Development with Software Defined Mainframe
    • Accelerate Rewrite
    • Agile Test Environment
  • About
    • About Us
    • Partners
    • Executive Team
    • Work for LzLabs
    • Our Brand
  • 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

Related content

  • Find out more

    White Paper | The Anatomy of Mainframe Application Workload Migration

    What are the considerations, challenges and solutions available to organizations when migrating mainframe applications to modern platforms?...

    Find out more
  • Find out more

    White Paper | Why Source Code Dependency is a Challenge for Mainframe Workload Rehosting

    Mark Cresswell discusses how the traditional approach to mainframe re-hosting is fraught with issues that often render projects costly and unsuccessful...

    Find out more
  • Find out more

    White Paper | IDC Partner Spotlight: Elevating Applications to the 3rd Platform

    When migrating applications from the mainframe to another, considerations must be made for languages, runtimes and operational characteristics for success...

    Find out more

Footer

Company Links

  • About Us
  • Our Partners
  • Executive Team
  • Careers
  • Our Brand
  • 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
  • Application Development
  • Accelerate Rewrite
  • Agile Test Environment
  • Customer Support

LzLabs on Twitter

LzLabsFollow

LzLabs

Our customers must demonstrate the feasibility of major #modernization initiatives in order to gain support within their business. We're here to help them every step of the way. Check out the latest blog by our Head of Post-Sales, Norbert Furth.

https://t.co/NaPgyN1YjV

Reply on TwitterRetweet on Twitter1Like on Twitter3

Wondering whether your legacy systems could run with the same performance in the cloud? In our latest benchmark with Microsoft, we show that the cloud is a perfectly suitable environment for running your applications at scale. #mainframe #modernization https://t.co/r4wPOlyykk

Reply on TwitterRetweet on Twitter1Like on Twitter1

Contact Us

Richtiarkade 16
CH-8304 Wallisellen
Switzerland
+41 44 515 98 80
25 Templer Avenue
Farnborough
Hampshire
GU14 6FE
United Kingdom
+44 (0)1252 917232
330 Bay Street, Suite 820
Toronto,ON
M5H 2S8
Canada

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