Industry standards and Db2 for z/OS

Db2® 12 for z/OS® conforms to IBM and industry standards.

Distributed relational database architecture

See the following publications at https://publications.opengroup.org/standards/data-mgmt
  • Open Group Publications: DRDA V5 Vol. 1: Distributed Relational Database Architecture(DRDA)
  • Open Group Publications: DRDA V5 Vol. 2: Formatted Data Object Content Architecture(FD:OCA)
  • Open Group Publications: DRDA V5 Vol. 3: Distributed Data Management Architecture (DDM)

Character data representation architecture

Unicode standard

SQL standards

Start of change

Db2 for z/OS conforms to the following industry standards for SQL:

  • ISO/IEC FCD 9075-1:2016, Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework)
  • ISO/IEC FCD 9075-2:2016, Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
  • ISO/IEC FCD 9075-3:2016, Information technology - Database languages - SQL - Part 3: Call-Level Interface (SQL/CLI)
  • ISO/IEC FCD 9075-4:2016, Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
  • ISO/IEC FCD 9075-10:2016, Information technology - Database languages - SQL - Part 10: Object Language Bindings (SQL/OLB)
  • ISO/IEC FCD 9075-11:2016, Information technology - Database languages - SQL - Part 11: Information and Definition Schemas (SQL/Schemata)
  • ISO/IEC FCD 9075-13:2016, Information technology - Database languages - SQL - Part 13: Java Routines and Types (SQL/JRT)
  • ISO/IEC FCD 9075-14:2016, Information technology - Database languages - SQL - Part 14: XML-Related Specifications (SQL/XML)
End of change