(Willie Favero) I know that I’m posting this bonus APAR late on a Friday, and extremely late on a Friday for my European friends. It’s been on my “to do” list for weeks but I keep forgetting to do a write about it. It’s an APAR for the data sharing customers. It puts stuff back the way it used to […]

(Andreas Christian, Waldemar Gaida, Hans-Jürgen Moldowan and Thomas Rech) SAP migrations are a standard process nowadays. This IBM Redbooks publication describes optimization strategies and best practices for migrating SAP systems toward IBM DB2 for Linux, UNIX, and Windows, as well as for performin

(justinatime) For the past 2 days, I have been trying to restore a DB2 (version 8) database backup onto a new server with IBM Control Centre. Yeah, I know version 8 is no longer supported, but legacy systems still use version 8 and servers die.

(Branislav Barnak, Amir Bar-or, Cynthia M. Saracco and Paul Stanley) As more businesses rely on XML to represent and exchange business data, the ability to integrate XML operational data into data warehouses becomes more critical. The first article of this series explored how IBM InfoSphere DataStag

(Willie Favero) We’ve already done an APAR for Friday, and a fairly significant one at that in my opinion. This is going to be a bonus APAR that will probably be of interest to about the same number of people as this morning’s post. That doesn’t make it any less important.

(Antonio Cangiano) An easy way to improve the performance and security of SQL queries is to replace literals with parameters. By replacing literal values with parameters, advanced relational databases will be able to compile your queries and have their execution plans cached. This saves time and pre

Starting with version 6.1, IBM WebSphere Application Server leverages a component called Virtual Member Manager (VMM) to manage information about users, user profiles, and user groups. VMM offers a specific Service Provider Interface (SPI), com.ibm.wsspi.wim.Repository, to connect VMM with user repo

(Fernando Echeveste) In a previous TechTip, I introduced a new Override with Database File (OVRDBF) command option that allows an application that requires high velocity inserts to temporarily override the REUSEDLT(*YES) attribute of a physical file or table and effectively use the behavior of REUSE

I’ve used DB2 for years and it has proved to be a rock solid database, that is stable, performs well, has awesome features like HADR for high availability and with the Express-C edition you can use it for your own projects free of charge…..however …one of the frustrating things I have always found i

(Jeffrey S. Bohm) This tutorial continues your journey into IBM Informix Dynamic Server by discussing many of the objects that can be created and used inside of a database. Some of these objects include tables, indexes, triggers, and views. This tutorial discusses what they are, how they are used, a