DB2 for z/OS Version 8 DBA Certification Guide

0 avg rating
( 0 ratings by Goodreads )
 
9780131491205: DB2 for z/OS Version 8 DBA Certification Guide

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



"synopsis" may belong to another edition of this title.

From the Back Cover:

  • 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/OS platforms.

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

About the Author:

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration. She currently works with several clients to help development, implement, and tune some of the world's largest and most complex DB2 databases. She is an IBM Gold Consultant for DB2 and S/390, and an IBM Certified DBA for DB2 UDB Version 7 for z/OS. She is coauthor of DB2 High Performance Design and Tuning (Prentice Hall, 2001) and author of DB2 Universal Database for OS/390 v7.1 Application Certification Guide (Prentice Hall, 2002).



"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Lawson, Susan
Published by Prentice Hall, Lebanon, Indiana, U.S.A. (2004)
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Hardcover Quantity Available: 2
Seller
SottoVoceBooks
(Garland, TX, U.S.A.)
Rating
[?]

Book Description Prentice Hall, Lebanon, Indiana, U.S.A., 2004. Hardcover. Book Condition: New. NEW Book, Text & cover completely pristine, free of any wear. FREE TRACKING within the US (international tracking not currently available), and email notice when shipped. Your satisfaction guaranteed. Inquiries welcomed. Thanks. Bookseller Inventory # 007499

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 11.00
Convert Currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds

2.

Lawson, Susan
Published by IBM Press (2004)
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Hardcover Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description IBM Press, 2004. Hardcover. Book Condition: New. book. Bookseller Inventory # 0131491202

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.58
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Susan Lawson
Published by IBM Press (2004)
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Hardcover Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description IBM Press, 2004. Hardcover. Book Condition: New. 1. Bookseller Inventory # DADAX0131491202

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.59
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

4.

Lawson, Susan
Published by IBM Press (2004)
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Hardcover Quantity Available: 2
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description IBM Press, 2004. Hardcover. Book Condition: New. Bookseller Inventory # P110131491202

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 35.93
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

5.

Lawson, Susan
Published by IBM Press
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Hardcover Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description IBM Press. Hardcover. Book Condition: New. 0131491202 New Condition. Bookseller Inventory # NEW6.0047654

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

6.

Susan Lawson
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801314912051.0

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 63.62
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

Susan Lawson
Published by Prentice Hall (2004)
ISBN 10: 0131491202 ISBN 13: 9780131491205
New Hardcover Quantity Available: 1
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Prentice Hall, 2004. Hardcover. Book Condition: Brand New. 2nd edition. 660 pages. 9.25x7.25x1.25 inches. In Stock. Bookseller Inventory # 0131491202

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 132.89
Convert Currency

Add to Basket

Shipping: US$ 7.76
From United Kingdom to U.S.A.
Destination, Rates & Speeds