(Craig Mullins) I have a batch process that updates my DB2 tables and issues commit at a certain interval within the program. If I ran the process concurrently, with say five jobs, and one of them abends, will the rollback affect my other four jobs (R)
Other News
Adobe’s InDesign and XML
(David Miller) The process of formatting and typesetting documents has come a long way in the relatively short span of time that modern computers have been around; the process has typically revolved around formatting scientific or technical documents using a variety of command-line tools. However, t
Snapshot Isolation Adds Flexibility in SQL Server 2005
(Ron Talmage) SQL Server uses isolation levels to govern the tradeoff between consistency of transactions and concurrency of multiple users. As you raise a transaction’s isolation level, you also increase the chances that a transaction’s reads may block and deadlock with other transactions. Even
Generate SQL Automatically Without Compromising Quality
(Alan Fisher) Most database developers dread including such navigation features as paginated reports, hierarchical navigation, filtering, and full-text search because the amount of time they take to develop is not proportional to the utility or interest they create. In addition, connecting individua
DB2 for z/OS Stored Procedures: Through the CALL and Beyond
(Paolo Bruni) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered an ever improving support for developing and
Test to Production
(Don Schlichting) Many times, new database applications are written and developed on test machines. Once completed, these new databases must somehow be moved or transferred to a production server. Moreover, while there are currently no Microsoft tools to handle SQL database source control automatica
From English to Dutch?
(John E. Simpson) I need to translate text in an XML document from English to Dutch. The XML document in question is used as a language file in vBulletin forum software. The problem is that I have to get the text to be translated out of the XML code and, after translation, back into the code in the
Log Shipping vs. Replication
(Paul Ibison) Many previous articles on log-shipping and replication have concentrated on solving set-up and configuration issues. This article outlines the differences between them, for the purposes of maintaining a standby server. To put this in context,log-shipping and replication are two met
Set up a Microsoft SQL Server cluster
(Mark Strawmeyer) Clustering is a technology solution that combines hardware and software to provide high availability and scalability to infrastructure items such as Web, e-mail, and database servers. In this article, we’ll examine the types of clusters and then focus on establishing a Microsoft-ba
The DB2 UDB memory model
(Sylvia Qi and Michael Dang) Understanding how DB2 uses memory prevents you from over-allocating memory, and helps you tune memory use for better performance. This article teaches you the basics of DB2 memory usage and the concepts of shared memory and private memory. These apply to both 32-bit a