(Branham Group) This is a report prepared by Branham Group Inc. that compares the two leading commercial database software packages for Linux: Oracle 9i version 9.2 Enterprise and IBM DB2 version 8.1.2 ESE. Comparison is based on cost of ownership, ease-of-use, reliability, and scalability. The resu
Tag: IBM
SAP, Sybase ally for smaller business
(Mike Ricciuti) Software maker SAP said that it has partnered with Sybase to use the company’s database management software with its business applications. The deal is seen as a blow for Microsoft, which has been the primary database supplier for SAP’s Business One set of applications that are t
Quick and Dirty RDBMS Tuning
(Steven Hauser) Oracle tuning. Informix tuning. DB2 tuning. PostgreSQL tuning. It doesn’t matter which database you use — RDBMS tuning is all pretty much the same, because database software is all pretty much the same these days. All major relational database systems have an engine, an optimize
DB2 stored procedures and dynamic cursors
(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce
Leverage your Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8
(Raul F. Chong) In the world of information technology today, we are constantly bombarded with new information — new software products, new versions, new features. Leveraging your current knowledge is one way to keep up with this constant change. This article shows you how you can use your cur
Using TIMESTAMP Columns Versus DATE and TIME Columns
(Craig S. Mullins) A frequent requirement of applications is to store date and time information in the of a DB2 table. The date and time data may be required for any number of reasons, such as: –To record the date and time the row was added to the table –To act as the primary key for the row
Take a Load Off: Archive Inactive Data
(Bryan F. Smith and Thomas A. Vogel) A data explosion threatens to bog down, fill up, slow, and generally complicate DBMSs. Archiving data that’s rarely accessed lets businesses hold on to the data they need while keeping DB2 performing at top speed.
Replication Agent zaps for DB2 Versions 10.5
The Following four zaps should be applied to all versions of the Replication Agent for DB2 Versions 10.5 and below: (PDR10008) Abends0c9/abends0c4 in DRL@LOGX when trying to bring the PLATINUM Replication Extract back up after a DB2 crash. After a DB2 crash followed by a normal restart, DB2 w
Combining Triggers and UDFs
(Kulvir Singh Bhogal and Kwang Sik Kang) Ever notice how DBAs in large enterprises are frightened by the thought that their data is being manipulated by applications without their knowledge? They may not like it, but it’s an inescapable reality. This article outlines how to use triggers and UDFs
How to Build a Metadata Bridge for DB2 Cube Views
(John Poelman) The target audience for this article are technical managers and staff who are interested in developing or integrating OLAP applications on top of IBM® DB2® Universal Database™ V8 (UDB) using the DB2 Cube Views application programming interface (API). The information is especially rele