(Craig Mullins) I have a cursor that selects “n” rows from a table based on certain conditions. For each of the rows selected, certain functions have to be performed that updates a few tables. If there is any error while processing, the updates to the table are rolled back and continue processing wi
Other News
Modeling a DB2 UDB database with IBM Rational XDE Developer for Java
(Suita Gupta and Nanda Pilaka) This article shows you the basics of how to model a DB2 UDB database using IBM Rational XDE Developer for Java.
Building and Using Asynchronous Web Services
(Shail Srivastav) In this article I will show how to build and use asynchronous Web services in your application and how you can use the callback method to make your application work in asynchronous state. I made this application to calculate the speedup for the case when you want to run long proces
DB2 Universal Database Security
(Roger Sanders) Nine percent of the DB2 UDB V8.1 Family Fundamentals certification exam (Exam 700) is designed to test your knowledge about the mechanisms DB2 Universal Database uses to protect data and database objects against unauthorized access and modification. This chapter introduces you to the
SQLDTS File Transfer Protocol Task
(Darren Green) The SQLDTS FTP Task is designed to give you greater control over FTP operations compared to the task supplied with SQL Server 2000, as well as supporting SQL Server 7.0. The task supports both upload and download operations, as well as exposing options such as port, connection typ
Don’t Just Do Something, Stand There! Avoiding Junior DBA Mistakes
(Jim Czuprynski) When an Oracle database suddenly becomes unavailable, the immediate reaction is to do something — right now! — to solve the problem, which sometimes makes the problem worse. This article discusses some examples of when it’s really best to stop and think before proceeding.
Data centers will reach XML ‘tipping point’
(Michael S. Mimoso) Service-oriented architectures, XML and Web services may be evolving into viable enterprise computing strategies, but they do come at a price. Parsing, transforming and validating XML puts a drain on server resources and cuts into service levels, according to research done by
TechTip: Handle Multiple Members Within SQL
(Kevin Forsythe) When I read Jeff Olen’s TechTip on handling multiple-member files within RPG code without resorting to the traditional OVRDBF command, I realized that a lot of people may not know how to handle that situation within SQL.
Monitor Database Growth on Multiple SQL Servers
(Muthusamy Anantha Kumar) It is very important for SQL Server Database Administrators to monitor the database growth on all of the SQL Server boxes. By monitoring such growth, the database administrator can take pro-active actions such as increasing the volumes, moving the .mdf, .ndf and .ldf to dif
Oracle® Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition 10g Release 1 (10.1.0.2.0) for Windows
This document describes the tasks to install Oracle Database 10g Standard Edition on a Windows two-node cluster, using Real Application Clusters (RAC) and Automated Storage Management (ASM). This install also builds a general purpose starter database with the Sample Schemas included and with automat