(Bernard Zver) This article describes my DB2 admistration routines. The DB2 routines are stored procedures, user-defined functions, and triggers. We have many SPs, UDFs, and triggers, so I have prepared an easy way to manage them. If you want to change create definitions for DB2 routines, you must r
Other News
Failover Clustering Functionality
(Adam Machanic) How does failover clustering work in SQL 2005? And how does it compare with the failure support in Oracle and DB2? (R)
How to move Microsoft Provisioning Server (MPS) databases to a clustered virtual SQL Server 2000 named instance
This article describes how to migrate your Microsoft Provisioning Server (MPS) databases from a stand-alone Microsoft SQL Server 2000 instance to a clustered virtual SQL Server 2000 named instance.
Integrating Keyword Search into XML Query Processing
Daniela Florescu, Ioana Manolescu and Donald Kossmann) Due to the popularity of the XML data format, several query languages for XML have been proposed, specially devised to handle data whose structure is unknown, loose, or absent. While these languages are rich enough to allow for querying the cont
Oracle ODBC driver returns SQL_DECIMAL for all convert function calls
When you perform a query on an Oracle database by using the ODBC CONVERT function, the Microsoft ODBC Driver for Oracle requests that the data be converted to DECIMAL for all ODBC integer types. DECIMAL is the default Oracle convert type. The following code is an example of this query: SELECT {fn
Exploring the Oracle Database 10g Wait Interface
(Robin Schumacher) In the pursuit of optimal database performance, Oracle professionals have been slowly migrating away from performance analysis techniques that focused on blanket system ratios to a methodology that instead zeros in on where a system, application, or session is spending its time. R
Refactoring to Adaptive Object Model: Pragmatic usage
(Chris Lasater) Adaptive Object Modeling is a relatively new concept in object oriented design that has found some roots in advanced development processes. It allows that applications are in continual flux (or their requirements are) from adjustments to business rules, environments and user requ
TechTip: V5R3’s New SQL BIFs, Part 1
(Mike Faust) One of the most powerful features of Structured Query Language (SQL) is the use of built-in functions (BIFs). In V5R3, IBM enhanced the set of BIFs supported by the DB2 UDB for the iSeries implementation of SQL. In fact, 25 new BIFs have been added. In this TechTip, we’ll explore the fi
Install the DB2 UDB data partitioning feature on Linux
(Priti Desai and Fraser McArthur) This article provides a straightforward example of an actual installation of IBM DB2 Universal Database Extended Server Edition V8.1 with the data partitioning feature (DPF) on Red Hat Linux Advanced Server 2.1 using the scripted db2_install method. Using db2_instal
Localizing ASP.NET 2.0 Applications
(Wei-Meng Lee) As we compete in the global economy, the challenges in globalizing include understanding the language and culture of the local audience. An application written for the American market may not be useable in the Asian market. Learn to localize your application for the world market.