(Kondal) In part 1 of this article I have discussed on how to improve DB2 Connect performance accessing databases residing on z/OS host server. In the part two of this article I would like to shows you to access databases residing on AIX (distributed side) as well as z/OS platform.
Author: SSWUG Research
Optimize SQL Server
Want to optimize your applications that run on SQL Server? Then take advantage of Symantec’s offer for free SQL Server 2005 Application Performance Management whitepapers in eBook format, and get an in-depth education. You’ll learn about key SQL Server development and runtime challenges from industr
Saying yes, no or maybe to stored procedures
(Jack Vaughan) The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Sometimes that swinging is very slow — so that it is practically imperceptible. Developers with considerable experience may not be aware of pendulum swings that occurred just a few y
Using IBM DB2 UDB with IBM System Storage N series
(Alex Osuna, Jeremy Brumer, Jawahar Lal and Roger Sanders) Database cloning is process by which you can create an exact copy of a DB2 database, either by physically copying the data or by performing what is known as a redirected restore. Database cloning is performed frequently by database administr
SQL & XQuery tutorial for IBM DB2, Part 5: Data comparison
(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial describes queries that compare data in an IBM DB2 database. This is accomplished by using either CASE expressions or subqueries. This tutorial is Part 5 of the SQL & XQuery tutorial for IBM DB2 series. (R)
Optimizing the Logical Database Structure
(Paul Dubois) In this final article of our series, you will learn more ways of organizing your data to achieve better query performance.
Globalization and localization demystified in ASP.NET 2.0
(vivekthakur) Globalization and localization are two important processes which every developer should be aware of while creating global products or applications. Though there are many articles which explain the subject well, I did not find a single resource which explains all important concepts reag
Streamline Your Oracle Production Code with Conditional Compilation
(Natalka Roshak) If you’re an Oracle PL/SQL developer, you have two familiar needs: –Include as much debugging code as possible without risking a performance hit when the code is running in production –Create code that takes advantage of the newest features in the latest Oracle Database vers
Developing 3 tier web sites in ASP.NET 2.0
(Bipin Joshi) Many months back I wrote a series of articles that explained in plain words N-tier application development. Then came .NET 2.0. Many things changed especially for ASP.NET. So I decided to write a sequel to the earlier series specifically for ASP.NET 2.0. This article will explain h
Seven Steps to XML Mastery, Step 7: Ensure XML Security
(Frank Coyle) As XML and web services play an increasingly important role in enterprise applications, security becomes a critical concern. Unfortunately, as any technology gains ascendancy, it draws the attention of black hat attackers, continuously on alert for opportunities to wreak havoc by steal