(Kevin Kline and Baya Pavliashvili) Transactions are an inherent part of any application that collects or manipulates data. SQL Server has to ensure the data integrity. This means that no two users should modify the same piece of data at the same time. Nor should they read “dirty” data—modified but
Other News
DB2 UDB V8.1 SQL Cookbook
(Graeme Birchall) This book originally began a series of notes for my own use. After a while, friends began to ask for copies, and enemies started to steal it, so I decided to tidy everything up and give it away. Over the years, new chapters have been added as DB2 has evolved, and I have found new w
DB2 stored procedures and dynamic cursors
(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce
TOracle Optimizer: Moving to and working with CBO
(Amar Kumar Padhi) In Oracle, a query may be executed in more than one way. The execution plan that has the best ranking or the lowest cost is the one that will return output with the fastest rate and optimal utilization of resources. The execution plan is generated by the Optimizer. Optimizer is an
DB2 Version 6 stored procedures migration issues, part 2
(Antonio L. Salcedo) IBM provides a mechanism to convert (migrate) the DB2 V5 stored procedures into DB2 V6 stored procedures. This mechanism is supported by the DB2 catalog maintenance utility, CATMAINT, which creates the new DB2 tablespaces and tables necessary to support the new DB2 objects (stor
DDL Generation–Oracle’s Answer to Save You Time and Money
(James Koopmann) The days of building your own DDL extraction utilities are almost gone. While Oracle has given us a simplistic approach to look at the DDL, it isn’t quite everything we would hope for.
Disaster recovery options for Microsoft SQL Server
This article discusses various solutions for recovering data from a Microsoft SQL Server database, if a disaster occurs. This article also discusses the advantages and the disadvantages of each solution. Disaster recovery is a process that you can use to help recover information systems and data,
Reviewing Web Architecture
(Kendall Grant Clark) In last week’s XML-Deviant ("The TAG’s Town Hall"), filed from the XML Conference 2003 in Philadelphia, I described the town hall meeting held by members of the W3C’s Technical Architecture Group (TAG). The chief purpose of the town hall was to announce that one of the TAG’s pr
15 minute guide to XML
Extensible Markup Language (XML) is a W3C Recommendation for how to represent information in a text-based document. To give you an analogy: if Java is portable code, then, XML is portable data. XML is extensible (as it does not have any fixed set of tags); it makes use of markup (angled brac
Troubleshooting Guide for DB2
Welcome to the world of DB2 troubleshooting. This guide provides information to get you started solving problems with DB2 servers and clients. It helps you to: –Identify problems or errors in a concise manner –Solve problems based on their symptoms –Learn about available diagnostic to