(Brian Walker) This tip continues the system stored procedure series with a routine to create a comma-delimited file containing data from several columns. (R)
Other News
Replication using LogMiner
(Frank Pantaleo) This script was born out of a desire to replicate data from production while minimizing the effect on production. The best way to do this was to leverage APIs that Oracle made available in 8i. Some or all of this logic provided becomes unnecessary in 9i with the advent of Oracle Str
DeployPHP Series, Part 5: Zend Core for Oracle Quick Start
(Matt Kern) Since the early days PHP has been able to talk to Oracle—but it wasn’t easy. Deploying PHP with Oracle was complicated at best, requiring developers and administrators to find, download, compile, link and configure multiple applications and packages. Unfortunately, this fact was counteri
How DB2 for LUW Stripes Data
(Chris Eaton) In my last posting I talked about tablespaces in DB2 for LUW vs. DB2 for z/OS. I think it is worth spending a bit more time talking about extents in DB2 for LUW and how they can increase the I/O parallelism you can get out of DB2.
Tuning Oracle9i on Linux
(Aradhana Puri) On Linux platforms, using Oracle Cluster File System (OCFS) and asynchronous input/output (I/O) and implementing a large System Global Area (SGA) make it easier to manage Oracle9i on Linux.
Closing the Loop: Improving Corporate Performance with MIS DecisionWare and Microsoft SQL Server
This whitepaper discusses how MIS DecisionWare and the Microsoft platform work together to improve data quality, simplify information access and streamline business processes. Microsoft customers can use MIS to optimize corporate performance in a quick, affordable manner. (R)
Siebel 7.8 with IBM DB2 UDB V8.2 Handbook
(Whei-Jen Chen, Priti Desai, Ujwala Devi, Sreeman Kancherla, Venkatram Menakuru, Raghu Ramaswamy, Scott Saunders and Arjun Sirohi) This IBM Redbook delivers details about DB2 UDB V8.2 on Siebel 7.8. It outlines the partnership between Siebel Systems and IBM and the benefits of using DB2 UDB to suppo
Introduction to Class Programming
(Dante Salvador) In application program development, one of the most important considerations is the program’s ability to accurately represent our perception of the real world. This requires the program to incorporate a realistic data model. Such a program is certainly easier to understand than one
IBM may offer free DB2 database
(Aaron Tan) Teo Wan Ping, IBM Singapore’s brand manager for information management, told ZDNet Asia that IBM could “potentially offer” a free starter edition of DB2, as part of the company’s strategy to win over developers to its database product.
Monitor CPU Usage of All Running Processes – Part II
(Muthusamy Anantha Kumar) Part I of this article illustrated how to monitor CPU usage of running processes on a local machine or from a remote machine. This article illustrates how to monitor the CPU usage of different running processes on different machines and collect the information in a database