(Maria Sarikos) So what exactly is data skew? In the DB2 context, it happens when DB2 creates an access path based on certain assumptions, but those assumptions are wrong, so the access path created is just plain inefficient. For example lets say you were selecting all the names in your client table
Other News
The IBM information management strategy
DB2 information management is a core competency for IBM. Therefore, IBM has a large, multisite organization that is dedicated to helping you manage your data and leverage your business information. The IBM information management strategy has evolved over time as technological advancements and the ne
What’s up with XML 2.0?
(Ed Tittel) No sooner does one standard make it through whatever official processes its parent organization requires for approval, than another version, add-on or successor seems to rear its head. I tend to look at this as a sort of adult version of "the bear went over the mountain" intended as much
Technical tip: Secure DB2 communications using OpenSSH tunneling
(Sandeep Ramesh Patil and Manish Katiyar) As the popularity of Internet increases with every passing hour, so does the need to store this huge volume of data and protect it as it floats around in this mesh. This large volume of data is stored in various available databases, which provide the appropr
Building Reports from a DataSet using ReportViewer
(Mahesh Chand) In this step-by-step tutorial, you will learn how to create reports from a Database using a DataSet and the ReportViewer control and Visual Studio 2005.
Miscellaneous Concepts of .NET – Part 1
(Uday Denduluri) Process was the basic unit of execution and isolation for running applications in Traditional Windows application development. The advantage with the model was that each application running was loaded into a separate process that automatically isolated each application from the othe
Apply DWR to Data Validation in an AJAX Application
(Deepak Vohra) Direct Web Remoting (DWR) is a Java open source library for developing AJAX applications that consists of two components: JavaScript running in the browser that sends requests and dynamically updates the web page with the response, and a servlet running on the server that processes re
Windows SharePoint Services v3.0 1:Introduction
(Chris Sully) In this series of articles I’m going to be looking at Windows SharePoint Services 3.0, which we’ll abbreviate to WSS3 from here on. WSS3 is the free version of SharePoint whereas Microsoft Office SharePoint Server 2007 (MOSS) is its big, commercial brother. It is its brother however an
Making the Most Out of the SQL Server 2005 Performance Dashboard
(Brad M. McGehee) If you have been using SQL Server 2005 for a while now, you may wonder what I am talking about when I refer to the SQL Server 2005 Performance Dashboard. No, you are not suffering from overwork and fatigue, causing you to lose your mind and forget what new features have been includ
Quest Code Tester for Oracle
(Steve Callan) If you write any significant amount of PL/SQL code, your day of salvation has arrived, and the salvation is in the form of Quest Code Tester for Oracle (QCTO). If you work in a structured development environment (even minimally so), the responsibility for performing unit tests falls u