(Knut Stolze) The type hierarchy of the IBM DB2 Spatial Extender builds on DB2’s structured types. It can be extended to add new, application-specific data types. For example, data types for rectangles or circles can be derived from the data type ST_Surface, which is used to model planar geometric o

(Troy Coleman) The core of how DB2 is configured on z/OS is through system parameter macros. Commonly called zparms, these macros are stored in an assembled parameter module with a default name of DSNZPARM. The installation clist DSNTINST displays a series of ISPF panels that prompt you with questio

(Chris Eaton) In my last posting I discussed some backup basics including the basic backup command, how to specify a target for the backup, tablespace level backups and how DB2 backups are integrated into TSM. In this posting I’ll cover a bit more about online backups and also talk about incremental

(Azadeh Ahadian) Learn how the features of pureQuery can assist you as an object-oriented developer to define a set of database relational artifacts using traditional class modeling.

(Radhesh Kumar) One of the highlights of DB2 Version 9.5 is “Manage your business, not your database”. IBM claims that the DB2 autonomic computing environment is self-configuring, self-healing, self-optimizing and self-protecting. Autonomic computing is not new in Version 9.5. Past several releases

(Scott Hayes) Every once in a while I hear a DBA say they are having Lock problems. Since read-only or read-mostly Data Warehouse databases rarely have lock problems, I quickly assume they have an OLTP database. It is my opinion that locks are rarely, if ever, a PROBLEM. Locks are a SYMPTOM of anoth

(Robert Catterall) Back in the mid-1990s, when I was on the DB2 for z/OS National Technical support team at IBM’s Dallas Systems Center, I did some consulting work for a major insurance company. For most of one day during an on-site working session, we reviewed the company’s documented disaster reco

(Craig Mullins) I get questions e-mailed to me all the time. Although I try to read and answer them all, sometimes I don’t. I hope those whom I’ve ignored over the years will forgive me, but I can’t always answer everything (not enough time/energy) and sometimes things get lost or drop through the c

(Matthias Nicola) DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. Additionally, DB2 9 has sophisticated XML indexing capabilities and support for XML Schema validat

(Erwin Earley) This is the fourth article in a PHP on i5/OS series and it continues our discussion of the API toolkit included with the Zend Core product. In my previous article Use PHP to Bring i5/OS Resources to the Web, I explained that the API toolkit is a collection of APIs for accessing i5/OS