Featured Article(s) Kill a Blocking Session After Waiting a Parameterized Wait Time Value The following stored procedure can be used inside a job that runs on a recurrent basis and kills all blocking session (block column in sysprocesses != 0) that the wait time column of the blocked session is greater than a parameter value (in miliseconds) The procedure kills […]
Other News
DB2_CAPTURE_LOCKTIMEOUT
(Rob Williams) One of the worst default parameters for DB2 in my mind is the LOCKTIMEOUT parameter. I have seen this in a number of broken applications cause big problems. While facilities existed to find out what statements were causing deadlocks nothing similar existed to diagnose timeouts.
DB2 Trusted Contexts: Making Security Compliance Easier
(Walid Rjabi) The 3-tiered application model extends the standard 2-tiered client and server model by placing a middle tier between the client application and the database server. It has gained great popularity in the recent years particularly with the emergence of Web-based technologies and the Jav
IBM WebSphere Information Analyzer and Data Quality Assessment
(Nagraj Alur, Reginald Joseph, Harshita Mehta, Joergen Nielsen and Denis Vasconcelos) IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information that is spread across their systems. It enables organizations to
XML 2007
(Elliotte Rusty Harold) 2007 was another slow year for XML. However, several important specifications did reach 1.0, and XML continued to gain traction in publishing, both Web and traditional. Most important, the slow leak in the Web services ship caused by its collision with the REST iceberg turned
XML Schemas: guaranteed non-interoperability as a design methodology?
(Rick Jelliffe) The vogue quip that “a camel is a horse designed by committee” probably makes more sense to people who don’t live in a desert country. From here in Australia, camels seem to a very plausible design. It is the speaker, actually, who is wrong: what you need is a camel when you are in t
Using XmlSearch() In CFLoop Array (Thanks Scott Bennett!)
(Ben Nadel) Yesterday, in the comments on my post about using XML with ColdFusion 8’s new array iteration using CFLoop, Scott Bennett posted an example of using an XmlSearch() as the value being passed to the Array attribute in the CFLoop tag. I don’t know why exactly, but this just struck me as qui
Upgrading from 4.1 to 5.0
December the 17th we upgraded the majority of our servers that had been running version 4.1.22 of MySQL to 5.0.45. This was not a small undertaking and is something that I had been planning for about five months. It had been initially slated to take place in September, but due to the release of a ne
CodeSnip: Implementing Asynchronous Remoting in .NET
(Abhishek Kumar Singh) We can implement remoting in two different ways of operation. They are Synchronous and Asynchronous operation.
.NET Tip: Display Public Information for an Assembly
(Jay Miller) My last tip, “Display All Fields and Properties of an Object,” showed you how to display information for an object in your program. This time, I’ll show you how to display the public information for an assembly. I’ll again use reflection to load an assembly and then iterate through the