(Jeffrey Benner) I just wrote a small Unix script-based db2audit capture system for one of my version 9 DB2 databases. Let me tell you about it.
Tag: IBM
DB2/400 Storage Engine for MySQL Now Available as Public Beta
(Alex Woodie) MySQL and IBM last week started a public beta for the new DB2 for i (IBMDB2i) Storage Engine for the MySQL database, a long-awaited product that will allow System i shops to care and feed for their MySQL-based PHP applications running on their i OS server just as they do for ordinary D
TechTip: How to Secure the Web Query Login Page (or Any Other Web-Based Application)
(Robert Andrews) The IBM i is a great platform for running Web applications. These applications can take advantage of Apache, PHP, and MySQL, all running natively on IBM i. Or you may be using a purchased application such as DB2 Web Query for IBM i. One common thread amongst them is that they can us
Understand IBM InfoSphere MDM Server Security, Part 5: Integrating Master Data Management Server with Tivoli Federated Identity Manager
(Miguel A Ortiz, Jr. and Patrick Wardrop) This article builds on Part 4 of this series, “Using SAML in MDM Server Security,” and shows how the integration of IBM InfoSphere Master Data Management (MDM) Server and IBM Tivoli Federated Identity Manager (TFIM) can extend MDM Server’s identity propagati
Hundreds of indexes on a single XML column – why not?
(Henrik Loeser) Last week I presented at the German Database Conference “BTW” (see here for a history) some work on how to address XML Index Challenges (paper written with two colleagues). More and more enterprises face the challenge of logging all their activities. Given that today SOA and Web Serv
Claims and Drains on the Main(frame)
(Robert Catterall) It’s nice when knowledge gained some time ago becomes useful again in a new context. Take DB2 for z/OS drain locking. This technology was delivered in the mid-1990s, I think via DB2 V3 – though it may have veen V4. In any case, drains – and their counterpoint, claims – were initia
Cloning a WebSphere Portal V6.1 installation
(Marshall Lamb and Walter Hänel) This article describes how to clone an installation of IBM WebSphere Portal V6.1 that has been configured specifically for certain deployment needs. The intended audience is portal administrators who would like to build a standardized installation of WebSphere Portal
Avoid the Hassle of Accessing DB2 Data from .NET Applications
(Chris Smith) If you’re a .NET programmer developing applications that need to access data in DB2 for i, you might be concerned that the middleware you’re using to reach that data will slow things up so much that performance will suffer.
DB2 9 for z/OS: Packages Revisited
(Paolo Bruni, Sean A. Dunn, Howard Hirsch, Norihiko Nakajima and Suresh Sane) DB2 packages were introduced with DB2 V2.3 in 1993. During the 15 years that have elapsed, a lot has changed. In particular, there is a more widespread use of distributed computing, Java language, new tools, and upgrades i
DB2 9.5 SQL Procedure Developer exam 735 prep, Part 4: Triggers
(Hareendranath Kattana and James Merry) Gain an understanding of the fundamental concepts behind IBM DB2 triggers — when, how, and what kind of triggers can be used under various circumstances, the required user privileges, and deployment scenarios. This tutorial is Part 4 of a series of tutorials d
