Have you considered how the latest database technology can improve your development productivity? If so, the database that has helped many developers is DB2 UDB – for mixed environments including Linux and Windows. There are many new features available to developers and DBAs in the next release of D
Other News
Troubleshooting Common Problems with the XmlSerializer
(Christoph Schittko) The XmlSerializer in the .NET Framework is a great tool to map strongly structured XML data to .NET objects. The XmlSerializer performs the transformations between XML documents and objects in your program with a single API call. The mapping rules for the transformation are expr
Smile and Take a Snapshot
(Howard Goldberg) Monitoring the health of an UDB instance and its associated databases is one of the many tasks that a DBA must perform on a daily basis. One of the tools a UDB DBA uses is the DB2 "get snapshot" commands. These commands obtain a point in time snapshot of the database’s critical per
How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2
Microsoft Windows XP Service Pack 2 (SP2) includes Windows Firewall. Windows Firewall is an enhanced version of Internet Connection Firewall (ICF). By default, Windows Firewall is enabled on computers that are running Windows XP Service Pack 2. Windows Firewall will block some network connections th
Performing Usage-Based Costing
(Brian Moran) My company wants to charge application owners usage fees based on consumption of database resources, such as memory, CPU, I/O, the number of queries executed, and so on. Several third-party tools have this capability, but their data is based on sampling. We have many applications t
XML Processing with DOM and Perl
If you iterate recursively over a DOM tree (such as one provided by the XML::DOM Perl module), you need something like a computed goto to dispatch on node types, and, probably more important, different elements. For example, consider the structure-oriented DTD from Notes on XML DTD Design (including
Creating XML with Genx
(Michael Fitzgerald) Genx is an easy-to-use C library for generating well-formed XML output. In addition to being well-formed, Genx writes all output in canoncial form. It was created by Tim Bray with help from members of the xml-dev mail list. Work on Genx was announced on xml-dev on 19 January
Use RDDL with your XML and Web services namespaces
(Uche Ogbuji) The spaghetti of namespaces in, say, a WSDL file can lead to a lot of confusion. Resource Directory Description Language (RDDL) packages information on a namespace. If you use URLs for namespaces, use RDDL as described in this article to provide useful guides to users of your XML docum
MSSQL Server 2000 Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data
(William Pearson) In this article, we will introduce the details of another option within the Managing phase of the reporting lifecycle, the Data-Driven Subscription. To examine the steps involved in creating a Data-Driven Subscription effectively, we will need to create an environment that will sup
Asked and Answered (Disaster Planning)
As part of our disaster recovery procedures, we try to get the (4-way) DB2 data sharing group up and certain critical applications running within the first 2 hours after a disaster has been declared. To accomplish this we have the following: –A dedicated MVS logical partition (LPAR) running at