(Willie Favero) For the first time in DB2’s 24 years, you are being given the option to shot yourself in the foot for just about any user table space defined to DB2.

Managing DB2 in today’s business environment is more difficult than ever. Business dynamics have increased the rate of change and complexity within the typical IT environment. The explosive growth of data, the decline in experienced workforce, and the ability to respond to the needs of critical DB

(Chris Eaton) So far I have written quite a bit about db2pd. To date I have covered: –intro to db2pd –monitoring bufferpool pages –monitoring log utilization –monitoring table access –monitoring locks

(Donal Riordan) IBM Rational Application Developer V7.0 and IBM Rational Software Architect V7.0 are the first products in the IBM Rational Software Delivery Platform range of products to include full-featured support for IBM WebSphere Portal V6.0 development. This means that you can develop with th

(Susan Visser) Now is the PEFECT time to validate your skills and demonstrate your IBM DB2 9 proficiency with Information Management Professional Certification. Ensure your success on exam day by taking advantage of our preparation resources.

(Willie Favero) Do you have a need to know when a row was last changed or inserted? Would you like to find out using a feature of SQL and have everything to track a last changed just happen automatically. If you do, then does DB2 9 for z/OS have another cool little feature for you. Here are a couple

(John A. Marsh) I am currently involved in a project where the program I am writing is supposed to return a list of the 10 doctors nearest to a visitor’s zip code. Note that this is not the same as doctors in a given radius (say 10 miles), but it does use the same basic formula. This article will be

(Craig Mullins) I was going through the many random files stored on my PC when I came across this useful nugget. A year or so ago a reader sent me this code. He and his supervisor had come up with a way to simulate the Oracle rownum feature in DB2 and wanted to share it with the world. I think, […]

(Omer Brandis) I have a short story to tell, its all about how I created my first table controlled partitioned tablespace by mistake. I do hope that by sharing this sad story, I’ll help someone else to not make the same mistake, so here goes:

(Kent Milligan) While index advice from the DB2 query optimizer is not new, the advice itself is much easier to capture and analyze with the new V5R4 tooling. A recent set of V5R4 PTFs simplifies the process even further.