(Mark Wilding) Maximo in the cloud using DB2! Maximo is IBM’s Enterprise Asset Management technology and I just happen to work in the same office as a very talented Maximo hosting team. The Maximo hosting team recently put Maximo on Amazon’s EC2 following in the footsteps of other IBM software.

(Thomas Sharp) This article provides information about using Optim Development Studio (ODS) to create, edit, deploy, and debug PL/SQL routines for DB2 Linux, UNIX, and Windows (LUW) Version 9.7, Oracle 10g, and Oracle 11g databases. It assumes you have basic knowledge of DB2 and Oracle, and are fami

(Willie Favero) Last week in my post “The magic triangle: stored procedures, WLM, and WLM started task” I discussed the relationship between the CREATE procedure DDL, the WLM environment definition, and the JCL Proc. Today, I want to talk a little more about last weeks topic plus get into the NUMTC

(Robert Catterall) I recently had the opportunity to work on an interesting challenge, involving the use of one DB2 system for both an online transaction processing (OLTP) and a business intelligence (BI) workload. Now, the system in question happened to be a DB2 data sharing group running on a para

(Manoj Mohan) This tutorial introduces the concepts of authentication, authorization, and privileges as they relate to IBM Informix Dynamic Server 11.50 (IDS). This article is the second in a series of nine tutorials designed to help you prepare for the IDS Fundamentals Certification Exam (555).

(Dave Beulke) As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations; improve application performance and overall availability of your systems and data.

(Troy Coleman) A few weeks ago in “A Morning Jolt for Response Times” I wrote about access database, the new DB2 command that’s used to force open datasets containing the table or index space. DB2 9 for z/OS also contains a set of commands for managing PROFILE tables used by optimization tools such

(Indrajit Poddar and Devaprasad Nadgir) Part 1 of this series describes multi-tenancy and several technical challenges faced by service providers for deploying multi-tenant web-delivered solutions. In part 4, we presented a technical challenge on how to enable multi-tenancy for existing single tenan

(Conor O’Mahony) There is an article at SearchSAP.com describing how SAP infrastructure changes to databases, servers yield quick returns. The article quotes Derek Prior of AMR Research who says that “some are finding it cheaper to swap Oracle databases in a more Unix-oriented environment to DB2” an

(Conor O’Mahony) Last week I described Why DB2 Data Compression is Better than Oracle Database. In my blog post, I focused on the reasons why the DB2 compression techniques get better compression rates than the Oracle Database compression techniques. In this post, I’d like to focus on a couple of re