Production versus Development Systems
Tuning is an iterative and often time-consuming process. It's also a major inconvenience to users of a production system. Many of the tuning changes you will be making will require a database shutdown and restart. Some may require reconfiguration of the operating system or a kernel relink on UNIX systems. Some of the changes may make the situation worse than before.
Your tuning strategy must first consider the environment in which you'll be working. I'm making an assumption that you've never seen the system before, that you're just walking in the front door for the first time. You can either tune on a development or a production system. There are tradeoffs for each one. If you're tuning on a development system, ...
Get Informix DBA Survival Guide, Second Edition 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.
