db2 9 for z/os: using the utilities suite

DB2 9 for z/OS: Using the Utilities Suite (Paperback)

By: Paolo Bruni (Author) | Publisher: IBM Redbooks | Released: 08 Jan 2010 | Publisher Imprint: IBM Redbooks

R500

R490

2%
OFF

Available

About the Book

IBM® continues to enhance the functionality, performance, availability, and ease of use of IBM DB2® utilities.

This IBM Redbooks® publication is the result of a project dedicated to the current DB2 Version 9 Utilities Suite product. It provides information about introducing the functions that help set up and invoke the utilities in operational scenarios, shows how to optimize concurrent execution of utilities and collect information for triggering utilities execution, and provides considerations about partitioning.

It also describes the new functions provided by several utilities for SHARE LEVEL CHANGE execution, which maximize availability and the exploitation of DFSMS constructs by the BACKUP and RESTORE SYSTEM utilities.

This book concentrates on the enhancements provided by DB2 UDB for z/OS Version 8 and DB2 for z/OS Version 9. It implicitly assumes a basic level of familiarity with the utilities provided by DB2 for z/OS and OS/390® Version 7.

About the Authors
Paolo Bruni is a DB2 Information Management Project Leader at the International Technical Support Organization based in Silicon Valley Lab, San Jose, California. In this capacity, he has authored several IBM Redbooks publications on DB2 for z/OS and Data Management tools, and has conducted workshops and seminars worldwide. During Paolo's many years with IBM, in development and in the field, his work has been mostly related to database systems.

Marcelo Antonelli is a DB2 Specialist with IBM Brazil. He has 20 years of experience working with DB2 for z/OS. Marcelo holds a graduate degree in System Analysis from PUCC in Campinas, Sao Paulo. His areas of expertise include database design, system administration, and performance. Marcelo is currently supporting an outsourcing internal IBM account from EUA, as well as assisting IBM technical professionals working with DB2. Marcelo co-authored the books DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289, IBM DB2 Performance Expert for z/OS Version 2, SG24-68677, Administration Solutions for DB2 UDB for z/OS, SG24-6685, and A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, SG24-7224.

Davy Goethals is a Belgian systems engineer. He works for ArcelorMittal, the biggest steel producing company in the world. His experience as a DB2 system administrator goes back to DB2 Version 1 in 1985. He participated in multiple DB2 ESP and QPP programs from DB2 V2.1 up to DB2 V7. Davy co-authored the book LOBs with DB2 for z/OS: Stronger and Faster, SG24-7270. Currently he is the DB2 and IMS team leader within the ArcelorMittal z/OS department, located in Dunkerque, France, and is responsible for supporting more than 40 DB2 systems for steel plants all over Europe. He is also a regular presenter at international DB2 conferences, such as IDUG.

Armin Kompalka is an IBM Certified Senior IT specialist working for IBM Software Group Germany on DB2 Tools on IBM System z. He has over 20 years of experience in DB2, IMS, and CICS system programming and distributed database administration on various UNIX platforms. He joined IBM in 2000 after working for 6 years with BMC as a technical DB2 tools specialist. Before that, he had worked as a DB/DC Systems programmer for Dun and Bradstreet. Armin co-authored the books IMS DataPropagator Implementation Guide, SG24-6838 and SAP Casebook: DB2 Backup, Recovery and Cloning for SAP Environments.

Mary Petras is a Consulting Product Design Professional at the IBM Silicon Valley Lab and works on the DB2 Tools Technical Specialist team supporting DB2 for z/OS Tools. Mary holds a graduate degree in Mathematics from Pratt Institute, School of Engineering and Science, in Brooklyn, New York, and did post-graduate work at the University of Connecticut in Storrs. Her areas of expertise include DB2 data sharing, DB2 utilities, and performance and tuning. Mary co-authored the books DB2 UDB for OS/390 Version 6 Performance Topics, SG24-5351, IBM DB2 Performance Expert for z/OS Version 2, SG24-6867, and DB2 UDB for z/OS Version 8 Performance Topics. SG24-6465. She has also presented at the DB2 Technical Conference and IDUG and local user groups.

Table Of Contents