(Paul McInerney and Danny Zilio) Get expert help with designing data partitioning keys, materialized query tables, and multidimensional clustering for IBM DB2 Universal Database (DB2 UDB), in addition to indexes. The Design Advisor offers the help you need and is built right into DB2 UDB. Part 2 of

(Lee Kroon) IBM will officially unveil Version 7 of its Lotus Notes and Domino family of products. Though the much-anticipated software will build upon the technologies that Notes customers have long used, it will also offer increased integration with IBM’s DB2 and Workplace products. That integrati

(Kyle Chard) IBM WebSphere Information Integrator OmniFind Edition provides proven enterprise search technology capable of indexing vast collections of enterprise data. Presently OmniFind incorporates a Java-based API to provide application developers a direct connection to an OmniFind instance.

(Romney Kernek) These two viewlets provide a detailed process for installing DB2 Records Manager, V4.1. The viewlets are designed for use on a single Microsoft Windows machine installation, but may help with a AIX installation also. The first viewlet provides the installation process for the base RM

(Wei-Dong Zhu, Claus Heisterberg-Andersen, Marcelo Takashi Souza, Jaco van Straaten and Rob Weaver) This IBM Redbook covers IBM DB2 Content Manager for z/OS Version 8.3 implementation, installation, and migration. It is intended to be used in conjunction with the product publications. In many areas,

(Ken Milligan) keep getting the error message of null values not allowed in column or variable ZORD#T for SQL update (using V5R3): UPDATE Z9519 A SET A.ZORD#T = (SELECT COALESCE( B.ZORD#T, A.ZORD#T ) FROM Z9517 B WHERE A.ZADES1 = B.ZADES1 AND A.WHS=B.WHS) (R)

(Howard Fosdick) Every now and then I hear a blasé certification candidate tell me that hands-on experience isn’t necessary to pass the DB2 UDB (and other IBM) certification tests. Nothing could be further from the truth. Although there may be cases in which people pass the tests while treating them

(Dorian Birsan and Christina Lau) In this twelth article in the series, you learn how to use IBM DB2 Alphablox to generate reports showing historical data about your Business Process Execution Language (BPEL)-based business processes running on IBM WebSphere Business Integration Server Foundation V5

(Adrian Lee, James Magowan, Patrick Dantressangle and Fabian Bannwart) Explore the architectural gaps that exist between the WebSphere Information Integrator and a data grid built using the Open Grid Services Architecture Data Access and Integration (OGSA-DAI). Then download Grid Wrapper for WebSp

(Rita-Lyn Sanders) Vector Aerospace knew it had something when it created Navixa, the operations management software that helps it track the repairs it makes to customers’ helicopters and fixed-wing aircraft. So the Canadian company decided to take it live and spun off Pathix ASP, a software develop