LEADER 02730nam 2200577Ia 450 001 9910783400303321 005 20200520144314.0 035 $a(CKB)1000000000023299 035 $a(SSID)ssj0000949206 035 $a(PQKBManifestationID)11630165 035 $a(PQKBTitleCode)TC0000949206 035 $a(PQKBWorkID)10996003 035 $a(PQKB)11609891 035 $a(Au-PeEL)EBL3306457 035 $a(CaPaEBR)ebr10112444 035 $a(OCoLC)62771955 035 $a(CaSebORM)0738498807 035 $a(MiAaPQ)EBC3306457 035 $a(EXLCZ)991000000000023299 100 $a20040812d2004 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 00$aDB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI$b[electronic resource] /$f[Nagraj Alur ... et al.] 205 $a1st ed. 210 $a[S.l.] $cIBM, International Technical Support Organization$dc2004 215 $axxiv, 504 p. $cill 225 1 $aIBM redbooks 300 $a"April 2004." 311 $a0-7384-9880-7 320 $aIncludes bibliographical references and index. 330 $aThis 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. 410 0$aIBM redbooks. 606 $aDatabase management 606 $aTransaction systems (Computer systems) 606 $aOnline data processing 615 0$aDatabase management. 615 0$aTransaction systems (Computer systems) 615 0$aOnline data processing. 676 $a005.75/65 701 $aAlur$b Nagraj$01511159 712 02$aInternational Business Machines Corporation.$bInternational Technical Support Organization. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910783400303321 996 $aDB2 UDB ESE V8 non-DPF performance guide for high performance OLTP and BI$93763347 997 $aUNINA