(Ehab AbuShmais) In the past, accessing U2 SB+ for UniData and UniVerse security from outside of SB+ security screens was difficult. But now, you can use a new function, SH.SEC.API, to talk to SB+ security using routine calls when outside of SB+ security screens and reports. SB+ Release 5.4.0 makes

(Willie Favero) DB2 9 is fascinating. The more you read about it, the cooler the stuff is that you find out about. This post is about a feature I have seen little to nothing published about it so far. Granted, it’s pretty simple feature and extremely straightforward. However, it’s still pretty cool

(Willie Favero) The first IBM webcast cover DB2 9 for z/OS since DB2 9 went GA is this week, Tuesday, April 3, 2007. It is scheduled for 11:00 am EDT, 10:00 am CDT, 8:00 am PDT. You can register for this webcast at http://www.ibm.com/software/os/zseries/webcast/apr03/.

(Paul McDougall) IBM is beefing up its ongoing efforts to lure users of a rival product over to its own open source server software.

(Allen Dreibelbis, Eberhard Hechler, Bill Mathews, Martin Oberhofer and Dr. Guenter Sauter) Master Data Management (MDM) brings you a methodology for maintaining consistent data across diverse business functions. This article describes the taxonomy of Enterprise MDM-related architecture patterns. Af

(Rufus Credle, Kim Clark, Ge Yun Peng, Hatcher Jeter, Joao Lopes, Samir Nasser and Kailash Peri) The Patterns for e-business are a group of proven, reusable assets that can be used to increase the speed of developing and deploying e-business applications. This Redbook focuses on the use of the WebSp

(David) Today I have noticed a strange phenomena in one of our DB2 databases. When doing a low zero-selectivity query (that is, query without a WHERE clause), the DB2 optimizer preferred to use an index scan rather than do a table scan.

(Scott L. Forstie and Sue Romano) A new i5/OS SQL set option for use with DB2 enables better control of SQL cursor scoping. Learn about the new CLOSQLCSR option, why it is important, and how to use it. Also discover pointers to SQL procedures, triggers, and functions (PTFs) that you can use to run t

(Damon Anderson) Need a matrix of tables and the plans and packages that use them? How about a technique to avoid mass deletes and inserts? Or, how about a REXX program that retrieves all of your subsystem parameter values and puts them into a data set in a nicely formatted list? If so, read on for

(Susan Visser) IBM’s new Dynamic Warehousing initiative was recently unveiled. IBM is the first to fully understand and define this next generation of data warehousing. Only IBM can deliver all of the Dynamic Warehousing capabilities with a product portfolio that is best in class. Read the Dynamic W