02730nam 2200577Ia 450 991078340030332120200520144314.0(CKB)1000000000023299(SSID)ssj0000949206(PQKBManifestationID)11630165(PQKBTitleCode)TC0000949206(PQKBWorkID)10996003(PQKB)11609891(Au-PeEL)EBL3306457(CaPaEBR)ebr10112444(OCoLC)62771955(CaSebORM)0738498807(MiAaPQ)EBC3306457(EXLCZ)99100000000002329920040812d2004 uy 0engurcn|||||||||txtccrDB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI[electronic resource] /[Nagraj Alur ... et al.]1st ed.[S.l.] IBM, International Technical Support Organizationc2004xxiv, 504 p. illIBM redbooks"April 2004."0-7384-9880-7 Includes bibliographical references and index.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.IBM redbooks.Database managementTransaction systems (Computer systems)Online data processingDatabase management.Transaction systems (Computer systems)Online data processing.005.75/65Alur Nagraj1511159International Business Machines Corporation.International Technical Support Organization.MiAaPQMiAaPQMiAaPQBOOK9910783400303321DB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI3763347UNINA