JCL

Lists supported and tested databases that can be used with the JCL DSNREXX and Mainframe Batch Data Tools features of Enterprise Developer.

DSNREXX

Availability - Windows platforms
Feature/Platform 32-bit 64-bit
x86-64 running Windows Check mark Check mark
Availability - UNIX platforms
Feature/Platform 32-bit 64-bit
x86-64 running Red Hat Linux Check mark Check mark
x86-64 running SUSE Linux Check mark Check mark
IBM System p running AIX Check mark Check mark
OpenESQL
DSNREXX is supported in OpenESQL applications, and is native code using ODBC. See the OpenESQL section in the Database Management Systems (DBMSs) topic for additional software requirements, and the DSNREXX Support topics for complete details.
Testing
On Windows platforms, this release of DSNREXX was tested with:
  • DB2 LUW 10.5 and later
  • SQL Server 2014 and later

On UNIX platforms, this release of DSNREXX was tested with DB2 LUW 10.5.

Mainframe Batch Database Tools (MBDT)

Availability - Windows platforms
Feature/Platform 32-bit 64-bit
x86-64 running Windows Check mark Check mark
Availability - UNIX platforms
Feature/Platform 32-bit 64-bit
x86-64 running Red Hat Linux Check mark Check mark
x86-64 running SUSE Linux Check mark Check mark
IBM System p running AIX Check mark Check mark
OpenESQL
The MBDT toolset consists of OpenESQL applications, and are native code using ODBC. See the OpenESQL section in the Database Management Systems (DBMSs) topic for further details.
Testing
For this version, MBDT was tested with:
  • DB2 LUW 11.1 and 11.5
  • Oracle 19c and 21c
  • On Windows platforms - SQL Server 2016 and later
  • On UNIX platforms - SQL Server 2017 and later
  • GDG and EDB PostgreSQL 12.x, 13.x, and 14.x
  • Amazon RDS and AWS Aurora for PostgreSQL 12.x, 13.x, and 14.x