The release notes contain late-breaking information for the following DB2, Version 8 products: DB2 Universal Database Personal Edition DB2 Universal Database Workgroup Server Edition DB2 Universal Database Workgroup Server Unlimited Edition DB2 Universal Database Enterprise Server Edition DB
Other News
A Really, Really, Really Good Introduction to XML
(Tom Myer) In this chapter, we’ll cover the basics of XML — essentially, most of the information you’ll need to know to get a handle on this exciting technology. After we’re done exploring some terminology and examples, we’ll jump right in and start working with XML documents. Then, we’ll spend some
Building Object-Oriented Database Interfaces in PHP: Working with Multiple Data Access Objects
(Alejandro Gervasio) Here we are again. Welcome to the third part of the series “Building Object-Oriented Database Interfaces in PHP.” I’m pretty sure that you’ve been working for a while with the concept of database interfaces explained in my previous articles, playing around with the source code d
Database Modeling Using Visio
(Steve Callan) A previous article covered some of the features of Visio, “The Microsoft Office Business and Technical Diagramming Program.” One of Visio’s key features is its ability to reverse engineer a database, and in this article, we will take a look at doing exactly that using the sample schem
A Brief Guide to High Availability Deployment
(Greg Sowa) High availability versus cost of implementation is a classic tradeoff when creating an effective deployment environment. Oracle Application Server 10g offers flexibility in deployment configurations, which can closely match designing goals set by system architects. To simplify the choice
More on DB2 Performance on Linux
(Chris Eaton) After my last posting about DB2 on Linux running on pSeries some people have asked me about other results for DB2 on Linux so I thought I would take a second to direct folks to results of DB2 on Linux on other platforms as well.
Export or import with Oracle Data Pump
(Scott Stephens) In Oracle 10g, exp and imp have been redesigned as the Oracle Data Pump (although Oracle still ships and fully supports exp and imp). If you’re used to exporting exp and imp, the Data Pump command-line programs have a syntax that will look very familiar.
SQL Essentials: SQLCMD in SQL Server 2005 Beta 2
(Ron Talmage) SQLCMD is SQL Server 2005’s new command-line query tool that, for all practical purposes, not only replaces osql, but also offers an alternative to the graphically oriented SQL Server 2005 Management Studio. You can run queries interactively in SQLCMD (as you can with isql and osql
Performance of ASP.NET Web Services, Enterprise Services, and .NET Remoting
(Ingo Rammer and Richard Turner) Compare and contrast performance characteristics of real-life ASP.NET Web services, .NET Enterprise Services components, and .NET Remoting components, and get recommendations on how to best use these technologies.
Optimizing SQL Server 2000 settings
(Hilary Cotter) SQL Server does well configuring itself for optimal performance, more so than any other RDBMS on the market today. However, there are several settings you must modify to squeeze extra transactions per minute (TPM) out of your servers. The purpose of this tip is to discuss these s