DB2 (R) Universal Database for OS/390 v7.1 Certification Guide

Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 environments is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging DB2 for OS/390 certification exam. Full of useful tips, practical techniques, and expert guidelines, it covers virtually every aspect of working with DB2 UDB in OS/390 and z/OS environments: administration, connectivity, middleware, development, and much more. Richard Yevich and Susan Lawson begin with a detailed introduction to the DB2 UDB product family, the DB2 environment, and essential DB2 access controls, including subsystem access, access to DB2 objects, and auditing. In Part II, the authors introduce SQL, reviewing data structures, database objects, basic database design, and advanced SQL techniques for OLAP and other applications. Yevich and Lawson present in-depth coverage of DB2 UDB administration: maintaining and sharing data; database monitoring, tuning, and recovery; and more.