When dealing with a database, it is important to understand the “DB2 catalog” concept. The catalog is a set of DB2 tables that store the DB2 system state. Almost every action that takes place in DB2 is reflected in a change to one or more catalog tables.
Today volunteer Eddy Coppens of SuadaSoft, talks about his experience of migrating DB2 for LUW, while at the same time changing the collating sequence, resulting in a complex migration project.
In this month with focus on "legacy migration" we last week focussed on the interaction between new technologies and DB2.This week we'll put the focus on migrating to a new release of DB2, both and z/OS and LUW. The first article deals with rebinding after migrating on DB2 for z/OS.
As DB2 reaches its 30th anniversary and IDUG reaches its 25th anniversary, I’ve thought about many DB2 tips and best practices that have been incorporated by companies, projects and applications that have led to great successes. The ones that have been most common and have had the greatest impact a
Performance applies to people as well as processes. DBAs need to keep on their toes, take on all sorts of responsibilities, and keep themselves current. Robert Goodman of Florida Hospital tells us how to be a highly effective DBA!