
Résumé
- A practical guide to DB2 z/OS database administration that is 100 percent focused on running DB2 in z/OS environments
- The only comprehensive preparation guide for the IBM Certified Database Administrator for DB2 Universal Database V8 z/OS certification
- Covers database planning, design, implementation, operation, recovery, security, performance, installation, migration, and more
- Sample test questions help you prepare for both IBM DB2 DBA Tests 700 and 702
IBM DB2 Universal Database Version 8 for z/OS offers enterprises unprecedented opportunities to integrate information, deliver it on demand, and manage it simply and cost-effectively. Now, one of the world's leading DB2 consultants presents the definitive guide to administering DB2 UDB V8 databases in z/OS environments. DB2 for z/OS Version 8 DBA Certification Guide 'also serves as a key tool for anyone preparing for IBM Certified Database Administrator for DB2 Universal Database V8 for z/OS certification.
IBM Gold Consultant Susan Lawson presents hundreds of practical techniques, expert guidelines, and useful tips for every facet of DB2 UDB database administration, including database implementation, operation, recovery, security, auditing, performance, installation, migration, SQL, and more. Coverage includes
- Understanding the DB2 product family, architecture, attachments, and the DB2 z/OS environment
- Securing enterprise-class DB2 installations and applications
- Using SQL to create and manage database objects, and manipulate and retrieve information
- Mastering key DBA tasks, including loading, reorganizing, quiescing, repairing, and recovering data; recovering and rebuilding indexes; and gathering statistics
- Implementing data sharing in Parallel Sysplex environments
- Learning the fundamentals of DB2 application development from the DBA's perspective
- Leveraging advanced DB2 functions, including stored procedures and other object-relational extensions
- Optimizing DB2 applications and the DB2 engine for maximum performance
Whether you are administering DB2 UDB V8 in z/OS environments, planning to do so, or preparing for DB2 UDB V8 DBA certification, DB2 for z/OS Version 8 DBA Certification Guide will be your single most valuable resource.
L'auteur - Susan Lawson
Susan Lawson, Principal Consultant with YL&A, has
worked with DB2 for over a dozen years. She has served as
an IBM Data Sharing advocate, supporting many large DB2
customers and providing technical expertise for migration
to DB2 Data Sharing in Parallel Sysplex environments. Now a
Director of the Midwest DB2 Users Group and IBM Gold
Consultant for DB2 and S/390, she is Technical Editor of
the IDUG Solutions Journal.
Sommaire
- DB2 Family and DB2 for z/OS Environment
- Product Overview
- Environment
- DB2 Access and Security
- Structured query language
- Database Objects
- Retrieving and Manipulating Database Objects
- Advanced SQL Coding
- Database Administration
- Maintaining Data
- Recovery and Restart
- Developing Applications with DB2
- Data Sharing
- Using SQL in an Application Program
- Binding an Application Program
- Application Program Features
- Advanced Functions and Performance
- Stored Procedures
- Accessing Distributed Data
- Object-Relational Functionality
- Locking and Concurrency
- SQL Optimization and Performance
- DB2 Monitoring and Tuning
- A. DDL for the DB2CERT Database
- B. IBM Certified Database Administrator for DB2 UDB V8 for z/OS
- C. 702 Sample Exam
Caractéristiques techniques
PAPIER | |
Éditeur(s) | IBM Press |
Auteur(s) | Susan Lawson |
Parution | 23/11/2004 |
Nb. de pages | 660 |
Format | 18,5 x 24 |
Couverture | Relié |
Poids | 1125g |
Intérieur | Noir et Blanc |
EAN13 | 9780131491205 |
ISBN13 | 978-0-13-149120-5 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse