IBM DB2 - The Ultimate Database for Cloud, Analytics & Mobile
Learn how selected features of the new version DB2 12 will benefit especially your business critical SAP solutions.
As a result of close collaboration with SAP, DB2 12 for z/OS addresses new SAP workloads that combine transactional and analytical processing using SAP Core Data Services (CDS).
The performance acceleration is fundamental and is a result of large redesign of the DB2 query engine including a brand-new UDF cache. This also enables more complex SQL queries with up to 4x more table references. Also, transactional workloads are enhanced by further pushing the envelope of scalability with tables that can grow up to 4 PB in size and 1 TB table partitions. DB2 12 buffer pools can reach up to 16 TB and allow more efficient processing via new index fast traverse blocks (FTBs). For the SAP fast loader, DB2 12 introduces a new ultra-fast remote load capability from DB2 Connect based clients.
DB2 12 benefits from the Zero Downtime Option (ZDO) of SAP’s Software Update Manager with online DDL improvements. It advances the online migration process and enables stretched DB2 data sharing groups over longer physical distances.