Overview of the Components that makeup DB2 on the IBM i
DB2 comes with some very powerful features
Performance – RDBMS (Relational Database Management System) runs in the operating system storage pool. Therefore constraints and trigger programs become prioritized
Reduce Coding effort – RDBMS will enforce constraints negating the need to do so in the programs That mean’s not having to declare various master files in the programs used to verify data. That has a trickle-down effect on testing and maintenance.
Trigger Programs. Consolidate all the validation rules in one place. Do it once in a file trigger and you no longer have to do it in multiple programs. Once again there is a trickle-down effect on testing and maintenance.
I/O servers while not strictly part of RDBMS, complement the Relational Database by establishing a border between the application and the database