(Peter Plevka) With the number and size of DB2 database objects continually growing and the requirements of availability getting tougher every month, it is imperative to plan the reorganization of tables and indexes. This article examines options to consider for reorganization and automation, and it

(Craig Mullins) Next up in this on-going series covering the new features and functionality of DB2 9 for z/OS we will tackle the improvements that have been made to the IBM DB2 utilities.

(Marc Fasbinder) One of the most powerful features in WebSphere Business Modeler is the ability to simulate business processes. Creating business models lets you capture business metrics, such as the times required to perform given tasks, the resources involved, and the costs. The simulation uses th

(Michael L. Gonzales) Organizations face threats from new competitors everywhere. New companies sprout up in established industries daily, while traditional competitive walls fall. Phone companies are suddenly doing battle with cable companies, and even with power companies. Banks may soon find them

(Anil Mahadev) In this series of articles, we shall be discussing the various tools available in DB2 for effectively performing tasks pertaining to a number of situations.

(Willie Favero) Sometimes an enhancement only gets a short paragraph in a Redbook or bars in the margin of a manual. On occasion, you don’t even know that you are using the enhancement. It just does what it’s supposed to do and you reap all of the unseen benefits. Today’s post will focus on one such

(Vikram S. Khatri) This article presents a logging framework that you can use with IBM DB2 for Linux, UNIX, and Windows stored procedures to log informational, error, and debug messages directly from the procedure itself. The logging framework methods use shared memory concepts to coordinate and cha

(Dino Chiesa) One of the nice things you can do with SQL Server 2005 is utilize it as a central federating data server. In this manner of usage, SQL Server acts as the gateway to connect to data that is distributed in different sources across the enterprise.

(Timothy Prickett Morgan) As we reported in our Four Hundred Stuff newsletter last week, IBM is now shipping Version 8 of its Notes/Domino groupware stack. The software, which is a kicker to the Domino 7 software that IBM delivered in September 2005, offers the usual improvements in scalability, rel

(Alex Jarzebowicz) The free-of-charge IBM DB2 Migration Toolkit can simplify and improve your migration to DB2 for Linux, UNIX, and Windows. This tutorial demonstrates the use of the toolkit to convert a database model from a Microsoft SQL Server DDL script to a DB2 database. The converted objects w