(Morris Lewis) For at least 50 years, magnetic tape has been the medium of choice for long-term data storage, and nothing is likely to completely replace tape in the near future. However, increasingly, organizations are backing up databases to a hard disk before copying the file to tape because the
Other News
Using the XML Features of the Excel 2003 Object Model
(Frank Rice) Microsoft Office Excel 2003 adds a number of significant features for working with XML data. This article explores the XML-related objects, methods, and properties for Excel 2003 and provides code samples illustrating their use. After completing this article, you will have a better
Correlating Application and Database Processes in DB2 V8: Basis For Enhanced Accounting and Workload Management
(Namik Hrle and Johannes Schuetzner) A precise correlation of work done in DB2 on behalf of the application process is the basis for efficient monitoring, accounting, charge-back, capacity planning and workload management. For example, systems administrators should not, in general, terminate a
Monitoring DB2
(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica
EXPLAIN Plan Workaround
(Jaromir Nemec) The general rule for performing an explain plan is that you can perform the explain plan only if you have sufficient privileges to execute the statement. It means with only read rights you cannot explain, for example, an INSERT statement or any other DML statement.
Tuning Where it Counts: Optimizing Oracle E-Business Suite Performance
(John Spirko) Uncover ways to properly tune your Oracle E-Business environment and learn how to detect, diagnose and resolve top areas of contention throughout the application. This Webcast delivers: • A primer on where Oracle E-Business transaction breakdowns are likely to occur (from the concur
MDX Essentials: Numeric Functions: Introduction to the AVG() Function
(William Pearson) In this lesson, we will introduce a commonly used numeric function in the MDX toolset, the AVG() function. The general purpose of the AVG() function, as we shall discover, is to return the average of the tuples occupying a set. We will consider elementary uses of the function in th
Introduction to Web Services Technologies: SOA, SOAP, WSDL and UDDI
(Thomas Erl) This sample chapter delves into the concepts and technology behind Web services, including Web services and the service-oriented architecture (SOA), Web Services Definition Language (WSDL), Simple Object Access Protocol (SOAP), and Universal Description, Discovery, and Integration (UDDI
Comparing the Distributed DB2 UDB Servers
(Paul C. Zikopoulos) In a side-by-side comparison table, This article makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 Universal Database (DB2) server family.
Lightweight XML Editing in Word 2003
(Evan Lenz) Did you know that Word documents can be saved in XML format? As of Microsoft Office 2003, the second option in Word’s Save As dialog–right under “Word Document (*.doc)”–is “XML Document (*.xml)”. This format is Microsoft’s own XML vocabulary for Word documents, called Wordprocessin