(Steve Raspudic and Malaravan Ponnuthurai) Learn how to configure a failover solution for IBM DB2 for Linux, UNIX, and Windows, using the DB2 high availability disaster recovery (HADR) feature and the the DB2 high availability instance configuration utility (db2haicu). This article walks you through

(Rick Weaver) When a DB2 database is first created and loaded, it’s in fine shape; data is in sequence and free space elements exist. However, over time, the objects can become disorganized, especially the indexes. There are two main reasons to reorganize a DB2 database: I/O performance and space re

(Andreas Christian, Waldemar Gaida, Hans-Jürgen Moldowan and Thomas Rech) SAP migrations are a standard process nowadays. This IBM Redbooks publication describes optimization strategies and best practices for migrating SAP systems toward IBM DB2 for Linux, UNIX, and Windows, as well as for performin

(Burt L. Vialpando and Vikram S. Khatri) This tutorial provides a series of exercises using IBM DB2 Workload Manager (WLM). By following these exercises, you should become familiar with the DB2 WLM feature and start to see the immediate value you can obtain from its use. For those new to WLM, the tu

(Willie Favero) The next release of what could easily be the “greatest operating system ever written” will go GA (generally available) the end of next month on September 25, 2009. All the details about what you gain by moving to z/OS 1.11 are available in today’s (August 18, 2009) announcement lette

(Troy Coleman) For years DBAs have advised against the use of SELECT * in production applications. The problem is when a new column is added to a table, SELECT * picks up this new column. This forces you to change all of the programs that use your table — even those that don’t need the new column.

(Susan Visser) Have you seen this exciting news: DBI is sponsoring a new virtual TV Show “The DB2Night Show”. Your host will be Scott Hayes and we hope he further develops his sense of humor!

(Radim Kolar) I hear on DB2 Express C forum complaints about lack of free fixpacks for DB2 Express C quite often. As i understand most of people using these forums are developers and developers like always use latest version and latest security and stability patches. For application developer using

(Deb Jenson) As lead product manager for the Optim and Data Studio administration capabilities, I have been getting lots of questions about Data Studio ever since DB2 announced the deprecation of DB2 Control Center. I think some people haven’t gotten the word yet about the capabilities in Data Stu

(Willie Favero) Do you ever have one of those situations where something just doesn’t quite sink in, no matter how many times you do it or how many times you read about it? I’m like that with the Workload Manager (WLM) stuff that is required when I have to set up the WLM environment for a stored pro