(Dan Tuck) This quickly generates a command to force off applications connected to a specific database. The DB2 command “force application all” is too wide in its effect. This tip provides the needed command for a specific database. Just cut-and-paste the command to execute it. It has been tested on
Other News
Choice and Identification of XML Character Encodings
(Dan Chiba) When text is stored, transferred or processed, it is essential that the character encoding be known. This principle also applies to XML, because XML is text based. Despite the fact that XML may be encoded in various ways, there are no guidelines about which encoding to use and how to
Monitoring Failed Job Steps
(Leo Peysakhovich) One day I became tired of doing a manual procedure to check every morning to see if nightly backup, data transfer, and other jobs have failed. I decided to develop code that will automatically verify if jobs have failed and email the results to me. (R)
Date/Time from Substraction of Two Date Values
(Galina Petrenko) This technique presents conversion of the result of subtraction between dates. For example, I am looking for how many days, hours, minutes, etc. elapsed between two dates. Oracle Database is returning the result in days (such as 2.23456). The result is not exactly readable and has
Speed up Development on Backend and Middle Tier with SQL Scripts
(Ameet Phadnis) Ever wish you had a tool/robot that would allow you to generate your stored procedures and middle tier functions/classes for you and save you lot of time in coding? Most developers do get tired of coding with the same approach over and over. This article demonstrates how you can buil
Why We Need XML Query Standards
(Jonathan Robie) Despite a shortage of sophisticated XML query tools, Internet demands have forced companies to present their data in various formats. In one sense little has changed, as SQL queries have long been used to combine data for different purposes and audiences. Now however, the output is
Web-Services Transactions – From Loosely Coupled – The Missing Pieces of Web Services
(Doug Kaye) Most non-programmers think of transactions as associated with buying and selling, credit-card authorizations, and the like. But in the jargon of computer science, the word transaction has a very specific meaning: the interaction and managed outcome of a well-defined set of tasks. If that
WS-Policy and WSE 2.0 Assertion Handlers
(Aaron Skonnard) Back in the July and August 2003 issues of MSDN Magazine, Dan Sullivan and I covered various Web services validation techniques. We highlighted the fact that the ASP.NET Web services framework (ASMX) does not perform XML Schema validation on incoming messages and we illustrated the
Oracle 10g: Infrastructure for Grid Computing
Today, islands of computing within organizations make inefficient use of resources. Systems are slow to change and expensive to maintain. Grid computing addresses these problems by providing an adaptive software infrastructure that makes efficient use of low-cost servers and modular storage, whi
Autonomic is Automatic with IBM Database
(Clint Boulton) IBM said it has added features to its database software for its eServer zSeries mainframes to help businesses improve and automate the flow of their information.