(Ani Patel) For the database administrator (DBA) who is just stepping into the world of DB2 or for the prospective DBA, the design and performance choices for a new database can be very confusing. This article discusses two areas in which the DBA has important choices to make: table spaces and buffe

(Rakesh Kumar) Two SQL based ways to get detailed information on a DB2 table:

(Robert Catterall) This is the third of a three-part entry on various factors you could consider in determining how (or whether) DB2 stored procedure technology might be employed in your organization’s application environment.

(Prashant Shettar, Marion Behnen and Shantanu Mundkur) DB2 Text Search enables an IBM DB2 for Linux, UNIX, and Windows database user to create applications with full-text search capabilities by embedding full-text search clauses in SQL and XQuery statements. In this tutorial, you’ll set up a databas

This video highlights some of the new features in DB2 9.7 that make it very easy to enable Oracle applications to DB2. It includes demos for features like support for PL/SQL, CLP Plus, the free IBM Data Movement tool, and Optim Development studio for debugging.

(Keith McDonald) A critical aspect of maintaining a database is getting the most current data possible into it. In data warehouses, this need is often met with extract-transform-load (ETL) technologies. DB2 for LUW addresses the loading aspect with a very sophisticated built-in load utility that mak

(Keys Botzum) Security consists of more than just some firewalls at the edge of your network protecting you from the outside. It is a difficult and complex set of actions and procedures that strive to strengthen your systems as much as is appropriate. This article discusses many aspects of security

(Bryan Smith) I’m excited to be co-presenting with one of our customers at IOD EMEA in May. Roberta Barnabe, a DB2 Specialist for UGF (Unipol Gruppo Finanziario) Assicurazioni, will be sharing her experiences with IBM Optim Query Workload Tuner for DB2 for z/OS.

(Keith McDonald) Today’s post is about DB2 Data Partitioning Feature (available in Infosphere Warehouse) and how you can use db2top to monitor your partitions. In this post, you’ll see how to use the Partitions screen to watch for skew between partitions in real-time. The Partitions screen can be la

(Troy Coleman) Having consulted with companies of all sizes through the years, including many that did not provide their DBAs with management tools, I’ve long appreciated the power of SQL. SQL is especially helpful when you need to generate JCL. This week we’ll look at SQL that generates a runstats