DB2 9 for Z/Os Database Administration Certification: Certification Study Guide - Softcover

Lawson, Susan; Luksetich, Daniel

Softcover

ISBN 10: 1583470743 ISBN 13: 9781583470749

Verlag: MC Press, LLC, 2008

Inhaltsangabe

In order to become an IBM Certified Database Administrator - DB2 9 DBA for z/OS, you must pass two exams: DB2 9 Fundamentals Exam (Exam 730), and DB2 9 Database Administrator for z/OS (Exam 732)&;the primary focus focus of this book.

Written by two members of the team who participated in the actual writing of the exam, this specialized study guide covers every topic that you will need to know to pass Exam 732, including database design and implementation, operation and recovery, security and auditing, performance, as well as installation and migration/upgrade. But that is only the beginning. It also covers the new features of DB2 9 for both database and application development.

This comprehensive guide includes an extensive set of practice questions in each chapter that closely model the actual exam, along with an answer key with a description of why the answer is the correct one. No other source gives you this much help in passing the exam.

Whether you plan to take Exam 732 or just want to master the skills needed to be an effective database administrator on z/OS systems, this is the only book you&;ll need.

With the DB2 9 for z/OS Database Administration Certification Study Guide, you will:

&; Discover the changes to DB2 9 that you&;ll need to know in order to be successful when taking the exam

&; Learn how to effectively administer a DB2 database

&; Receive an explanation of every objective included on the test&;by someone involved in the creation of the actual exam

&; Find 85 practice questions based on the actual exam&;s format and approach, along with comprehensive answers to help you gain understanding

Publisher&;s Note: While this book covers much of the information needed to prepare for Exam 730, a far more in-depth review of topics specifically related to Exam 730 can be found in the MC Press companion book: DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders.

Über diesen Titel

Über die Autorin bzw. den Autor

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration. With more than 19 years experience in DB2, she currently works with several clients to help develop and implement some of the world&;s largest and most complex DB2 databases and applications. She is the author of DB2 High Performance Design and Tuning, DB2 for z/OS Version 8 DBA Certification Guide, and DB2 Univerisal Database for OS/390 v7.1 Application Certification Guide. Daniel Luksetich is a senior DB2 database administrator and has been in the information technology business for more than 22 years. He has been a COBOL and BAL programmer, DB2 system programmer, DB2 database administator, and DB2 application architect.

Auszug. © Genehmigter Nachdruck. Alle Rechte vorbehalten.

DB2 9 for z/OS

Database Administration Certification Study Guide

By Susan Lawson, Daniel Luksetich

MC Press

Copyright © 2007 Susan Lawson and Daniel Luksetich
All rights reserved.

ISBN: 978-1-58347-074-9

Contents

Title Page, 
Copyright Page, 
Preface, 
CHAPTER 1 - DB2 Product Fundamentals, 
CHAPTER 2 - Environment, 
CHAPTER 3 - Access and Security, 
CHAPTER 4 - Database Objects, 
CHAPTER 5 - Retrieving and Manipulating Database Objects, 
CHAPTER 6 - Advanced SQL Coding, 
CHAPTER 7 - Maintaining Data, 
CHAPTER 8 - Recovery and Restart, 
CHAPTER 9 - Data Sharing, 
CHAPTER 10 - Using SQL in an Application Program, 
CHAPTER 11 - Binding an Application Program, 
CHAPTER 12 - Application Program Features, 
CHAPTER 13 - Stored Procedures, 
CHAPTER 14 - Accessing Distributed Data, 
CHAPTER 15 - Advanced Functionality, 
CHAPTER 16 - Locking and Concurrency, 
CHAPTER 17 - Performance Monitoring and Tuning, 
APPENDIX A - DB2 Sample Database, 
APPENDIX B - Sample Exam Questions, 
APPENDIX C - Sample Exam Answers, 
APPENDIX D - References, 

CHAPTER 1

DB2 Product Fundamentals

In This Chapter

[check] DB2 9 for z/OS

[check] DB2 9 for Linux, UNIX, and Windows

[check] DB2 middleware, connectivity, and information integration

[check] DB2 application development

[check] DB2 administration

This chapter introduces you to IBM's DB2 family of products for System z, Linux, UNIX, and Intel platforms. DB2 has the ability to store all types of electronic information — traditional relational data and Extensible Markup Language (XML), as well as structured, semi-structured, and unstructured information; documents and text in many languages; graphics, images, and multimedia (audio and video); and application-related objects, such as engineering drawings, maps, insurance claim forms, and numerical control streams. In this chapter, we introduce IBM's DB2 and related Information Management products and describe some of the features and functions of each offering. All descriptions are based on Version 9 level of function.

The DB2 product family is an important part of IBM's Information Management software portfolio, which integrates data and enterprise content to leverage information on demand. Popular Information Management tools include WebSphere Developer for developing Java, PL/I, or COBOL programs or components, Rational software for architecture management, Service Oriented Architecture (SOA) development (integrated with WebSphere), and Tivoli software for distributed systems management.

As for application server software, IBM offers several types of servers depending on the business requirement, from message queuing with WebSphere MQ to Java-based transaction processing with WebSphere Application Server. Several other products use the WebSphere Application Server infrastructure, including WebSphere Host Access Transformation Services (HATS), WebSphere Portal, and WebSphere Business Modeler. The most popular IBM software servers are its data servers, specifically the DB2 family.

The DB2 family executes on pervasive devices and on Intel, Linux, UNIX, midrange, and mainframe servers. Supported operating environments include Microsoft Windows 2000/2003/XP/Vista, Linux, AIX, Hewlett-Packard's HP-UX, Sun Microsystems' Solaris, OS/400, i5/OS, VSE/VM, and z/OS. To ensure maximum performance, the DB2 code base is optimized for each platform. Common to all platforms is the SQL API, permitting applications written on one platform to access data on any platform. Internally, DB2 on i5/OS, VSE/VM, and z/OS differs from DB2 on the Intel, Linux, and UNIX platforms, but the common SQL API enables applications to work together. The DB2 code base on Intel, Linux, and UNIX platforms is the same. DB2 provides seamless database connectivity using the most popular network communications protocols.

DB2 and the On Demand Business

The DB2 family of database products is part of the IBM DB2 software brand. With respect to leveraging IBM information assets, this group of products has expanded to include Informix, U2, Cloudscape, and Information Management System (IMS) database products; a variety of tools; and new products in the areas of business intelligence (BI), information integration, and content management. In addition, DB2 9 incorporates an optimized management of both relational and XML data.

As a core component of IBM's Service Oriented Architecture direction, DB2 is a catalyst for delivering applications that directly impact a company's operations. SOA technology enables organizations to quickly develop solutions based on loosely coupled software services that can use independent technologies. Common applications in this area include electronic commerce, enterprise resource planning (ERP), customer relationship management (CRM), supply chain management (SCM), and content management (CM). DB2 as the database is an integral part of this service.

Today's companies face several major business challenges, including continuous change, rigorous competition, financial pressures, security and compliance issues, and unpredictable risks. Business integration involves business modeling, process transformation, application and information integration, access, collaboration, security, compliance, and business process management. Implementing these elements lets companies further integrate their people, processes, and information. Infrastructure management, another challenge, includes areas such as availability, security, optimization, business service management, and resource virtualization. Addressing these areas of the business lets companies optimize and simplify their infrastructure.

Focusing on the database, we see business challenges manifested through unpredictable workloads with reduced problem tolerance, business partners of all types with evolving language standards, increased realtime decision making, continuous growth in size and form of data, and skyrocketing systems complexity. Successful management of the integration and infrastructure is critical. How well the organization is able to meet information challenges at the database level will, to a significant degree, determine the success of its application development and its ability to thrive in today's on-demand world. Using IBM's mainframe and DB2 for z/OS, businesses can reduce cost and complexity in their IT infrastructure, simplify compliance, and leverage their core asset: their data.

The DB2 Product Family

The DB2 family of products spans many platforms that can coexist in a distributed environment:

• DB2 9 for z/OS. This hybrid relational and XML database management system is the largest of the DB2 family, often serving as an enterprise server handling many transactional systems (including e-business), content management, enterprise resource management, business intelligence, and mission- critical systems. The DB2 for z/OS offering is most often used to support the very largest databases and the highest transaction rates. Using IBM's largest hardware platform, the System z9, with DB2 and today's innovative programming models, you can derive new value from the data and applications on the mainframe. With the wealth of corporate data on the mainframe, the System z9 platform can leverage open standards and advanced virtualization capabilities in other IBM products to help position the platform as a data hub for the enterprise.

• DB2 for...

Details zur Ausgabe

• Verlag: MC Press, LLC
• Erscheinungsdatum: 2008
• Sprache: Englisch
• ISBN 10: 1583470743
• ISBN 13: 9781583470749
• Einband: Taschenbuch
• Anzahl der Seiten: 971
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar