Muutke küpsiste eelistusi

DB2 Cluster Certification Guide [Pehme köide]

, ,
  • Formaat: Paperback / softback, 544 pages, kõrgus x laius x paksus: 235x180x35 mm, kaal: 1049 g
  • Ilmumisaeg: 30-Sep-1998
  • Kirjastus: IBM Press
  • ISBN-10: 013081900X
  • ISBN-13: 9780130819000
Teised raamatud teemal:
  • Pehme köide
  • Hind: 68,36 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
DB2 Cluster Certification GuideSuurem pilt
  • Formaat: Paperback / softback, 544 pages, kõrgus x laius x paksus: 235x180x35 mm, kaal: 1049 g
  • Ilmumisaeg: 30-Sep-1998
  • Kirjastus: IBM Press
  • ISBN-10: 013081900X
  • ISBN-13: 9780130819000
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780130819000.html
Märksõnad:
8190K-9 CD-ROM Included! Make DB2 UDB EEE work for you! Practical planning, design, installation, configuration and management techniques - straight from IBM! Sample exercises prepare you for IBM's DB2 Certification Course #506: IBM DB2 UDB for Cluster. International Technical Support Organization. IBM's DB2 Universal Database Enterprise-Extended Edition (DB2 UDB EEE) is the world's most powerful, scalable, flexible database: simply the best solution for today's gigantic databases, fast queries and business-critical decision support applications. Now, straight from IBM, there's a systematic, hands-on guide to making DB2 UDB EEE work for you: The DB2 Cluster Certification Guide. This book brings together all the techniques you need to deploy, manage and optimize DB2 UDB EEE - and if you're pursuing IBM DB2 certification, it's a great guide to passing the DB2 UDB for Cluster Exam (506). Master all this, and more: *Planning, installation, configuration, database design and implementation. *Loading and splitting data; using the LOAD and AutoLoader utilities. *Partitioned databases, nodegroups, table spaces and tables.* Practical data management: rebalancing, redistributing, backup and recovery. *Performance/tuning: Join strategies, OLAP features, EXPLAIN tools, monitoring and more. *DB2 Control Center, Client Configuration Assistant and Command Line Processor. You'll find practical deployment scenarios, a full chapter on problem determination and error logs, and a complete DB2 UDB for Cluster sample exam. Whether you're a DBA, developer, network administrator or manager, if you want to get the most out of DB2 UDB EEE, get The DB2 Cluster Certification Guide.
Contents iii(6)
Figures
ix(4)
Tables
xiii(2)
Preface xv(3)
How This Book was Created xviii
Chapter
1. Overview
1(26)
1.0.1 DB2 Family of Products
2(1)
1.1 DB2 Universal Database V5
2(2)
1.1.1 DB2 Universal Database -- The Scalable Database
3(1)
1.2 DB2 UDB Family of Products
4(6)
1.2.1 DB2 Universal Database
6(1)
1.2.2 DB2 UDB Enterprise-Extended Edition
6(4)
1.3 Terminology Used in DB2 UDB EEE
10(11)
1.3.1 DB2 Commands and SQL Statements
13(1)
1.3.2 Parallel Architecture and Processing
14(7)
1.4 DB2 User Interfaces
21(6)
1.4.1 The Control Center
21(2)
1.4.2 Client Configuration Assistant
23(1)
1.4.3 The Command Center
24(1)
1.4.4 The Command Line Processor (CLP)
25(2)
Chapter
2. Installation and Configuration
27(100)
2.1 Pre-Installation Tasks and Planning
27(19)
2.1.1 Hardware Requirements
28(1)
2.1.2 Software Prerequisites
29(1)
2.1.3 Choice of User Management Systems
30(2)
2.1.4 Creating Users for DB2 UDB EEE
32(14)
2.2 Installing DB2 UDB EEE
46(22)
2.2.1 Choice of Code Installation
46(1)
2.2.2 Using DB2 Installer
47(7)
2.2.3 Using SMIT
54(7)
2.2.4 Using the installp Command
61(4)
2.2.5 Verifying the Installation
65(1)
2.2.6 How to Choose an Installation Method
66(2)
2.3 Post-Installation Tasks
68(59)
2.3.1 Configuring DB2 Communication between Nodes
69(14)
2.3.2 Creating a DB2 Instance
83(11)
2.3.3 Modifying the Environment
94(3)
2.3.4 Starting the DB2 Instance
97(3)
2.3.5 Configuring the DAS Instance to Enable The Graphical Tools
100(11)
2.3.6 Using the Graphical Tools to Configure DB2 Clients
111(8)
2.3.7 Manually Configuring DB2 Client/Server Communications
119(8)
Chapter
3. Designing and Implementing a Database
127(72)
3.1 Database Terminology
127(2)
3.1.1 Instances, Databases Partitions and Databases
129(1)
3.2 DB2 Instances
129(4)
3.2.1 Database Partitions
131(2)
3.3 Partitioned Databases
133(15)
3.3.1 Considerations for Creating DB2 UDB EEE Database
134(1)
3.3.2 Creating Databases in an SDP Configuration
135(6)
3.3.3 Database Physical Directories and Files
141(3)
3.3.4 Database Objects
144(3)
3.3.5 Instance and Database Configuration
147(1)
3.4 Nodegroups
148(13)
3.4.1 Nodegroup Classifications
149(2)
3.4.2 Creating Nodegroups
151(1)
3.4.3 Dropping Nodegroups
152(1)
3.4.4 Displaying Nodegroup Information
153(1)
3.4.5 Partitioning Maps
154(4)
3.4.6 System Catalog Views Relating to Nodegroups
158(2)
3.4.7 Nodegroups Summary
160(1)
3.5 Table Spaces
161(24)
3.5.1 Containers
162(1)
3.5.2 The Relationship between Table Spaces and Containers
163(1)
3.5.3 Types of Tables Spaces
164(3)
3.5.4 Table Spaces Created by Default
167(2)
3.5.5 Creating Table Spaces
169(6)
3.5.6 Querying Tables Space and Container Definitions
175(3)
3.5.7 Buffer Pools
178(7)
3.6 Tables
185(14)
3.6.1 Types of Tables
186(3)
3.6.2 Partitioning Keys
189(3)
3.6.3 Creating Tables
192(2)
3.6.4 Indexes
194(5)
Chapter
4. Loading Data
199(52)
4.1 Overview of Loading Data
199(2)
4.1.1 Loading in Parallel
200(1)
4.2 Splitting Data
201(21)
4.2.1 db2split Overview
201(1)
4.2.2 Partitioning Maps
202(2)
4.2.3 Round-Robin Partitioning
204(1)
4.2.4 Customized Partition Maps
204(3)
4.2.5 How a Partitioning Map Gets Changed and Data Rebalanced
207(1)
4.2.6 Examples of Splitting Data
208(14)
4.3 The LOAD Utility
222(9)
4.3.1 LOAD Considerations
223(1)
4.3.2 The Three Phases of the LOAD Utility
224(1)
4.3.3 The Exception Table
225(1)
4.3.4 LOAD Failures
226(1)
4.3.5 LOAD Performance Considerations
227(3)
4.3.6 LOAD and Table Space States
230(1)
4.4 The AutoLoader Utility
231(4)
4.4.1 Overview
231(2)
4.4.2 AutoLoader Modes
233(1)
4.4.3 Running the Autoloader Utility
234(1)
4.5 Autoloader Example
235(8)
4.5.1 Create the Input Data
237(1)
4.5.2 Autoloader Configuration File
237(2)
4.5.3 Autoloader Command
239(1)
4.5.4 Autoloader Output
239(1)
4.5.5 The Phases of AutoLoader Processing
239(1)
4.5.6 Log Files
240(1)
4.5.7 In Case of Problems
241(1)
4.5.8 Common Problems
241(1)
4.5.9 Considerations and Usage Notes
242(1)
4.5.10 Autoloader Considerations
242(1)
4.6 The IMPORT Utility
243(8)
4.6.1 IMPORT Performance
246(5)
Chapter
5. Managing Data
251(84)
5.1 Rebalancing Data
251(23)
5.1.1 Scenarios for Scaling
252(2)
5.1.2 Adding Database Partitions
254(16)
5.1.3 Dropping A Database Partition
270(4)
5.2 Redistributing Data Across Database Partitions
274(22)
5.2.1 Update Nodegroup Definition After Adding DB Partition
275(18)
5.2.2 Summary of Alter Nodegroup
293(1)
5.2.3 Update Nodegroup Definition Before Dropping DB Partition
294(2)
5.3 Redistribute Nodegroup Utility
296(28)
5.3.1 Using the DISTFILE Option
300(7)
5.3.2 Using the TARGETMAP Option
307(2)
5.3.3 Which Option of Redistribute Nodegroup to Use
309(1)
5.3.4 How Data is Redistributed Across Database Partitions
310(1)
5.3.5 Recovering from Redistribution Errors
311(3)
5.3.6 Estimating the Amount of Log Space for Redistribution
314(6)
5.3.7 Solutions for Redistribution
320(3)
5.3.8 Other Methods to Move Data into New DB Partitions
323(1)
5.3.9 Non-Homogeneous Hardware Environment
323(1)
5.4 DB2 UDB EEE Backup and Recovery
324(11)
5.4.1 Overview of DB2 UDB EEE Backup and Recovery
324(1)
5.4.2 Recovery Methods
325(1)
5.4.3 Logging
326(3)
5.4.4 Recovery History File
329(1)
5.4.5 Choosing A Backup Strategy
330(5)
Chapter
6. Performance and Tuning
335(144)
6.1 DB2 UDB EEE Join Strategies
335(44)
6.1.1 Join Concepts
337(10)
6.1.2 SQL Join Functions
347(8)
6.1.3 Join Strategies in a Partitioned Database
355(24)
6.2 DB2 UDB EEE OLAP Features
379(34)
6.2.1 Grouping Sets
379(3)
6.2.2 Rollup
382(9)
6.2.3 Cube
391(9)
6.2.4 Grouping Column Function
400(2)
6.2.5 Star Schema
402(11)
6.3 EXPLAIN
413(47)
6.3.1 EXPLAIN Tools
413(5)
6.3.2 Understanding EXPLAIN Output
418(42)
6.4 Database Monitoring
460(11)
6.4.1 Snapshot Monitoring
461(3)
6.4.2 Event Monitoring
464(5)
6.4.3 Visual Performance Monitors
469(1)
6.4.4 DB2 Governor
470(1)
6.5 Performance Issues
471(8)
6.5.1 Configuring Database Resources
474(5)
Chapter
7. Problem Determination
479(16)
7.1 Introduction
479(5)
7.1.1 Problem Description
479(1)
7.1.2 Error Messages and SQL Codes
480(2)
7.1.3 Diagnostic and Service Logs
482(2)
7.2 DB2 Error Log DB2DIAG.LOG
484(5)
7.2.1 Setting the DIAGLEVEL Configuration Parameter
485(1)
7.2.2 DB2DIAG.LOG File Entry Format
486(1)
7.2.3 Dump Files
487(1)
7.2.4 DB2DIAG.LOG in DB2 UDB EEE
488(1)
7.3 Using syslogd
489(3)
7.3.1 Setting up the Syslog
489(3)
7.4 Interpreting syslog Entries
492(1)
7.4.1 Return Codes
492(1)
7.5 Using db2trc
493(2)
Appendix A. Test Objectives and Sample Questions
495(12)
A.1 Objectives
495(1)
A.1.1 DB2 Cluster Concepts
495(1)
A.1.2 DB2 Cluster Installation and Configuration
495(1)
A.1.3 DB2 Cluster Administration Tasks
495(1)
A.1.4 DB2 Cluster Performance Tuning Tasks
496(1)
A.1.5 DB2 Cluster Application Considerations
496(1)
A.2 Questions
496(9)
A.3 Answers
505(2)
Appendix B. Related Publications
507(2)
B.1 International Technical Support Organization Publications
507(1)
B.2 Other Publications
507(2)
Index 509