In this comprehensive overview of DB2 10, for z/OS Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for.
We use Explain to find out the access path for a query. Jim Dee, from BMC shows you how you can compare the access path with previous versions of the query or package – comparing the estimated costs, and identifying those that have changed with a rebind.
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.
On oldie but a goodie by Dan Luksetich. All still relevant today.
Welcome to the DB2 Beginner's Blog! We are planning some great content for people who are new to DB2 on all platforms in any job responsibility.