(Bill Wilkins) Improving the performance of database inserts is very important to managing a database, especially in an OLTP environment. This article explains exactly what happens when an insert occurs, looks at alternatives, and examines issues that affect insert performance, such as locking, inde

(Timothy Prickett Morgan) Contrary to his name, Jim Stallings, the general manager of IBM’s System z mainframe business line (formerly known as the zSeries) who was put into that position last week, wasted no time in getting out there and banging the drum for the mainframe and launching a new produc

(Jason Dere) DB2 Cube Views is an add-on feature of DB2 Universal Database (DB2 UDB) that provides OLAP awareness to DB2 UDB. A data warehouse will normally be presented as a set of tables, which requires an end user to have knowledge of what tables and columns are relevant and how to join the table

(Emilio F Zegarra) The Apache Geronimo project has successfully built an open source, J2EE-compliant application server. What makes this application server particularly powerful and reliable is the reuse of existing open source projects as part of its implementation. In a sense, the Apache Geron

Join us on Thursday, February 9, 2006 at 11:00 am ET/US for a technical introduction to the low cost, high value DB2 Express database server and why it’s an excellent option for developers, mid-market businesses, and partners. You’ll learn just how easy it is to install DB2 Express, the robust a

(Willie Favero) The number one DB2 Version 7 question I have been receiving lately is “When will DB2 V7 go out of service”. Up until now, I have been talking around the answer. However, on Monday (January 23, 2006), IBM finally gave a hint as to when V7 might actually go out of service.

(Craig Morris) Since 2003, the inexpensive Express version of IBM’s DB2 database has been available for free as DB2 Express-C since the end of January. The software giant claims that its latest offspring, which is to run on 32 and 64-bit machines on Windows and Linux, has “no limitations on the size

(Chris Eaton) If you are a command line DBA then you may not even notice the subtle difference between a SQL statement (like RENAME, GET DIAGNOSTICS, SET SCHEMA, etc.) and a command (like SET CLIENT, REORG, DESCRIBE, etc.). Who has time to read the ANSI SQL Standard anyway to find out what is SQL an

Stored procedures are a valuable tool for improving performance in distributed and networked environments. In addition, they can also be used to improve the flexibility and design of your applications. SQL Stored Procedures offer a procedure language that is comparable with stored procedure language

(Vincent McBurney) The Hawk beta software finally arrived! Warning, this blog contains Hawk (version 8) release spoilers, so if you don’t want to know what is in it until you get your hands on your own dvd then stop reading!