In the report “IBM’s DB2: Database for Enterprises’ Masses” dated October 4, 2005, analyst Jonathan Eunice at Illuminata shows why DB2 stands alone for enterprises’ data coordination, integration and analytic requirements. (pdf)
Other News
Stored procedure: Examining SQL Agent job run history
(Brian Walker) This tip continues the system stored procedure series with a routine to list run history for selected SQL Agent jobs. (R)
Controlling Transactions and Locks Part 5: SQL 2005 Snapshots
(Don Schlichting) This article will explore the new Row Versioning feature in SQL 2005, and the two new transaction isolation levels that take advantage of it: Read Committed Snapshot and Snapshot Isolation.
MySQL Query
So far we have seen a couple different forms of queries. This is to be expected as nearly all MySQL in PHP is done through the MySQL Query function. We have created a new table and inserted data into that table. In this lesson we will cover the most commonly used MySQL Query that you must be sure to
Migrating Recursive SQL from Oracle to DB2 UDB
(Torsten Steinbach) Recursive SQL is a powerful means to query hierarchies of data. Organizational structures (department, sub-departments, sub-sub-departments and so on), discussion forums (posting, response, response to response etc.), bills-of-material, product classifications and document hierar
Achieving Breakthrough DB2 UDB Performance with Speedgain for DB2
(Philip K. Gunning) Monitoring database performance is critical for companies to succeed in today’s demanding 24 x 7 On-Demand economy. There is little or no allowance for business slowdowns or outages due to poor performing or unavailable DB2 UDB databases. The number of experienced DBAs available
Edit and Continue in ASP.NET
(srirambalaji) If you are into developing large Web applications, the following situations may sound familiar: –Build the VS.NET solution. That will take a long time to build. –You start debugging your application. You realize you made a small mistake.
Making a field disabled depending on the value in another field
(Grant Ronald) I’ve been having a bit of a test drive of the latest build of JDeveloper and one of things that I wanted to try out was the ability to make a field disabled depending on the value of another field.
Servlets and XML: Made for Each Other
(Doug Tidwell) To get things started, we’ll write a 10-line servlet that generates an XML document. As we build our XML-aware servlets, we’ll follow three steps: –Set the content type to text/xml. –Create the XML document. –Write the XML document back to the client.
The Java XML Digital Signature API Spec (JSR 105)
(Ed Tittel) Those who’ve been reading my XML tips for any length of time, especially recently, will know that I just finished up a marathon 9-part collection of same on the subject of XSLT. After a brief hiatus, I’m now playing catch-up for all the cool XML specifications, tools and technologies I d