DB2 Universal Database for OS/390 Version 7.1 Certification Guide

DB2 Universal Database for OS/390 Version 7.1 Certification Guide

by Richard A. Yevich, Susan Lawson
     
 

ISBN-10: 0130650765

ISBN-13: 9780130650764

Pub. Date: 08/13/2001

Publisher: Pearson Education

  • IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide!
  • The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide
  • Covers administration, security, SQL, application development, tuning, and much more
  • Contains dozens of expert DB2 tips, techniques and guidelines
…  See more details below

Overview

  • IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide!
  • The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide
  • Covers administration, security, SQL, application development, tuning, and much more
  • Contains dozens of expert DB2 tips, techniques and guidelines
  • CD-ROM contains complete DB2 for OS/390 sample exam

Written by IBM Gold Consultants for DB2 and S/390

  • The total resource for every professional running DB2 UDB V7.1 in OS/390 and z/OS environments
  • Database administration, security, monitoring, tuning, SQL, and application development
  • Sample test questions help you prepare for IBM's new DB2 UDB V7.1 for OS/390 exams

The CD-ROM included with this book contains a complete IBM DB2 for OS/390 certification sample exam.

IBM's DB2 Universal Database Version 7.1 for OS/390 delivers unparalleled performance, scalability, and reliability in today's enterprise e-business environments! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for IBM's updated DB2 UDB V7.1 for OS/390 certification exam!

Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 and z/OS environments is also the only book with the in-depth knowledge professionals need in order to pass IBM's latest DB2 for OS/390DBA certification exam. Full of expert tips, techniques, and guidelines, it covers virtually every aspect of working with DB2 UDB in enterprise server: administration, connectivity,development, and much more.

IBM Gold Consultants Richard Yevich and Susan Lawson present start-to-finish coverage of DB2's latest and most powerful enhancements, tools, and utilities, showing how to make the most of DB2 running on both OS/390 and next-generation z/OS platforms. Coverage includes:

  • An overview of the DB2 UDB product family
  • DB2 in OS/390 and z/OS environments: address spaces, attachments, interfaces, commands, and utilities
  • Comprehensive security coverage, including access controls and auditing techniques
  • SQL in depth: DB2 data structures, database objects, basic database design, and advanced coding
  • DB2 UDB administration: maintaining data, backup/recovery, and more
  • Performance monitoring and optimization: access paths, indexes, parallelism, buffer pool tuning, and subsystem tuning
  • Data sharing: architecture and implementation in a Parallel Sysplex environment
  • Detailed application development coverage: database extenders, cursors, stored procedures, triggers, object-relational extensions, locking, and concurrency

Whether you're deploying DB2 UDB V7.1 in an OS/390 environment, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, DB2 Universal Database Version 7.1 for OS/390 Certification Guide will be your single most valuable resource.

Read More

Product Details

ISBN-13:
9780130650764
Publisher:
Pearson Education
Publication date:
08/13/2001
Series:
IBM DB2 Series
Edition description:
BK&CD-ROM
Pages:
672
Product dimensions:
8.30(w) x 7.96(h) x 0.32(d)

Table of Contents

Pt. 1Introduction to DB2 UDB for OS/3901
Ch. 1Product Overview3
Ch. 2Environment47
Ch. 3Controlling Data Access99
Pt. 2Using SQL129
Ch. 4Database Objects131
Ch. 5Manipulating Database Objects199
Ch. 6Advanced SQL235
Pt. 3DB2 UDB for OS/390 and z/OS Administration255
Ch. 7Maintaining Data257
Ch. 8Database Recovery321
Ch. 9Data Sharing355
Ch. 10Performance Monitoring and Tuning383
Pt. 4Developing Applications443
Ch. 11Application Development Overview445
Ch. 12Development Considerations491
Ch. 13Advanced Functions507
Ch. 14Locking and Concurrency535
App. A557
App. BDB2 UDB for OS/390 and z/OS Certification563
Bibliography605
Index619

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >