Problem solve Get help with specific problems with your technologies, process and projects.

How to prevent contention issues with batch and online programs with 24x7 availibility

If a system is being developed with 24/7 accessibility and has both batch and online programs that browse and update, how do you prevent contention issues?

The locking mechanism built into DB2 will prevent integrity problems due to contention. Of course, that does not mean that you can simply implement anything and everything without worrying about performance and availability. This is a very general question that could require a lot of space and effort to answer completely and in-depth. In general, though, you want to avoid long-running batch updates in conjunction with heavy online activity. The long-running batch work would tend to lock out the OLTP work.

Dig Deeper on IBM DB2 management