5.6. Instance and Database Design Considerations
Now that you are familiar with the concepts of instances and how to configure instances and databases, you may be wondering about design issues. Is it better to have one instance or multiple instances per server machine? Is it better to have one database or multiple databases per instance?
You may want to have multiple instances per server machine for the following reasons.
You want to separate your development and test environments but you cannot afford to have different servers.
For security reasons, you want to have different instances. As you will see in Chapter 10, Implementing Security, you can grant SYSADM authority to an operating system group by assigning the name of this group to the SYSADM_GROUP ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
