(Ron Talmage) Split-mirror backup technology can help you achieve higher database availability by letting you back up the database very quickly, typically in a matter of seconds. This speed lets you make database backups more frequently. Also, you can restore a database from a split-mirror backu
Other News
Handling transactions using Enterprise Beans, Session Beans and DB2
This tutorial helps developers handle multiple transactions using Entity Beans and Session Beans with DB2 Universal Database. We build a sample account-based enterprise application, which transfers amounts from one account to another in a single transaction. We implement our application using En
FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later
After you apply the hotfix that is described in Q825042 or any other hotfix with SQL Server version 8.00.0840 or later, calls to the xp_logininfo procedure may fail with error 8198 and you may receive an error message that is similar to the following: Error: 8198, Could not obtain information abo
Multi-Server Administration
(Robert Marda) Multi server administration allows you to create jobs and maintenance plans once, on a server designated as your master server. All jobs and maintenance plans created on the master server can then be executed on any server enlisted as a target server to your master server. Job statu
Database table to XML and back
(Sreekumar S.) This article is about generating XML files by reading data from Paradox tables and inserting the same data back in to the same table by reading data from the previously generated XML file (or any database which can be accessed with Delphi). The code won’t work for tables with memo fie
Oracle DBA Scripts: How to manually setup master-slave replication in Oracle 9i
The following procedure describes how to manually setup master-slave replication with materialized view (materialized log) in Oracle 9i. I found using OEM tool to configure a Read-only Materialized View Replication with only one mater site created some unwanted objects and jobs. The Oracle Repli
DB2 and Java: The Big Picture
IBM DB2 Universal Database (UDB) supports all the key Internet standards, making it an ideal database for use on the Web. It has in-memory speed to facilitate Internet searches and complex text matching combined with the scalability and availability characteristics of a relational database. DB2 UDB
Mastering Top-N and OLAP Queries in DB2
(Greg Nash) With the help of today’s Web integration and GUI tools, it’s now much easier to build reports without any programming. SQL provides GROUP BY and ORDER BY clauses, to collate and sort otherwise unordered data. But sometimes we want more flexibility.
XML-based Integration Techniques
(Kirstan Vandersluis) In order for a business to thrive in today’s dynamic world, its computing infrastructure must enable the secure flow of information-not only within the business but also with suppliers and customers. However, many of today’s computing infrastructures suffer from “information ch
DB2 Universal Database commands by example
(Sylvia Qi and Michael Dang) The DB2 UDB SQL Reference and Command Reference manuals tell you the syntax for all the DB2 commands, but these manuals do not always have examples of each command. These “cheat sheets” provide examples of commands going against the SAMPLE database (in either partitioned