(Chris Eaton) Now back to my series of postings on the db2pd tool (posting 1, 2 and 3). In this posting let’s look at the table stats you can get out of db2pd. There is a flag you can use that will dump out any table that has been accessed along with some very useful information (some of which I […]

(Andrew Law) Trying to upload test data with the DB2 Import Utility. I have a .CSV file with 100,000 records in it. It used to work; then I added another column and now it fails with “transaction log for database is full” errors.

(Arthur Choi) Replacing paper with electronic documents brings many advantages to a business: faster processing, concurrent access by multiple people, and the possibility of a single system of record with audit trails. We do a good job when dealing with scanned images and computer-generated document

(Rikki Kirzner) Software architects or developers—are you developing applications in heterogeneous and/or globally distributed environments? If so, are you getting fed up with using multiple tools and processes to support and synchronize your efforts? Do you need a more productive, agile, and holist

(Emilio F Zegarra) This article illustrates how to use the team environment capabilities in IBM WebSphere Business Modeler Advanced V6.0.2 to configure and use Concurrent Versioning System (CVS) as a source control tool to enable the sharing of business processes. This article is intended for busine

(Vitor Rodrigues) Using the Silver Castles analogy described and developed in the article “Use DB2 Native XML with PHP”, from Hardeep Sing and Amir Malik. The goal of this demonstration is to illustrate the different database environments and their impact on the application code by performing a sid

(Willie Favero) Yesterday I posted that DB2 9 for z/OS will be generally available (GA) on March 16, 2007 ( “DB2 9 for z/OS General Availability (GA) Date Announced”). Well, I came across this open APAR that will distribute the premigration health check jobs. Once closed, the PTF will give you a set

(Madan Sheina) Convergence CT Inc has teamed up with IBM Corp to develop a clinical data warehouse built on IBM’s Balanced Configuration Unit software-hardware platform.

(Willie Favero) It’s here and it’s official. Today, Tuesday, March 6, 2007, just one short month after the End of Service announcement for DB2 Version 7 (see my post last month discussing EoS “17 months and getting closer everyday… DB2 Version 7 EoS announcement”), IBM announces the general availab

(Lee Siegmund) Years ago, I heard a product developer describe his experience in creating a DB2* product feature by stating that “the solution was intuitively obvious after studying the problem for several years.” I can make the same statement relative to tuning DB2 SQL queries – I find tuning DB2 q