(Bernie Spang) When the Informix team brainstormed about to how to sum up the values of Informix 11.7, we had a tough time getting it down to just one line. Some wanted to focus on the peace of mind that Informix offers its users and the new features that provide even greater reliability and flexibi
Tag: IBM
Speeding up LOBs
(Serge Rielau) Without much fuss Large Object (LOB) support has gotten a big overhaul in DB2 9.5 and DB2 9.7.
Performance Tune IBM DB2 z/OS Applications using Resource Constraint Analysis
(Lockwood Lyon) For the DB2 for z/OS professional the two most common systems tuning scenarios are tuning a DB2 data sharing group or tuning a series of application SQL statements. The data sharing group environment can involve multiple hardware installations and many other cross-system features and
IDUG Europe and DB2 Java Performance
(Dave Beulke) Sleep is over rated. Sleepless from too many time zone changes from clients to then jumping on a plane and presenting at the IDUG conference in Vienna was great but a challenge. The baby two seats away from me had a bad flight over and I felt so sorry for Mom trying everything to stop
What ‘pureXMLness’ do you have…?
(Henrik Loeser) The longer and the more intense the work with XML in a database system of your choice (this is DB2, right?), the more often comes the question: What pureXMLness do I have?
Get the most out of DB2 optimizer
(Samir Kapoor and Vincent Corvinelli) The access plan that the IBM DB2 SQL optimizer chooses can significantly influence the execution performance of a SQL statement. In this article, you learn, through examples based on actual scenarios encountered by DB2 users, how to analyze access plans, and tun
The Art of Bufferpool Tuning
(Troy Coleman) I’ve been asked to write about bufferpool tuning. Though it’s been years since I’ve had the responsibility of tuning DB2 bufferpools, I’m happy to oblige.
Another comprehensive win for DB2 9.7 over Oracle Database
(Laura) The latest report from our DB2 9.7 Vs Oracle Database 11g ease of use study shows that DB2 is a massive 50% less complex than Oracle Database for performing Data Compression.
Configure and monitor CLI applications with Optim Performance Manager Extended Insight
(Sonali Kenge) Optim Performance Manager Extended Edition provides end-to-end database performance monitoring capability for DB2 call level interface (CLI) applications with its extended insight capability.
DB2-Oracle terminology mapping
Because Oracle applications can be enabled to work with DB2 data servers when the DB2 environment is set up appropriately, it is important to understand how certain Oracle concepts map to DB2 concepts.
