Muutke küpsiste eelistusi

DB2 Universal Database v7.1 for UNIX, Linux, Windows and OS/2 Database Administration Certification Guide 4th edition [Multiple-component retail product]

2.67/5 (6 hinnangut Goodreads-ist)
,
  • Formaat: Multiple-component retail product, 832 pages, kõrgus x laius x paksus: 235x235x30 mm, kaal: 1189 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 09-Nov-2000
  • Kirjastus: IBM Press
  • ISBN-10: 0130913669
  • ISBN-13: 9780130913661
Teised raamatud teemal:
  • Multiple-component retail product
  • Hind: 73,67 €*
  • * 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 Universal Database v7.1 for UNIX, Linux, Windows and OS/2 Database Administration Certification Guide 4th editionSuurem pilt
  • Formaat: Multiple-component retail product, 832 pages, kõrgus x laius x paksus: 235x235x30 mm, kaal: 1189 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 09-Nov-2000
  • Kirjastus: IBM Press
  • ISBN-10: 0130913669
  • ISBN-13: 9780130913661
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780130913661.html
Märksõnad:
Straight from IBM, this is the only book to offer complete, start-to-finish coverage of DB2 Universal Database V7.1 administration and development for UNIX, Linux, Windows, and OS/2 platforms. It's also the only book to offer authoritative preparation for IBM's latest DB2 certification exam. This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V7.1, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. The book contains an extensive collection of IBM's most useful tips and tricks, designed to save DBAs and developers time and money -- while at the same time optimizing database performance and availability. For all DB2 system administrators, DBAs, database designers, and for anyone seeking IBM DB2 Certification.

Muu info

Straight from IBM, this is the only book to offer complete, start-to-finish coverage of DB2 Universal Database V7.1 administration and development for UNIX, Linux, Windows, and OS/2 platforms. It's also the only book to offer authoritative preparation for IBM's latest DB2 certification exam. This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V7.1, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. The book contains an extensive collection of IBM's most useful tips and tricks, designed to save DBAs and developers time and money -- while at the same time optimizing database performance and availability. For all DB2 system administrators, DBAs, database designers, and for anyone seeking IBM DB2 Certification.
Foreword xvii
Preface xix
PART ONE - Introduction to DB2 UDB 1(194)
Product Overview
3(48)
DB2 and e-business
5(2)
DB2 Universal Database
7(8)
DB2 Enterprise Edition
7(1)
DB2 Workgroup Edition
8(1)
DB2 Enterprise - Extended Edition
9(1)
DB2 Personal Edition
10(1)
DB2 Satellite Edition
11(2)
DB2 Everyplace
13(2)
DB2 Connectivity
15(9)
DB2 Universal Database Clients
15(2)
DB2 Connect
17(2)
DB2 Replication
19(1)
DB2 Net.Data
20(1)
DB2 Relational Connect
21(1)
DB2 DataJoiner
22(1)
IBM WebSphere Application Server
23(1)
DB2 Application Development
24(16)
DB2 Universal Developer's Edition
24(2)
DB2 Stored Procedure Builder
26(1)
DB2 Relational Extenders
27(3)
DB2 OLAP Server Starter Kit
30(1)
DB2 Data Warehouse Center
31(1)
DB2 Warehouse Manager
32(5)
DB2 Data Links Manager
37(3)
DB2 Administration
40(9)
Control Center
40(1)
Other Tools Available from the Control Center
41(1)
Wizards
42(2)
The Command Line Processor (CLP)
44(1)
Visual Explain
45(4)
Summary
49(2)
Getting Started
51(34)
Product Installation
52(17)
Windows and OS/2 Installation
52(9)
UNIX and Linux Installation
61(3)
DB2 Client Installation
64(1)
Distributed Installation
65(4)
The DB2 Environment
69(7)
DB2 Profile Registry
69(3)
Environment Variables
72(1)
Using the Command Line Processor
73(3)
DAS and DB2 Instances
76(6)
DB2 Administration Server (DAS) Instance
76(2)
DB2 Instances
78(4)
Using First Steps
82(1)
Summary
83(2)
Getting Connected
85(60)
Roadmap to Distributed Communications
87(4)
DB2 Discovery
87(2)
Automated Configuration Using Discovery
89(1)
Automated Configuration Using Access Profiles
89(1)
Manual Configuration
90(1)
DB2 Directories
91(3)
Examining DB2 Directories
92(2)
Configuring DB2 Clients
94(27)
Automated Configuration Using Discovery
94(12)
Using Access Profiles
106(6)
Manual Configuration
112(8)
Summary of Configuring Connections
120(1)
Configuring Communications
121(13)
Configuring the DB2 Instance for Communications
121(7)
Configuring the DAS Instance
128(2)
Configuring DB2 Discovery
130(4)
Binding Utilities
134(5)
Binding Utilities Using the CCA
136(3)
Instance Administration
139(5)
Local Instance Administration
140(2)
Attaching to an Instance Using the Control Center
142(2)
Summary
144(1)
Controlling Data Access
145(50)
Security
146(42)
Overview of Security
146(1)
Authentication
146(16)
Authorities and Privileges
162(17)
Windows NT/2000 Considerations
179(9)
Auditing
188(6)
Summary
194(1)
PART TWO - Using SQL 195(212)
Database Objects
197(76)
Understanding Database Objects
199(8)
Data Types
199(1)
Tables
200(1)
Schemas
200(1)
Table Spaces
201(1)
Views
202(1)
Indexes
202(1)
Packages
203(1)
Buffer Pools
203(1)
Transactions
204(1)
Locks
205(1)
Log Files
205(1)
Creating a DB2 Database
205(2)
Managing Database Objects
207(54)
Using SQL Data Definition Language (DDL)
207(3)
Data Types
210(25)
Tables
235(13)
Views
248(8)
Indexes
256(5)
Database Design and Implementation
261(11)
DB2CERT Database Table Descriptions
262(3)
Define User-Defined Data Types
265(1)
Defining Columns
266(1)
Keys
267(1)
Defining Primary Keys
268(1)
Defining Unique Keys
269(1)
Defining Foreign Keys
270(2)
Summary
272(1)
Manipulating Database Objects
273(52)
Data Retrieval
274(37)
Retrieving the Entire Table
274(2)
Projecting Columns from a Table
276(1)
Changing the Order of the Columns
276(1)
Restricting Rows from a Table
277(1)
Predicate Evaluation for UDTs
278(1)
Restricting Rows Using Multiple Conditions
279(1)
Selecting Columns from Multiple Tables
280(5)
Using Correlation Names
285(1)
Sorting Your Output
286(2)
Derived Columns
288(1)
DB2 Functions
289(2)
Grouping Values
291(2)
Eliminating Duplicates
293(1)
Searching for String Patterns
294(1)
Searching for Data in Ranges
295(1)
Searching for Null Values
296(1)
Searching for Negative Conditions
296(1)
Searching for a Set of Values
297(1)
Sub-Queries
298(1)
Quantified Predicates
299(3)
Case Expressions
302(1)
Nested Table Expressions
303(1)
Scalar Fullselect
304(2)
Common Table Expressions
306(1)
Set Operators
307(4)
Data Modification
311(9)
Inserting Data Records
311(4)
Updating Data Records
315(3)
Removing Data
318(2)
View Classification
320(4)
Deletable Views
320(1)
Updatable Views
321(1)
Insertable Views
322(1)
Read-Only Views
322(1)
Inoperative Views
323(1)
Summary
324(1)
Advanced SQL
325(60)
Triggers
326(4)
Trigger Usage
326(1)
Trigger Activation
326(1)
Trigger Example (After Trigger)
327(1)
Trigger Example (Before Trigger)
328(2)
Recursive SQL
330(5)
Outer Join
335(6)
Left Outer Join
335(1)
Right Outer Join
336(1)
Full Outer Join
337(1)
Combining Outer Joins
338(3)
OLAP Features
341(12)
STAR Schemas
341(2)
OLAP Indexes
343(1)
STAR Joins
343(1)
Super Grouping
344(7)
Moving Functions
351(2)
Advanced CASE Expressions
353(2)
Using CASE Expressions to Group Values
353(1)
Using CASE Expressions in Functions
354(1)
Structured Types and Typed Tables
355(24)
Creating Structured Types
356(2)
Altering Structured Types
358(1)
Creating Typed Tables
358(2)
Dropping Typed Tables
360(1)
Inserting Rows into a Typed Table
361(1)
Selecting a Row from a Typed Table
361(2)
Updating and Deleting Rows from Typed Tables
363(1)
Pysical Implementation of Typed Tables
363(3)
Reference Columns
366(2)
View Hierarchies
368(1)
SQL Functions for Typed Tables and Typed Views
369(1)
TYPE Predicate
370(1)
Considerations When Using Typed Tables and Views
371(1)
Examples of a Typed Table Hierarchy
371(8)
Summary Tables
379(5)
Creating a Summary Table
379(2)
Current Refresh Age Special Register
381(1)
Considerations of Using Summary Tables
382(1)
System Catalog Information for Summary Tables
383(1)
Summary
384(1)
Concurrency
385(22)
Concurrency
387(9)
Concurrency Considerations
388(8)
Isolation Levels
396(3)
Uncommitted Read
396(1)
Cursor Stability
396(1)
Read Stability
397(1)
Repeatable Read
397(1)
Choosing an Isolation Level
397(2)
Locking
399(7)
Lock Attributes
399(2)
Lock Conversion
401(1)
Lock Escalation
402(1)
Lock Wait Behavior
403(1)
Lock Table Statement
404(1)
LOCKSIZE parameter of ALTER TABLE statement
404(2)
Summary
406(1)
PART THREE - DB2 UDB Administration 407(266)
Data Storage Management
409(42)
Processor, Memory, and Disk Resources
410(3)
Processors
410(1)
Memory
411(1)
Disk
411(2)
DB2 Storage Model
413(5)
Buffer Pool
414(1)
Table Spaces
414(1)
Containers
415(3)
Table Space Design
418(12)
Regular Table Space
418(1)
Long Table Space
419(1)
System Temporary Table Space
419(1)
Extentsize
419(1)
Pagesize
420(1)
Performance Considerations
421(6)
Long Field Data
427(1)
Large Object Data
427(3)
Implementation Examples
430(11)
Creating a Database
430(3)
Creating Buffer Pools
433(1)
Creating Table Spaces
433(1)
Creating Tables
434(1)
Dropping Table Spaces
435(1)
Dropping Buffer Pools
435(1)
Dropping a Database
435(1)
Creating Table Spaces Using the Control Center
435(6)
Table Space Maintenance
441(8)
Database Files
441(1)
Listing Table Spaces
441(1)
Listing Table Space Containers
442(1)
Table Space States
443(1)
System Catalog Information About Table Spaces
444(1)
Adding Containers to DMS Table Spaces
445(4)
Summary
449(2)
Maintaining Data
451(86)
Moving Data
452(3)
Delimited ASCII Files
452(1)
Non-Delimited ASCII Files
453(1)
PC/IXF Files
453(1)
Worksheet Format Files
454(1)
Data Movement Utilities
455(62)
The Export Utility
455(11)
The IMPORT Utility
466(13)
The Load Utility
479(22)
The LOAD QUERY Command
501(4)
The SET INTEGRITY Statement
505(5)
The DB2MOVE Utility
510(2)
The DB2LOOK Utility
512(5)
Data Maintenance
517(17)
Analyzing Data's Physical Organization
517(5)
Table Reorganization
522(4)
Generating Statistics
526(6)
The Rebind Utility
532(2)
Data Maintenance Process
534(2)
Modeling a Production Environment
534(2)
Summary
536(1)
Database Recovery
537(46)
Database Recovery Concepts
538(1)
Unit of Work
538(1)
Transaction
538(1)
Types of Recovery
539(1)
Crash Recovery
539(1)
Version Recovery
539(1)
Roll-Forward Recovery
539(1)
Recovery Strategies
540(2)
Recoverable and Nonrecoverable Databases
540(1)
Online and Offline Access
541(1)
Use of Log Files
542(7)
Log Buffers
543(1)
Primary and Secondary Log Files
544(1)
Types of Logging
544(3)
Log File Usage
547(2)
Version Recovery Using Backup and Restore
549(16)
Roll-Forward Recovery
565(8)
Managing Log Files
573(1)
Other Recovery Considerations
574(7)
Summary
581(2)
Monitoring and Tuning
583(90)
Elements of Performance
585(4)
Tuning Guidelines
585(2)
Performance Improvement Process
587(1)
How Much Can a System Be Tuned?
587(1)
A Less-Formal Approach
588(1)
DB2 Architecture Overview
589(9)
Process Model
589(1)
Query Parallelism
590(3)
DB2 Memory Usage
593(2)
SQL Compiler Overview
595(3)
DB2 Sorting Methods
598(1)
Database Monitoring
599(30)
Obtaining Database Access Information
599(1)
Database Monitors
599(1)
Snapshot Monitoring
600(9)
Event Monitoring
609(8)
Visual Performance Monitors
617(10)
DB2 Governor
627(2)
SQL Monitoring
629(28)
Explain Tables
629(1)
Gathering Explain Data
630(6)
Examining Explain Data
636(10)
Guidelines on Using Explain Output
646(1)
Index Advisor Facility
647(1)
Configuring Database Resources
648(6)
Configuring Intra-Partition Parallelism
654(3)
Performance Tuning Scenario
657(3)
Diagnostics and Problem Determination
660(12)
Error Messages and SQL Codes
660(6)
Tracing Problems in DB2 Universal Database
666(6)
Summary
672(1)
PART FOUR - Developing Applications 673(68)
Application Development Overview
675(16)
DB2 Application Development Environment
676(3)
Software Requirements
676(3)
DB2 Programming Interfaces
679(11)
Embedded SQL
679(3)
Call Level Interface and ODBC
682(2)
Java Interfaces (JDBC and SQLJ)
684(1)
Native DB2 APIs
685(1)
Microsoft Data Objects (DAO, RDO, ADO, OLE-DB)
686(1)
Other Interfaces and Tools
687(3)
Summary
690(1)
Development Considerations
691(28)
Embedded SQL Overview
692(12)
Creating Packages
692(5)
Binding Applications
697(7)
Support for CLI and ODBC Programming
704(9)
Embedded Dynamic Versus Call Level Interface
704(1)
ODBC Versus CLI
705(2)
Setting Up the CLI Environment
707(6)
Support for Java Programming
713(3)
JDBC Programming
714(1)
SQLJ Programming
715(1)
Stored Procedure Builder
716(2)
Summary
718(1)
Development SQL
719(22)
User-Defined Functions
720(8)
SQL-Bodied Scalar Functions
723(2)
SQL-Bodied Table Functions
725(3)
Structured Datatypes
728(7)
Schemas and Aliases
735(3)
Schema
735(1)
Alias
736(2)
Commit and Rollback
738(2)
Summary
740(1)
PART FIVE - Appendices 741(38)
DB2 UDB V7.1 Certification Test Objectives
743(777)
DB2 Family Fundamentals (512)
744(2)
DB2 for OS/2, Windows, and UNIX Database Administration (513)
746(3)
Sample Questions (Fundamentals - Exam 512)
749(13)
Sample Questions (Administration - Exam 513)
762(14)
Answers
776(1)
CD-ROM Installation
777(2)
DB2DEMO
777(2)
Index 779


GEORGE BAKLARZ, IBM's Senior Program Manager for DB2 Technical Sales Support, works closely with customers to help them understand new DB2 technology, and to gain their feedback for improving DB2 products. He has spent 18 years at IBM working on various aspects of database technology.

BILL WONG is IBM's worldwide manager of DB2 UDB Technical Sales Support. He is responsible for assisting customers assessing the latest DB2 technology and understanding future directions of IBM's data management portfolio. He has spent more than 16 years in a variety of database roles including DB2 systems administrator, DBA, technical sales support, vendor enablement, and product planning.