(Tina Chen) IBM Data Studio Administrator 2.1 enhances DBA productivity by simplifying day-to-day database administration tasks. Focusing on accuracy, and thereby reducing risk, Data Studio Administrator streamlines database changes and migrations by automatically generating change commands. This re
Tag: IBM
An SQL smile getter
(Willie Favero) A few days ago, we had a post to the DB2-L list that should have brought a smile (or at least a groan) to anyone who read. Lock Lyon made the post that he says he also made previously on this list. In fact, we think I may have blogged about last time. However, I can’t find it […]
UPDATE: DB2 Health Monitor Problems – will they ever be resolved?
(Jeffrey Benner) UPDATE 2009.02.17: I received a response from IBM which I am in the process of testing. It involves DB2 registry variable DB2ENVLIST, and an environment variable DB2_HMON_DFT_STACK_SZ which appears undocumented. Please scroll to bottom of article for the update. I will revise the en
Which distributed edition of DB2 9.5 is right for you?
(Paul Zikopoulos) Learn the details on what makes each edition of DB2 9.5 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, licensing considerations, historical changes throughout the DB2 9 release cycle, and references to some interesting things customers
DB2 Visual Explain is being deprecated
(Willie Favero) The subject pretty much says it all.
SQL XML Comparison and Assignment Rules and Encoding in DB2 9 for z/OS
(Guogen (Gene) Zhang) XML is a unique data type in SQL. Understanding its rules is important in getting it right in applications. Luckily, many of the rules are straight-forward. I will cover the following three aspects here: –XML comparison rules; –XML assignment rules; –XML data encodin
Top 10 FAQs on core group bridges
(Jacquelle Leggett) Here are the most commonly asked questions about the IBM WebSphere Application Server’s core group bridge service, introduced in Version 6.0, which is used to enable high availability communication between core groups.
DB2 Partition-By-Growth Tables: Very Nice, But Not For Everything
(Robert Catterall) Not long ago, I was doing some work at a site that had DB2 for z/OS V8 running in production (as is true, I think, of most mainframe DB2-using enterprises at present – with a tip of the hat to those organizations that have installed or migrated to V9). A DBA came by with an idea f
DB2 and EC2
(Radhesh Kumar) Though irrelevant, there is a similarity of alphabetical pattern between DB2 and EC2. E comes just after D and C comes just after B in the alphabet. May be this similarity aroused my interest in EC2… J Also, IBM and Amazon have partnered together to deliver DB2 in Amazon EC2 (Elast
Compare the distributed DB2 9.5 data servers
(Paul Zikopoulos) In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 9.5 server family as of the interim release packaging changes announced on February 10th
