(Roman B. Melnyk) The IBM DB2 Universal Database (UDB) command line processor (CLP) is a convenient interface for accessing DB2 functions. Explore the three modes in which the CLP operates, get a detailed explanation of the db2 command, and learn some recent usability enhancements that are sure to p
Other News
Backing Up Databases Using ADSMPIPE and the TSM API: Examples Using Linux
This IBM Redpaper describes how you can use the IBM Tivoli Storage Manager (TSM) application programming interface (API) with the ADSMPIPE utility to perform online backups of various databases. This process eliminates dumping data to a file (and consuming disk space) so that the TSM backup and arch
PHP Co-Creator Sees Scripting Gaining in Enterprise
(Andi Gutmans) In the wake of improvements in PHP tools, new administration and even fresh investor money from SAP and Intel, 2005 is shaping up to be a milestone year for PHP. Co-creator of PHP and founder of Zend Andi Gutmans, shares his views with Open Enterprise Trends on why enterprise IT manag
Models with Character
(Micah Dubinko) The xml-dev list is famously filled with disagreements; often long-running, occasionally contentious permathreads. A casual glance might reveal someone cursing out namespaces, debating strong versus loose coupling, or passionately arguing for changes to the core of XML. And that’s ju
Working with the Enterprise Library’s Data Access Application Block
(Scott Mitchell) One of Microsoft’s efforts over the past couple of years has been to provide developers with useful code libraries that illustrate best practices. I discussed Microsoft’s latest foray into this arena in an earlier article, An Introduction to the Microsoft Enterprise Library. The
UML Integration Reaches Impressive Degree
(Peter Coffee) Supporting collaborative software efforts requires skill and effort in identifying relationships, avoiding misunderstandings and building a sense of shared commitment to mutual goals—what some might call, popularly if not rigorously, “right-brain” tasks.
OGC Launches Initiative to Support GML Metadata Encoding in JPEG 2000 Image Files
In February 2005 the Open Geospatial Consortium (OGC) launched a new Encoding Interoperability Experiment relating to the use of the Geography Markup Language in JP2 (JPEG 2000) image files. The goal is to support a standardized mechanism for inclusion of geo-referencing information as XML-encoded m
Thinking XML: State of the art in XML modeling
(Uche Ogbuji) The running theme of the column has been semantic transparency: the ability to correctly interpret the contents of XML documents. Semantic transparency might be the most important aspect of XML modeling. This is first in a series of articles that review the many different approaches to
An Interview with Michael Rys on Xquery, SQL Server 2005, and Microsoft XML Technologies
Dr. Michael Rys is the Program Manager for the SQL Server Engine Team at Microsoft. In this role, he has responsibility for many of the XML initiatives in Microsoft SQL Server, including the XQuery support in the upcoming SQL Server 2005, codenamed “Yukon”; Microsoft’s server-side SQLXML technology;
FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
In SQL Server 2000, differential backups may not contain Page Free Space (PFS) pages if the following conditions are true: • The PFS page was allocated between the last full backup and the differential backup. • The PFS page allocation was part of a file growth that is larger than 64 MB.