DB2 9 for z/OS Database Administration: Certification Study Guide

DB2 9 for z/OS Database Administration: Certification Study Guide

by Susan Lawson, Daniel Luksetich
     
 

View All Available Formats & Editions

Written primarily for database administrators who work on the IBM z/OS system and who are taking the DB2 9 Database for z/OS Certification exam (Exam 732), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator on z/OS systems. The guide covers all topics on the exam, including

…  See more details below

Overview

Written primarily for database administrators who work on the IBM z/OS system and who are taking the DB2 9 Database for z/OS Certification exam (Exam 732), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator on z/OS systems. The guide covers all topics on the exam, including database design and implementation, operation and recovering, security and auditing, performance, and installation and migration. Complete with sample questions and detailed answers—as well as a full-length practice exam—this study guide serves as an essential tool. Programmers will learn how to create, maintain, and administer DB2 9 databases on the z/OS platform and how to implement XML with a DB2 9 database, making them successful database administrators after they pass certification.

Product Details

ISBN-13:
9781583476949
Publisher:
Mc Press
Publication date:
03/01/2012
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
785
File size:
10 MB

Read an Excerpt

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-694-9



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 i5/OS. DB2 for i5/OS provides for a common database architecture in that many of its features and capabilities are compatible and/or interchangeable with the other members of the DB2 product family. These features include a common SQL language, DB2 tools (such as Extenders), and the ability to connect to other DB2 product family data servers and databases. As with DB2 for z/OS, the ability to connect to other DB2 data servers is built into the DB2 for i5/OS product.

DB2 9 for Linux, UNIX, and Windows (LUW). This DB2 9 offering is the next-generation hybrid data server with optimized management of both XML and relational data on UNIX and Intel platforms. This full-function database product is scalable from single processors to symmetric multiprocessors to massively parallel clusters. DB2 9 for LUW comes in several editions, responding to different processing requirements and applications:

DB2 Express 9. DB2 Express is an ideal entry-level data server, suitable for transaction processing or complex query workloads on servers with up to two processors. DB2 Express 9 provides many capabilities of the DB2 Enterprise 9 Edition (described below) as value-added features to let you to control costs by buying only what you need.

» DB2 Express-C 9. This product is a version of DB2 Express 9 for the community: a no-charge data server for use in developing and deploying applications, including C/C++, Java, .NET, PHP, XML, and more. You can run DB2 Express-C on up to two dual-core CPU servers with up to 4 GB of memory and any storage system setup, with no restrictions on database size or any other artificial restrictions. When combined with the DB2 suite of application development tools, DB2 Express-C 9 enables a powerful and inexpensive development platform.

» DB2 Workgroup 9. This product is an ideal data server for deployment in a departmental, workgroup, or midsized business environment, suitable for transaction processing or complex query workloads on servers with up to four processors. Your workload may be smaller, but your business data is as critical to you as to the largest enterprise. Like DB2 Express 9, DB2 Workgroup 9 provides many Enterprise capabilities as value-added features to let you control costs by buying only the capability you need.

» DB2 Enterprise 9. DB2 Enterprise is an ideal data server for the most demanding workloads. It easily scales to handle high-volume transaction processing, multi-terabyte data warehouses, and mission-critical applications from vendors such as SAP. It offers many connectivity options and can share data with third-party databases and DB2 on heterogeneous platforms. DB2 Enterprise most often supports very large databases. Popular uses include supporting large data warehouses and Internet applications. DB2 Enterprise 9 can exploit single servers, clusters, or massively parallel hardware architectures, and it supports database and table partitioning.

» DB2 Everyplace 9. The Everyplace product features a small-footprint relational database and high-performance data synchronization solution that lets you securely extend enterprise applications and data to mobile devices such as personal digital assistants (PDAs), smart phones, and embedded mobile devices. The database runs on a variety of mobile and embedded platforms, including Embedded Linux, Linux, Microsoft Win32, Palm OS, QNX Neutrino, Symbian, and Windows CE/Pocket PC.

» DB2 Personal 9. This single-user, full-function relational database with built-in replication is ideal for desktop or laptop deployments.

» DB2 Enterprise Developer 9. This offering lets a single application developer design, build, and prototype applications for deployment on any IBM Information Management client or server platform. The product includes DB2 Workgroup 9 and DB2 Enterprise 9, Informix Dynamic Server (IDS) Enterprise Edition, Cloudscape, DB2 Connect Unlimited Edition for zSeries, and all the DB2 9 features.

» DB2 Warehouse 9. With this single integrated software package, IBM delivers all the capabilities needed to cost-effectively consolidate, manage, deliver, and analyze your business information. The Warehouse edition integrates DB2 Enterprise 9 with a data-mining tool, online analytical processing (OLAP) acceleration, DB2 Query Patroller, and DB2 Alphablox.


In the next sections of this chapter, we take a closer look at the products in the DB2 family.


DB2 for z/OS

The DB2 9 for z/OS relational database management system (RDBMS) is the foundation of many e-business, BI, CRM, and ERP applications and numerous mission-critical systems. The primary focus of this certification guide, DB2 9 for z/OS is the largest member of the DB2 family, often functioning as an enterprise server handling many of the biggest applications in the world. The operating environment furnished by z/OS is IBM's largest and most powerful, providing the most scalable and available platform.

DB2 9 for z/OS delivers large data capacity, high transaction performance, and extensive connectivity. It supports transactions arising from Web servers, Customer Information Control System (CICS), IMS transaction management, and Multiple Virtual Storage (MVS) batch jobs as well as via distributed connections from remote clients on numerous platforms. In addition to being able to handle single tables up to 128 TB, use 64-bit addressability to take advantage of very large amounts of physical memory, process complex SQL (including multi-row operations), handle data storage in Unicode, and offer the highest level of availability, DB2 9 for z/OS expands the value delivered to your business by the industry-leading IBM mainframe data server through innovations in key areas:

• Rich hybrid data server support for both relational and pureXML storage, with the necessary services to support both data structures. This support enables direct XML access to and from the database.

• New data types (BIGINT, DECFLOAT, and VARBINARY).

• Native SQL procedural language. The SQL procedure language has been available for several years but has always resulted in generated C external programs that weren't very compatible when migrating from other relational RDBMSs. Now, these stored procedures run as native runtime structures, eliminating any performance issues related to external program scheduling.

• Improved security, with roles, trusted context, new encryption functions, and Secure Sockets Layer (SSL) support.

• Extensions of DB2 for z/OS Version 8 capabilities to make changes to data.

• Enhancements to large object (LOB) support and performance.

• Volume-based copy and recover.

• Refinements to the DB2 industry-leading optimization.

• Query Management Facility (QMF) interface design changes that provide on-demand access to data, reports, and interactive visual solutions with an optional Web browser.

• Enablement for IBM System z9 Integrated Information Processors (zIIP). With this support, z/OS may be able to free up capacity and help you optimize the resource utilization of general-purpose processors by directing eligible work to this new specialty engine.


Among the highlights of the DB2 9 for z/OS offering are the following features:

High performance. In many ways, DB2 9 for z/OS excels in the area of performance. Designed specifically for, and tightly coupled with, the z/OS operating system, it can exploit operating system functionality specifically for performance. No other database management system vendor owns the platform architecture and operating system, and DB2's synergy with the operating system enables it to exploit the various features of the operating system, as well as the System z platform. Advanced SQL optimization and a highly sophisticated, cost-based optimizer let you construct SQL to solve a variety of business functions as quickly as possible. This capability includes high degrees of query parallelism across single instances (subsystems) or even across multiple members of data-sharing groups and machines. 64-bit addressability enables DB2 to take advantage of the large amounts of available cache on the System z servers.

High availability. The highest levels of availability are obtained with DB2 9 for z/OS and the Parallel Sysplex on the System z architecture with DB2 data sharing. Additional features — such as workload-managed stored procedure address spaces; online utilities (reorganization, load, copy, and so on); and table space, disk volume, and system-level online backup and recovery options — allow for continuous, reliable, and secure operations.

Data sharing. Data sharing enables multiple DB2 subsystems to operate against a single data source. By exploiting the Parallel Sysplex clustering technology, this functionality makes continuous operations possible across outages of a single DB2 subsystem, z/OS operating system, or System z server. This capability enables automated handling of planned and unplanned outages as well as near linear scalability across single servers or clusters of servers. Critical data sets and logs are duplexed, and the server can automatically direct workloads to various members for workload balancing or during outages. SQL queries can be executed across members.

Large tables. DB2 9 for z/OS can manage the storage of very large tables (up to 128 TB) in variety of ways. Tables can be partitioned by ranges or can grow automatically based on demand. Management of these tables can be automated or can be performed manually according to the application design. Multiple indexing options for tables adapt to the needs of high availability, fast access to data, and ease of database management. The physical storage of the tables is tightly coupled with the operating system's physical storage architecture, enabling the exploitation of advanced storage and I/O features from within the data server.


(Continues...)

Excerpted from DB2 9 for z/OS by Susan Lawson, Daniel Luksetich. Copyright © 2007 Susan Lawson and Daniel Luksetich. Excerpted by permission of MC Press.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.

Meet the Author

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >