Solution : https://service.sap.com/sap/support/notes/1555903 (SAP Service marketplace login required)
Summary :
This SAP Note provides detailed support and usage information regarding IBM DB2 features specifically optimized for SAP Application Server ABAP and Java. It outlines the various DB2 features that are supported within the DB2 license provided by SAP, including DB2_WORKLOAD=SAP, Multidimensional Clustering (MDC), Range Partitioning, and others detailed in the note. Features that are not supported include non-root installation and DB2_COMPATIBILITY_VECTOR=ORA. Users of IBM-purchased DB2 might require individual licenses for certain features. For uncertain or unsupported features, SAP recommends opening a customer message.
Key words :
multi-core processing / intra-partition parallelism workload management statement-level optimization guidelines cli driver, multi-core processing / intra-partition parallelismintra-partition parallelism, /instguides --> <sap netweaver main release> --> operations --> database-specific guidesthe, multi-temperature storageautomatic storage simplifies storage management compared, enabling intra-partition parallelism requires additional resources, committed semantics feature reduces lock wait situations, -tuning memory manager greatly simplifies memory configuration, /usr/sap/<sapsid>/sys/global/db6if, -root installation optimization profiles db2_compatibility_vector=ora sms tablespaces, terms db6 db2 luw udb reason
Related Notes :
| 1746101 | DB6: High Availability with SAP on DB2 using SA MP |
| 1700631 | DB6: Using DB2 10.1 with SAP Applications |
| 1686102 | DB6: DB6 Partitioning Administrator |
| 1678159 | DB6: Role-Based Security Concept |
| 1612105 | DB6: FAQ for DB2 High Availability Disaster Recovery (HADR) |
| 1568539 | DB6: HADR - Virtual IP or Automatic Client Reroute |
| 1530812 | DB6: Graceful Maintenance Tool |
| 1514016 | DB6: DB2 LUW isolation levels used by AS ABAP |
| 1513862 | DB6: Table conversion using DB6CONV Version 5.01 or higher |
| 1481572 | DB6: New defaults for the usage of MDC and compression |
| 1443426 | DB6: Graceful Cluster Switch |
| 1379362 | DB6: Support for partitioned tables in the ABAP DDIC |
| 1351160 | DB6: Using DB2 9.7 with SAP Software |
| 1274277 | DB6: Improve Query Performance with Statistical Views |
| 1260217 | DB6: Software components contained in DB2 license from SAP |
| 1132282 | DB6: Use of Self Tuning Memory Manager (STMM) for SAP NW BW |
| 1091801 | DB6: Conversion of client connectivity |
| 1089578 | DB6: Using DB2 Version 9.5 with SAP Software |
| 975352 | DB6: Using DB2 9 automatic REORG |
| 942909 | DB6: Multi-Dimensional Clustering for SAP BW 3.x |
| 930487 | DB6: Using DB2 V9.1 with SAP Software |
| 913481 | DB6: Archiving log files with DB2 log file management |
| 886231 | DB6: ACTIVATE VALUE COMPRESSION |
| 868888 | DB6: Optimization Guidelines |
| 780546 | DB6: Use of new functions in DB2 V8.2 |
| 702175 | DB6: Supporting several DB partitions with DB2 |
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |
| 29824 | DB6: Mapping of data types (DDIC -> DB) |