(Keith McDonald) In the last post on this subject, we used dynamic SQL to generalize an integer comparison function into a stored procedure that builds comparison functions of any basic type. This served as a simple example, but did not really offer much benefit over using the ‘=’ operator. In today

(Willie Favero) On March 12, 2010, IBM announced a closed beta for DB2 10 for z/OS and a few select customers are now putting it through its paces. We don’t yet know when DB2 10 will be Generally Available (GA), nor has IBM announced when DB2 Version 8 (in service for six years) will go out of servi

(Marion Behnen) DB2 Text Search enables full-text search on structured and unstructured data stored in a DB2 database. It uses linguistic processing to determine the result set of a full-text search query. This article provides an overview of the document analysis process and the treatment of variou

(Leons Petrazickis) Version 1.8.4 of the ibm_db2 extension for PHP has been released. Changes include:

(Julian Stuhler) For some time now, IBM DB2 for z/OS has been the major user and benefactor of the zIIP engine: one of a number of System z technologies collectively known as “speciality processors”. Learn how IBM DB2 for z/OS uses zIIP and how it reduces the monthly software cost for customers on W

(Keith Chan) In a clustered environment, deploying updates to WebSphere Commerce can be a daunting task that requires site downtime. By using the rollout update function and using the guidelines provided in this tip, you can minimize the downtime required to propagate your update in a smooth and err

(Keith McDonald) Metaprogramming can feel like magic. You call a function that you neither wrote nor imported from any library and, magically, it comes back with a result. Even more magical is how metaprogramming lets you do otherwise impossible things with your programming language. In “The Art of

(Leons Petrazickis) You might need to enable network file system (NFS) services when configuring the High Availability Disaster Recovery (HADR) or Database Partioning (DPF) DB2 features. For example, with HADR, you might want to set up a slave database that shares a backup with the master database t

(Henrik Loeser) Starting with DB2 9.7 FP2 it is possible to transport tablespaces and schemas. What does that mean? You take a backup image of an existing database and RESTORE the database schema(s) and associated tablespaces into another existing database.

(Keith McDonald) For the second video in this video series, we have a demonstration of the db2top Watch feature. It demonstrates capturing a single application’s SQL, capturing complete database structures to a set of files, and capturing all the dynamic SQL in the cache: