Border Patrol – Separates the Database from the program.
Performance – Consolidates open data paths which reduces the size of the PAG and the program
Security – By defining the table as 1. public exclude 2 owned by a profile (with no sign-on capabilities) you are providing a high level of security. The only access is threw the I/O server.
The compelling reason for using an I/O server is to manage data definition changes as in expanding fields or getting the data type right.
Improve performance: Because they run in the operating system storage pool.
Reduce Application Code: By attaching trigger programs to the file, the validation logic is consolidated into one place negating the need to do so in every application program that updates the file
Reduce Batch processing: After triggers are commonly used to replace End of Day, Month and Year processing which will keep your database up-to-date in real-time.
Step one is the un-learning old habits and being able to visualize what a modern application looks like
Define what a modern application looks like
