DB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI /

This IBM Redbooks publication provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs). We provide...

Full description

Saved in:
Bibliographic Details
Corporate Author: International Business Machines Corporation. International Technical Support Organization
Other Authors: Alur, Nagraj
Format: Electronic eBook
Language:English
Published: [United States?] : IBM, International Support Organization, ©2004.
Subjects:
Online Access: Full text (MFA users only)
ISBN:9780738498805
0738498807
Local Note:ProQuest Ebook Central
Description
Summary:This IBM Redbooks publication provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs). We provide an overview of the architecture of a DB2 UDB V8 non-DPF environment from a performance perspective, and describe key performance drivers in OLTP, BI, and mixed workload environments. This book's primary focus is a single partition (non-DPF) environment, and we provide best practices to achieve optimal application and system performance in OLTP, BI, and mixed workload environments. Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe techniques for problem diagnosis using typical problem scenarios.
Physical Description:1 online resource (xxiv, 504 pages) : illustrations
Bibliography:Includes bibliographical references and index.
Language Note:English.
Edition:1st ed.
Series:IBM redbooks.
Library Staff:View instance in FOLIO