Understanding DB2: Learning Visually with Examples Paperback 2nd Edition (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
1011
Utgivningsdatum
2012-03-16
Upplaga
2
Förlag
QUE
Medarbetare
Wang, Xiaomei / Dang, Michael / Snow, Dwaine R.
Dimensioner
232 x 179 x 51 mm
Vikt
1643 g
Antal komponenter
1
ISBN
9780133007046

Understanding DB2: Learning Visually with Examples Paperback 2nd Edition

Learning Visually with Examples (paperback)

av Raul Chong, Xiaomei Wang, Michael Dang, Dwaine Snow
Häftad,  Engelska, 2012-03-16

Slutsåld

The Easy, Visual Way to Master IBM DB2 for Linux, UNIX, and WindowsFully Updated for Version 9.5 IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges.

Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables.

This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736.

Coverage includes
  • Choosing the right version of DB2 for your needs
  • Installing and configuring DB2
  • Understanding the DB2 environment, instances, and databases
  • Establishing client and server connectivity
  • Working with database objects
  • Utilizing breakthrough pureXML technology, which provides for nativeXML support
  • Mastering administration, maintenance, performance optimization, troubleshooting, and recovery
  • Understanding improvements in the DB2 process, memory, and storage models
  • Implementing effective database security
  • Leveraging the power of SQL and XQuery
Visa hela texten

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Fler böcker av författarna

  • Report on the Rule of Law Index in China 2

    Report on the Rule of Law Index in China 2

    He Tian, Yanbin Lv, Xiaomei Wang

    This book reviews and assesses the status quo concerning the rule of law in China in 2017 and predicts its future development in such fields as legislation, judicial reform, civil, commercial and economic law, social law, safeguarding of human rig...

    1943
    Köp
    Skickas inom vardagar.

Övrig information

Raul F. Chong, DB2 on Campus Program Manager at the IBM Toronto Laboratory, is a DB2 Certified Solutions Expert in administration and application development with ten years of experience in DB2. He has helped customers resolve DB2 migration, performance, and design issues; developed new DB2 solutions; taught DB2 workshops; contributed to DB2 exam tutorials; and was the lead author of the first edition of Understanding DB2. Xiaomei Wang, a technical consultant at the IBM Toronto Laboratory, has nine years of DB2 experience. She has handled critical DB2 customer and business partner situations worldwide. Michael Dang, DB2 Technical Sales Specialist, specializes in solution design, database sizing, product licensing, and Balanced Warehouse configurations. He formerly served as a DB2 Support Analyst and spent seven years as a DB2 DBA. Dwaine R. Snow, DB2 Senior Product Manager, has worked with DB2 for seventeen years. He is the coauthor of Advanced DBA Certification Guide and Reference for DB2 Universal Database for Linux, UNIX, and Windows, DB2 UDB for Windows, and the first edition of Understanding DB2.

Innehållsförteckning

Foreword xxiii Preface xxv Acknowledgments xxxi About the Authors xxxiii Chapter 1 Introduction to DB2 1

1.1 Brief History of DB2 1

1.2 The Role of DB2 in the Information On-Demand World 4

1.3 DB2 Editions 13

1.4 DB2 Clients 20

1.5 Try-and-Buy Versions 22

1.6 Host Connectivity 23

1.7 Federation Support 23

1.8 Replication Support 24

1.9 IBM WebSphere Federation Server and WebSphere Replication Server 25

1.10 Special Package Offerings for Developers 25

1.11 DB2 Syntax Diagram Conventions 26

1.12 Case Study 28

1.13 Summary 29

1.14 Review Questions 30

Chapter 2 DB2 at a Glance: The Big Picture 33

2.1 SQL Statements, XQuery Statements, and DB2 Commands 33

2.2 DB2 Tools Overview 38

2.4 Federation 55

2.5 Case Study: The DB2 Environment 56

2.6 Database Partitioning Feature 58

2.7 Case Study: DB2 with DPF Environment 74

2.8 IBM Balanced Warehouse 79

2.9 Summary 81

2.10 Review Questions 81

Chapter 3 Installing DB2 85

3.1 DB2 Installation: The Big Picture 85

3.2 Installing DB2 Using the DB2 Setup Wizard 88

3.3 Non-Root Installation on Linux and Unix 102

3.4 Required User IDs and Groups 105

3.5 Silent Install Using a Response File 108

3.6 Advanced DB2 Installation Methods (Linux and UNIX Only) 113

3.7 Installing a DB2 License 116

3.8 Installing DB2 in a DPF Environment 118

3.9 Installing Multiple db2 Versions and Fix Packs on the Same Server 119

3.10 Installing DB2 Fix Packs 126

3.11 Migrating DB2 129

3.12 Case Study 131

3.13 Summary 133

3.14 Review Questions 134

Chapter 4 Using the DB2 Tools 137

4.1 DB2 Tools: The Big Picture 137

4.2 The Command-Line Tools 138

4.3 Web-Based Tools 157

4.4 General Administration Tools 158

4.5 Information Tools 165

4.6 Monitoring Tools 167

4.7 Setup Tools 171

4.8 Other Tools 175

4.9 Tool Settings 179

4.10 Case Study 179

4.11 Summary 184

4.12 Review Questions 185

Chapter 5 Understanding the DB2 Environment, DB2 Instances, and Databases 189

5.1 The DB2 Environment, DB2 Instances, and Databases: The Big Picture 189

5.2 The DB2 Environment 190

5.3 The DB2 Instance 198

5.4 The Database Administration Server 216

5.5 Configuring a Database 217

5.6 Instance and Database Design Considerations 224

5.7 Case Study 225

5.8 Summary 227

5.9 Review Questions 227

Chapter 6 Configuring Client and Server Connectivity 231

6.1 Client and Server Connectivity: The Big Picture 231

6.2 The DB2 Database Directories 233

6.3 Supported Connectivity Scenarios 243

6.4 Configuring Database Connections Using the Configuration Assistant 258

6.5 Diagnosing DB2 Connectivity Problems 276

6.6 Case Stu...

Du kanske gillar