(Robert Catterall) In DB2 for z/OS circles, there has been an evolution of attitudes concerning Linux on System z. Back around 2003, when I was on the user side of the DB2 community, I was part of a team charged with developing a plan for the simplification and streamlining of my company’s IT infras
Tag: IBM
DB2 best practices: Managing data warehouse performance with IBM InfoSphere Optim Performance Manager
(Gary Murtagh and Garrett Fitzsimons) This paper is targeted at those who are involved in implementing IBM InfoSphere Optim Performance Manager (OPM) 5.1 in a data warehouse environment that is based on DB2 for Linux, UNIX, and Windows V9.7 (DB2 9.7) software. In particular, this paper focuses on th
Oracle to DB2 Conversion Guide: Compatibility Made Easy
(Nick Ivanov, Romeo Lupascu and Olaf Mueller) This IBM Redbooks publication describes IBM DB2 SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQ
DB2 Advantages Over Oracle in Compression
I have previously posted about compression and the new adaptive compression capabilities in DB2 10. In this posting I want to clearly articulate why DB2 is the leader in compression capabilities and how this translates into big savings for clients along with big performance gains for database worklo
Interpret IBM InfoSphere DataStage and QualityStage Operations Console metrics
(Arron Harden, Len Greenwood, Geoff McClean, Julian Vizor and Eric Jacobson) This article looks into the metrics and statistics presented in the IBM InfoSphere DataStage and QualityStage Operations Console. This includes descriptions of how the values are generated (or where they are read from) and
Error on Installation of DB2 /tmp/…: Permission Denied
(Ember Crooks) I haven’t actually personally installed DB2 in about a year. We scripted it out, and I’ve been spoiled to just use the script. But now we have a custom server that varies enough from our standards that I’m installing it manually. The OS is Red Hat 6.2.
DSNTIJNH and Catalog Conversions
(Troy Coleman) This question was recently posted on Linkedin’s DB2 10 for z/OS group: “Has anyone tried taking their time to going from DB2 V10 ENFM mode and has issues with vendor tools?”
Implementing Java integration components for IBM Business Process Manager V7.5.1
(Ricardo Olivieri) Learn how to write Java integration components for business process applications in IBM Business Process Manager V7.5.1. Depending on the functional or non-functional requirements of the business process application that you are implementing, you may find that none of the out-of-t
Auditing DB2 Changed Data
(YeeKai Lai) This is an introduction to a frequently used but seldom hyped feature of DB2 data replication.
DB2 Tech Talk: Part Two Certification Prep for DB2 10 for Linux, UNIX and Windows Fundamentals Exam
(Cindy Russell) This is part 2 of a two-part Tech Talk designed to get you started on preparing for the all-new DB2 10 for LUW Fundamentals 610 Exam.
