Db2 LUW Optimized for SAP Core Data Services
This document provides an overview and optimization tips for SAP Core Data Services (CDS) on IBM Db2 for Linux, UNIX, and Windows. It covers prerequisites, performance optimization techniques, and steps to create an SAP Fiori app with Db2 LUW, enhancing data processing efficiency and user experience. Download the Document11PUBLIC© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. ǀ
Db2 LUW Optimized for
SAP Core Data Services
SAP on IBM Db2 for Linux, UNIX, and Windows
Dirk Nakott (IBM), Thomas Rech (IBM), Jens Seifert (IBM)
March 2026
Db2 LUW Optimized for
SAP Core Data Services
SAP on IBM Db2 for Linux, UNIX, and Windows
Dirk Nakott (IBM), Thomas Rech (IBM), Jens Seifert (IBM)
March 2026
22PUBLIC© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. ǀ
Agenda
01 Prerequisites
02 What is ABAP Core Data Services (CDS)?
03 Tips for optimizing SAP CDS queries
04 Db2 LUW optimized for CDS
05 How to create an SAP FIORI app with Db2 LUW
Agenda
01 Prerequisites
02 What is ABAP Core Data Services (CDS)?
03 Tips for optimizing SAP CDS queries
04 Db2 LUW optimized for CDS
05 How to create an SAP FIORI app with Db2 LUW
33PUBLIC© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. ǀ
Prerequisites
Prerequisites
44PUBLIC© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. ǀ
Your minimum Db2 LUW level must be 11.1 Modification Pack 1 Fix Pack 1, but we highly
recommend that you run at least with one of the following Db2 versions:
• Db2 11.5 and the latest Fix Pack
• Db2 12.1 and the latest Fix Pack
Prerequisites
Your minimum Db2 LUW level must be 11.1 Modification Pack 1 Fix Pack 1, but we highly
recommend that you run at least with one of the following Db2 versions:
• Db2 11.5 and the latest Fix Pack
• Db2 12.1 and the latest Fix Pack
Prerequisites
55PUBLIC© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. ǀ
What is ABAP Core Data Services (CDS)?
What is ABAP Core Data Services (CDS)?
66PUBLIC© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. ǀ
Core Data Services provide a specification for an SQL-based DDL that is enriched with further
possibilities like annotations or associations.
You can either define sophisticated new views or simply wrap an existing table in a CDS view in
order to enrich it semantically.
CDS offers extended joining of tables with associations.
You can use annotations to connect existing tables with new technologies like OData, SAP UI5 and
SAP Fiori.
CDS offers functional extensions, e.g. views with parameters or an integrated client handling where
CLIENT, USER und LANGU will be automatically set as session variables.
ABAP CDS is available on all database platforms.
Overview: ABAP Core Data Services (CDS)
Core Data Services provide a specification for an SQL-based DDL that is enriched with further
possibilities like annotations or associations.
You can either define sophisticated new views or simply wrap an existing table in a CDS view in
order to enrich it semantically.
CDS offers extended joining of tables with associations.
You can use annotations to connect existing tables with new technologies like OData, SAP UI5 and
SAP Fiori.
CDS offers functional extensions, e.g. views with parameters or an integrated client handling where
CLIENT, USER und LANGU will be automatically set as session variables.
ABAP CDS is available on all database platforms.
Overview: ABAP Core Data Services (CDS)