You can shoot yourself in the foot using DB2 if you are not careful. There are options that you can specify that may cause you to read data that is not really in the database. And, alternately, you can set things up so that you miss reading data that is actually in the database.
Read this article..
Craig Mullins
Craig S. Mullins is a data management strategist, researcher and consultant. He is president and principal consultant of Mullins Consulting, Inc., and has nearly three decades of experience in all facets of database systems development.
Craig has worked with mainframe DB2 since V1 and has experience with several other DBMS products, including SQL Server, Sybase and IMS. You may know Craig from his popular books:
DB2 Developer's Guide, which has more than 1,500 pages of in-depth technical information on DB2 for z/OS, and
Database Administration: The Complete Guide to Practices and Procedures - the industry's only comprehensive guide to heterogeneous database administration.
More information on Craig is available at
www.craigsmullins.com.
comments powered by