(Chris Eaton) Here is a very fast and very low overhead way to look at lock wait situations in DB2 using the db2pd tool. You can of course find locking information from the snapshot monitors or from the administrative views I described previously. But for those that like something very light weight
Author: SSWUG Research
Health Monitoring in ASP.NET 2.0: The Basics
(Scott Mitchell) Software engineering involves a number of important stages that occur before the application is deployed, such as requirements analysis, design, coding, and testing. The software engineering process, however, does not end once an application has been deployed and is being used. Rega
SQL analytics: A self-service model
(Jeffrey R. McCormick) SQL analytics remains one of the best-kept secrets of the Oracle database. It represents the latest advancement in the evolution of delivering powerful analytic capabilities to end users. How quickly the business will benefit is largely in the hands of database teams and their
Abstracting Database Access Using Polymorphism with Objects in PHP 5
(Alejandro Gervasio) Polymorphism is an object-oriented programming concept that can be difficult to understand. This article, the first of a three-part series, walks you through the basics of Polymorphism so that you can make use of it in your own applications. The specific example in this article
Anixter’s Migration to DB2 for z/OS Version 8
(Damon Anderson and Bernie O’Connor) This case study of Anixter’s migration to DB2 for z/OSVersion 8 is presented largely in chronological order. It contains informationon our training, planning, risk identification and mitigation, installation, configuration, testing and implementation. We hope our
Migrating WebSphere InterChange Server artifacts to WebSphere Process Server artifacts, Part 2: Understanding the WebSphere Process Server SCA components
(Lisa A. Seacat) In Part 2 of this series, we’ll describe the SCA components that are generated when you migrate WebSphere InterChange Server collaboration objects to WebSphere Process Server.
Oracle Accuses SAP of ‘Massive’ Theft
Oracle threw a firebomb of accusations at SAP today, charging its enterprise software rival with corporate theft “on a grand scale.”
Benchmarking node restart time in 5.1
(Johan Andersson) When you have a node failure the best practice is to restart the ndbd node as soon as possible.
How do I… Enforce domain integrity for SQL Server data using CHECK constraints?
(Susan Hawkins) You might think that simple data errors aren’t terribly important, but even a small error can do a lot of damage. For instance, an incorrect ZIP code doesn’t seem too serious–until a new customer’s order doesn’t show up. Or imagine your best salesperson’s surprise when a commission
So, are Database Stored Procedures Good or Bad?
(Roland Bouman) A little less than a week ago, I opened a zoomerang survey about database stored procedures. In this post, I’m presenting the results.