Muutke küpsiste eelistusi

DB2 9 for z/OS Database Administration: Certification Study Guide [Pehme köide]

  • Formaat: Paperback / softback, 785 pages, kõrgus x laius x paksus: 229x178x49 mm, kaal: 1270 g
  • Ilmumisaeg: 01-Feb-2008
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583470743
  • ISBN-13: 9781583470749
Teised raamatud teemal:
  • Formaat: Paperback / softback, 785 pages, kõrgus x laius x paksus: 229x178x49 mm, kaal: 1270 g
  • Ilmumisaeg: 01-Feb-2008
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583470743
  • ISBN-13: 9781583470749
Teised raamatud teemal:

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.



The definitive guide to preparing for relational database certification.
Preface xiii
DB2 Product Fundamentals
1(38)
DB2 and the On Demand Business
2(1)
The DB2 Product Family
3(18)
DB2 Middleware and Connectivity
21(4)
DB2 Application Development
25(3)
DB2 Administration
28(6)
Summary
34(1)
Practice Questions
35(2)
Answers
37(2)
Environment
39(60)
z/OS
40(11)
DB2 and Security
51(1)
Parallel Sysplex Support
52(1)
Storage Management Subsystem
52(1)
DB2 Interfaces
52(3)
Installation, Migration, and Conversion
55(4)
DSNZPARMs
59(9)
Commands
68(4)
DB2 Utilities
72(5)
Catalog and Directory
77(8)
Distributed Data
85(3)
Subsystem Pools
88(4)
Summary
92(1)
Additional Resources
93(1)
Practice Questions
94(2)
Answers
96(3)
Access and Security
99(42)
DB2 Subsystem Access
101(4)
Data-Set Protection
105(1)
DB2 Object Access
105(23)
Trusted Context
128(3)
Multilevel Security
131(1)
Auditing
132(3)
Auditing Specific IDs or Roles
135(1)
Starting/Stopping the Trace
135(1)
Auditing a Table
136(1)
Summary
136(1)
Additional Resources
137(1)
Practice Questions
138(2)
Answers
140(1)
Database Objects
141(108)
Understanding Data Structures
142(6)
Managing Database Objects
148(3)
Data Types
151(24)
Tables
175(12)
Sequence Objects
187(2)
Table Spaces
189(19)
Views
208(3)
Materialized Query Tables
211(2)
Clone Tables
213(2)
Indexes
215(12)
Databases
227(1)
Storage Groups
228(2)
Database Design and Implementation
230(8)
Sample Implementation
238(5)
Summary
243(1)
Additional Resources
244(1)
Practice Questions
245(2)
Answers
247(2)
Retrieving and Manipulating Database Objects
249(46)
Data Retrieval
250(28)
Data Modification
278(11)
Summary
289(1)
Additional Resources
290(1)
Practice Questions
291(2)
Answers
293(2)
Advanced SQL Coding
295(50)
Subqueries
296(4)
Unions
300(3)
Excepts
303(1)
Intersects
304(1)
Nested Table Expressions
304(2)
Common Table Expressions
306(1)
Data Change Tables
307(2)
Joins
309(14)
Order by and Fetch First in Subselects and Fullselects
323(1)
Case Expressions
324(2)
Row Expressions
326(1)
XPath and XQuery
326(6)
Predicates and Filtering
332(5)
Summary
337(1)
Additional Resources
338(1)
Practice Questions
339(4)
Answers
343(2)
Maintaining Data
345(82)
Data Movement
346(18)
Data Maintenance
364(25)
Data Statistics
389(11)
Real Time Statistics
400(2)
Data Maintenance Process
402(9)
Diagnose Utility
411(1)
Standalone Utilities
412(4)
Displaying Utilities
416(1)
Resolving Restrictive and Advisory States
417(5)
Summary
422(1)
Additional Resources
422(1)
Practice Questions
423(2)
Answers
425(2)
Recovery and Restart
427(54)
Database Recovery Concepts
427(2)
Logging
429(4)
Image Copies
433(13)
Establishing a Point of Consistency
446(1)
Recovery Concepts
447(10)
System-Level Backup and Recovery
457(4)
Backup and Recovery of the DB2 Catalog and Directory
461(2)
Disaster Recovery
463(4)
LOB Recovery
467(1)
Tracker Site Recovery
468(1)
DB2 Restart
469(7)
Data-Sharing Recovery
476(1)
Summary
476(1)
Additional Resources
476(1)
Practice Questions
477(2)
Answers
479(2)
Data Sharing
481(34)
Data Sharing Benefits
482(2)
Data Sharing Components
484(7)
Shared Data
491(1)
Maintaining Data Integrity
492(8)
Performance
500(1)
Processing Costs
501(1)
Movement to Data Sharing
501(3)
Workload Management and Affinity Processing
504(1)
Distributed Processing
505(1)
Sysplex Query Parallelism
506(1)
Recovery Considerations
507(4)
Summary
511(1)
Additional Resources
511(1)
Practice Questions
512(2)
Answers
514(1)
Using SQL in an Application Program
515(34)
Delimiting SQL in a Program
516(1)
Declaring Table and View Definitions
516(8)
SQL Execution Validation
524(8)
Using Cursors
532(3)
Executing SQL Statements
535(8)
Using Dynamic SQL
543(2)
Summary
545(1)
Additional Resources
545(1)
Practice Questions
546(2)
Answers
548(1)
Binding an Application Program
549(24)
Precompile and Bind
549(17)
Plan or Package Ownership
566(2)
Plan Execution Authorization
568(1)
Summary
568(1)
Additional Resources
568(1)
Practice Questions
569(2)
Answers
571(2)
Application Program Features
573(36)
Application Program Features
573(15)
Fetch for Limited Rows
588(2)
Multi-Row Operations
590(3)
Identity Columns
593(3)
Sequence Objects
596(7)
Summary
603(1)
Additional Resources
603(1)
Practice Questions
604(2)
Answers
606(3)
Stored Procedures
609(28)
Stored Procedures
609(1)
Benefits
610(2)
Writing Stored Procedures
612(10)
Defining Stored Procedures
622(1)
Removing Stored Procedures
622(2)
Execution Environments
624(4)
SQL Procedure Language
628(4)
DB2 Developer Workbench
632(1)
Summary
633(1)
Additional Resources
633(1)
Practice Questions
634(2)
Answers
636(1)
Accessing Distributed Data
637(30)
Distributed Data
637(3)
Communications Protocols
640(1)
Communications Database
641(3)
Communicating with a Data-Sharing Group
644(1)
Coding Methods for Distributed Data
645(9)
Programming Considerations
654(1)
Application Design Options
655(1)
Remote Query Performance
656(6)
Summary
662(1)
Additional Resources
662(1)
Practice Questions
663(2)
Answers
665(2)
Advanced Functionality
667(54)
Triggers
667(18)
Object-Relational Extensions
685(6)
User-Defined Functions
691(12)
Large Objects
703(5)
Extenders
708(9)
Summary
717(1)
Additional Resources
717(1)
Practice Questions
718(2)
Answers
720(1)
Locking and Concurrency
721(34)
Locking Data
722(14)
Avoiding Locks
736(2)
System Parameters
738(2)
Claims and Drains
740(1)
Locking Issues and Problems
741(3)
Lock Promotion and Escalation
744(2)
Database and Application Design for Concurrency
746(2)
Lock Monitoring
748(3)
Summary
751(1)
Additional Resources
751(1)
Practice Questions
752(2)
Answers
754(1)
Performance Monitoring and Tuning
755(126)
Access Paths and Optimization
756(9)
Access Path Evaluation
765(38)
Guidelines for Using Explain Output
803(2)
Access Path Optimization Hints
805(1)
Catalog Statistics
806(7)
Predicate Types
813(2)
Designing Indexes and SQL for Performance
815(6)
Dynamic SQL
821(1)
Runtime Reoptimization
821(3)
Query Parallelism
824(3)
Elements of Performance
827(4)
Database Monitoring
831(3)
Tracing Problems in DB2
834(22)
Using Display Commands
856(1)
Buffer Pools
857(18)
Logging
875(1)
Summary
876(1)
Additional Resources
877(1)
Practice Questions
878(2)
Answers
880(1)
Appendix A DB2 Sample Database 881(10)
Appendix B Sample Exam Questions 891(28)
Appendix C Sample Exam Answers 919(16)
Appendix D References 935


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 worlds 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.