What are some of the things you need to learn, and what things do you need to do to learn them? What follows is my list of the tools, techniques and process of building your DB2 expertise.
Imagine a student who has taken a few semesters of a foreign language – they have covered the basics of reading, writing, and conversation. They have learned about the culture of the lands that speak the foreign language. Are they fluent? No. Could they pass as a native on the street? Probably
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.
When dealing with DB2 it is first important to understand which member of the DB2 “family” you are working with. While the DB2 brand is used on a variety of platforms the underlying infrastructure is somewhat different on each.
Check out this presentation by Joe Burns of Highmark that outlines some solutions to common problems with SQL.