(Ralph Clark) Here’s a diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of frag
Other News
Information about the SQL Server edition of the MPS Reporting tool
This article describes the Microsoft SQL Server edition of the Microsoft Product Support (MPS) Reporting tool (MPSRPT_SQL.exe). The article also describes how to download, install, and use the Microsoft SQL Server edition of the MPS Reporting tool.
ADO.NET data adapters using DB2 UDB V8.2 procedures
Configuring ADO.NET data adapters to call DB2 UDB stored procedures was a complex task prior to the introduction of the DB2 Stinger technology! This tutorial walks you through the steps required to build an application that uses SQL stored procedures to select, insert, update, and delete rows from d
Exploring the Distributed Web-Based Application Model and Advanced Features of VoiceXML
(Jeff Kusnitz & Dr. Bruce Lucas) This article is the second in a three-part series that provides an introduction to VoiceXML, as well as SRGS, SSML, and SISR for building conversational web applications. The first installment, Building VoiceXML Dialogs, discussed building VoiceXML dialogs through bo
.NET and DB2 UDB
(Victor Alvarez) With the latest release of DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows, IBM provides .NET developers with a credible alternative to SQL Server. Traditionally, developers working with .NET have resorted to Microsoft SQL Server as the database of choice.
Validating Input Xml Data Files
(Susan Abraham) In most Business Applications we frequently find that the input to a System would be in the form of Xml Data Files. This is particularly true with Modules of a Project that deal with Interoperability. These input files would require to be validated. The validation of an Xml input Fil
How To Include Client-Side Script Functions in an XSL Document
When you return HTML from an XML/XSL transform, you often have to return SCRIPT blocks. This article describes how you can include the DEFER attribute for the tag when you include a script function in an XSL document that is used in a client-side XML/XSL transform.
A Cure for Madness
(C.J. Date) I wrote this short note in response to a paper titled Subquery Madness, in which the author, Jonathan Gennick, raises a question about subqueries in SQL and their implementation in Oracle. The following is an edited version of his question. We’re given a table called SUBTEST with t
Optimizing DB2 for z/OS Catalog Usage
(Craig S. Mullins) This complimentary 6-part eCourse will provide you with expert tips and techniques for optimizing DB2 for z/OS catalog usage. The Lesson Plan includes: Lesson 1: Use RUNSTATS on the Catalog Lesson 2: REORG the DB2 Catalog Lesson 3: More Catalog REORG Scenarios Lesson 4: C
Troubleshooting the Forms Listener Servlet
The purpose of this document is to give an insight into how the Forms Listener Servlet can aid in the diagnosis and detection of various anomalies and errors commonly seen in a web deployed Oracle Application Server 10g Forms application. The paper discusses which files contain diagnostic informatio