(Robert Catterall) At way too many sites, the answer to this question is, “Nothing.” Application developers and DBAs spend lots of time figuring out how data in a database will be inserted, updated, and retrieved, but all too often the matter of removing data from the database ends up getting deferr

(Robert Gas) Like those of an aged race horse, the glory days have passed for IBM Query for iSeries (aka Query/400).

(Nelson King) Social networking, blogs, wikis, RSS feeds, mashups, and other Web 2.0 technologies are hitting businesses like a gale-force wind. IBM recently launched Info 2.0 to capture, focus, and control this energy. The initiative’s ultimate course will depend on its talented (and somewhat surpr

(Paolo Bruni, Terry Berman, John Iczkovits, Basuki Soetarman, Bart Steegmans and Mike Turner) The cost-based optimizer of DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures such as star

(Willie Favero) What might you think that all of the above have in common? They all play some roll in a behavior change that took place (or will take place) when you upgrade to DB2 Version 8 for z/OS. This one is not only kind of subtle; it’s not even documented (yet) in the DB2 Version 8 manuals, d

(Rebecca Bond, Yuk-Kuen Henry Chan, Kevin Yeung-Kuen See and Carmen Ka Man Wong) When thinking about organizational information security, your mind might jump to the technical details such as firewalls, access control lists, certificates, auditing, encryption, and all those well-known electronic tra

(Nidal Arabi) This article is just a humble introduction to programming AS400 DB2. I did some research and found really no complete article on how to approach the AS400 machine using the .NET platform. There are really no big issues here, but I will tackle the basic foundations of creating a code fi

(Scott Forstie) DB2 for i5/OS customers are seeing an ever increasing use of SQL Server Mode. When trying to make sense of all the QSQSRVR jobs in the QSYSWRK subsystem, you might quickly come to the conclusion that it is nearly impossible to approach the question from the perspective of server jobs

(Matthias Nicola and Uttam Jain) One of the most significant new features in IBM DB2 9.5 for Linux, Unix and Windows is the XML update functionality. The previous version, DB2 9, introduced pureXML support for storing and indexing of XML data and querying it with the SQL/XML and XQuery languages. Mo

(Stephen Levett and Suita Gupta) Are you a DBA for an IBM DB2 installation on AIX? Read on, to learn how you can use AIX utilities and commands to administer and troubleshoot issues that affect the operation of your DB2 database such as CPU usage, orphan processes, memory leaks, hangs, and more. Thi