In order to make the DBA’s job quicker and more professional, many database administrators are using third party solutions. At the same time, IBM is working hard to improve their own tools. Marin Komadina lines them up, giving us the pros and cons to each.
(John Cox) High-volume database updates, which are the essence of transaction-processing applications, remain anchored on products such as Oracle’s 9i and IBM’s (NYSE: IBM) DB2 Universal Database, and increasingly Microsoft’s (Nasdaq: MSFT) SQL Server. But there are a host of new application areas t
By Ellen O’Brien – In response to the growing demand for database administrators and the emergence of increasingly complex IT environments, IBM has created new exams to accelerate DB2 v8 certification and recognize areas of DBA expertise.
The XML Wrapper Generator is a graphical tool that enables rapid and automatic integration of XML data sources into a DB2 database using the XML Wrapper. This tool loads XML schema files, “shreds” them to a relational schema, and generates appropriate NICKNAME and VIEW statements.
Free registration on IBM developerWorks is required for this tutorial on the Python API for IBM DB2. My favorite language and my favorite non-OSS RDBMS. Certainly worth the look.
Think you can get UNICODE support from IBM’s DB2 ODBC driver on UNIX? Nope. In order to provide UNICODE support for a database, the driver must both support UNICODE and be compatible with the database. Learn more here.
Alexander Chigrik compares SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits.
Steve Mills, IBM’s senior vice-president and group executive in the IBM software group, touted the strength and popularity of IBM product lines during a keynote speech at the IBM developerWorksLive conference. He said, for example, that the WebSphere applications platform has 50,000 customers, that
Taken from real life experience, author Alexander Kuznetsov shows you some simple tips to make sure the optimizer makes good decisions for your queries.
The purpose of this paper is to describe the Version 7.1 release of the BMC Software administrative Products for DB2 for OS/390. We will highlight the features that are supported in Version 7 of the IBM DATABASE2™ Universal Database Server for OS/390 and z/OS, and explain how the BMC Software Databa