(Roger E. Sanders) In Part 1 of this column, I described how choosing the correct isolation level controls which phenomena (lost updates, dirty reads, nonrepeatable reads, and phantoms) can occur when DB2 for Linux, Unix, and Windows transactions aren’t isolated from each other in a multiuser enviro
Tag: IBM
DB2 Universal Database: Productivity Features of the SQL Builder, Part 6
(Paul Zikopoulos) In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (Rational AD) product to create and work with IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows database connections. Part 2
DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL
(K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Özcan, H. Pirahesh, N. Seemann, A. Singh, T. Truong, R. C. Van der Linden, B. Vickery, C. Zhang and G. Zhang) Comprehensive and efficient support for XML data management is a rapidly increasin
Adding MDC to DPF and Partitioned Tables
(Chris Eaton) In my last posting I talked about combining table partitioning and DPF to get very high levels of parallelism, scalability and simplified roll-in and roll-out. DB2 also has a technology called Multi Dimensional Clustering (MDC – available since 2002) which provides a great performance
Easing the Cost of Compliance
(James Pickel) The Sarbanes-Oxley Act and other regulations require corporate executives to provide and ensure increased levels of financial and operational discipline. To help comply with this law, most enterprises are now implementing measures that cross financial reporting and processes that impa
Problem Determination for WebSphere for z/OS
(Rica Weller, Cleberson Calefi, Per Fremstad, Keith Jabcuga, Suresh Maddukuri, Kiet Nguyen, Robyn Nostalgi and Rajesh Pericherls) WebSphere Application Server for z/OS V6.0 is a complex product made up of many components, similar to the human body. And, like the human body, WebSphere for z/OS can ex
CM Performance Tuning Guide Update
(Wei-Dong Zhu, Vijay Hubert Dominic, Stephen McNulty, Ludger Schaefers, Paul Walker and Zhenghong Yang) This IBM Redbook deals with performance tuning for IBM DB2 Content Manager Version 8 for Multiplatforms. It is aimed at architects, designers, and system administrators of Content Manager system
A step-by-step how-to guide to install, configure, and test a Linux, Apache, Informix, and PHP server
(Kellen F. Bombardier) This article assumes the use of an RPM-based 32-bit Linux system. The steps provided have been completed on Red Hat Enterprise Linux 4 and SUSE Linux 9. However, the overall ideas can be conveyed across any Linux distribution.
By Any Other Name
(Robert Catterall) Sometime in the mid-1990s, I was on an airplane still parked at the gate at DFW International Airport, when the person sitting next to me initiated a conversation by asking what I did for a living. I explained that I was part of IBM’s mainframe DB2 national technical support organ
IBM terms DB2 Viper major generational leap
IBM is talking about the addition of “pure XML” and mainframe-like compression techniques to DB2 version 9, which until now was better known by its code name “Viper.” The release covers DB2 for distributed platforms on Windows, Unix, and Linux.
