Q
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.

This was last published in December 2002

Dig Deeper on IBM DB2 management

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close