IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and z/OS platforms An official IBM self-study guide for the DB2 UDB V7.1 Family Application Development Exam (#514) Expert DB2 programming tips, techniques, and guidelines from application development experts Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and more CD-ROM contains complete DB2 application development sample exam The definitive, authoritative guide to DB2 OS/390 application development certification Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and much more Includes a full section on object-relational programming and other advanced techniques Sample test questions help you prepare for the IBM DB2 UDB V7.1 Family Application Development Exam (#514) About the CD The CD-ROM included with this book contains a complete DB2 UDB V7.1 Family Application Development Exam (#514) sample exam. IBM DB2 UDB Version 7.1 for OS/390 and z/OS delivers unparalleled performance, scalability, and reliability in today's enterprise business environments. Now, there's a complete, authoritative guide to developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments--and preparing for the IBM DB2 UDB V7.1 Family Application Development Exam (#514). This comprehensive day-to-day guide to DB2 UDB application development is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging application development exam for the OS/390 and z/OSplatforms. IBM Gold Consultant Susan Lawson presents hundreds of useful tips, practical techniques, and expert guidelines for every facet of DB2 UDB application development and every stage of the development process for both OS/390 and z/OS platforms Coverage includes: Foundations for effective DB2 development, including an overview of the DB2 UDB product family and DB2 for OS/390 data structures SQL: basic concepts and coding techniques through advanced OLAP features, star schemas, and star joins Stored procedures, including the SQL procedure language and IBM's Stored Procedure Builder Best practices for application testing, debugging, and performance tuning The full range of DB2 development tools, including ODBC/CLI, Java(tm), COBOL, C, C++, REXX, CAF, CICS, and RRSAF Object-relational programming, including user-defined functions, user-defined data types, and triggers In-depth coverage of locking and concurrency Whether you're developing for DB2 UDB V7.1 in an OS/390 or z/OS environment, managing DB2 UDB V7.1 application development, preparing for DB2 UDB V7.1 Family Application Development, or all three, DB2 UDB for OS/390 Version 7.1 Application Certification Guide will be your single most valuable resource. IBM DB2 Series

PLEASE PROVIDE COURSE INFORMATION PLEASE PROVIDE

"The accompanying CD-ROM contains a complete trial version of IBM DB2 Universal Database Personal Edition version 8.1, for Windows operating environments, evaluation copy"--Back cover.

Straight from IBM, Advanced DBA Certification Guide and Reference for DB2 Universal Database v8for Linux, UNIX, and Windowsis the definitive guide to enterprise-class DB2 v8 administration - andthe onlyauthoritative self-study guide for IBM's new DB2 advanced DBA exam. Delivers proventechniques for enterprise-class security, user management, recovery, scalability, optimization,troubleshooting, remote administration, and more! CD-ROM: DB2 Universal Database v8 EnterpriseServer Edition trial version plus complete documentation.

IBM DB2 Universal Database V8 offers breakthrough availability, manageability, performance, and scalability. Now, straight from IBM, there's a start-to-finish guide to DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, including database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. Using real-world examples, this book shows how to take full advantage of DB2 V8's most powerful enhancements. Philip K. Gunning brings together IBM's best tips and techniques for saving time and money in every facet of database design, development, deployment, and administration. Coverage includes: bull; Leveraging DB2 V8's new Wizards, Advisors, and other automation/self-management features Using the enhanced DB2 XML Extender to build next-generation B2B applications Quickly creating Stored Procedures and UDFs with the new Development Center Exploiting multidimensional clustering, prefetching, materialized query tables, Java threading, and other performance improvements Using the DB2 improved monitoring and logging facilities Maximizing availability via online table and index reorganization and dynamic configuration Understanding the latest changes in the DB2 product family

Now, two leading IBM solution architects show you how to use DB2 to create flexible infrastructures that simplify the construction of any enterprise-class business solution.

& • Everything Java developers need to start building J2EE applications using WebSphere Tools for the WebSphere Application Server & & • Hands-on techniques and case studies: servlets, JSP, EJB, IBM VisualAge for Java, and more & & • Written by IBM insiders for IBM Press

-- The insider's guide to table structures, cluster configuration, and other optimization opportunities. -- Provides best practices techniques for installing, configuring, and optimizing DB2 in the Solaris Operating Environment. -- Covers the new Solaris Operating Environment security features to make your databases even more secure! -- Part of the IBM Press DB2 Series. This is the only IBM insider's reference and guidebook for making the most of DB2 in Solaris enterprise environments. Coverage includes: integrating Solaris and DB2 to build more secure database applications; working with DB2's management utilities in a Solaris environment; client/server communications under Solaris; special issues and opportunities associated with running DB2 Universal Database Enterprise Edition under Solaris, and much more! The authors explain configuring Solaris and DB2 failover support and provide expert tips and techniques for DB2/Solaris performance monitoring, optimization, and troubleshooting. If you manage or develop for DB2 on Solaris, this book is critical to your success -- and you can't find it anywhere else!

The book is an introduction to grid computing, a strategy central to IBM's plans to help organizations succeed through better sharing of resources. It includes case studies which demonstrate how organizations have success with grid computing across a variety of industries.

& • Details the JMS API, covering the latest version 1.1, and discusses application development based on IBM WebSphere implementations & & • Key coverage on WebSphere MQ, Websphere MQ Event Broker, JMS administration tasks, and common usage scenarios & & • Examples coding JMS in servlets, portlets, EJBs and communicating with non-JMS applications