Other database systems tout the ability to do tasks in parallel or to partition data for better performance. Can DB2 for i do that?
Yes. DB2 for i introduced parallel database functionality, also known as SMP (Symmetric Multi-Processing) capability in V3R1 (1995), and has enhanced those functions significantly since then. The DB2 for i SMP feature is an Operating System add-on that can significantly improve performance of database tasks by breaking the processing across multiple CPUs. By doing this, SMP optimizes the available resources to complete the database task in a cost-effective manner. In addition, DB2 for i, with the DB2 Multisystem feature, can also partition data across multiple servers/partitions, or partition data locally (within the same server/partition). One of the key benefits of this is to expand the size of a single database table/file, without application changes. However, it should be noted that other databases use the notion of “data partitioning” to address performance issues. Because these databases do not employ single-level store (single-level store is a fundamental design point of IBM i),
Related Questions
- Other database systems tout the ability to do tasks in parallel or to partition data for better performance. Can DB2 for i do that?
- Under what circumstances can the Cisco WAPMS database miss network performance data, and how can I prevent this from occurring?
- I heard that host-based database monitoring systems degrade performance – why is it that Hedgehog does not?