Publisher's Synopsis
*IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide!*The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide*Covers administration, security, SQL, application development, tuning, and much more*Contains dozens of expert DB2 tips, techniques and guidelines*CD-ROM contains complete DB2 for OS/390 sample examWritten by IBM Gold Consultants for DB2 and S/390 *The total resource for every professional running DB2 UDB V7.1 in OS/390 and z/OS environments*Database administration, security, monitoring, tuning, SQL, and application development*Sample test questions help you prepare for IBM's new DB2 UDB V7.1 for OS/390 examsThe CD-ROM included with this book contains a complete IBM DB2 for OS/390 certification sample exam.IBM's DB2 Universal Database Version 7.1 for OS/390 delivers unparalleled performance, scalability, and reliability in today's enterprise e-business environments! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments--and preparing for IBM's updated DB2 UDB V7.1 for OS/390 certification exam!Direct from IBM, this compr;Full of expert tips, techniques, and guidelines, it covers virtually every aspect of working with DB2 UDB in enterprise server: administration, connectivity, development, and much more. IBM Gold Consultants Richard Yevich and Susan Lawson present start-to-finish coverage of DB2's latest and most powerful enhancements, tools, and utilities, showing how to make the most of DB2 running on both OS/390 and next-generation z/OS platforms.;Coverage includes: *An overview of the DB2 UDB product family*DB2 in OS/390 and z/OS environments: address spaces, attachments, interfaces, commands, and utilities*Comprehensive security coverage, including access controls and auditing techniques*SQL in depth: DB2 data structures, database objects, basic database design, and advanced coding*DB2 UDB administration: maintaining data, backup/recovery, and more*Performance monitoring and optimization: access paths, indexes, parallelism, buffer pool tuning, and subsystem tuning*Data sharing: architecture and implementation in a Parallel Sysplex environment*Detailed application development coverage: database extenders, cursors, stored procedures, triggers, object-relational extensions, locking, and concurrencyWhether you're deploying DB2 UDB V7.1 in an OS/390 environment, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, DB2 Universal Database Version 7.1 for OS/390 Certification Guide will be your single most valuable resource.