DB2 for Solaris: The Official Guide

Couverture
Prentice Hall Professional, 2004 - 536 pages
-- The insider's guide to table structures, cluster configuration, and other optimization opportunities.

-- Provides best practices techniques for installing, configuring, and optimizing DB2 in the Solaris Operating Environment.

-- Covers the new Solaris Operating Environment security features to make your databases even more secure!

-- Part of the IBM Press DB2 Series.

This is the only IBM insider's reference and guidebook for making the most of DB2 in Solaris enterprise environments. Coverage includes: integrating Solaris and DB2 to build more secure database applications; working with DB2's management utilities in a Solaris environment; client/server communications under Solaris; special issues and opportunities associated with running DB2 Universal Database Enterprise Edition under Solaris, and much more! The authors explain configuring Solaris and DB2 failover support and provide expert tips and techniques for DB2/Solaris performance monitoring, optimization, and troubleshooting. If you manage or develop for DB2 on Solaris, this book is critical to your success -- and you can't find it anywhere else!

 

Avis des internautes - Rédiger un commentaire

Aucun commentaire n'a été trouvé aux emplacements habituels.

Pages sélectionnées

Table des matières

Introduction
xxi
DB2 Universal DatabaseThe Scalable Database
xxii
DB2 Products
xxiii
DB2 Universal Database
xxv
DB2 UDB Workgroup Server Edition WSE
xxvi
DB2 UDB Enterprise Server Edition with Partitioning Feature
xxviii
DB2 Connect
xxix
DB2 Connect Personal Edition PE
xxx
Configuring DB2 Clients
228
Automated Configuration Using Discovery
229
Search Discovery Using the Control Center
231
Using the Configuration Assistant CA
233
Using Access Profiles
237
Using a Server Access Profile
238
Using a Client Access Profile
239
Manual Configuration
241

DB2 Connect Enterprise Edition
1
DB2 Data Links Manager
3
DB2 Facilities Extended to Files
5
DB2 Query Patroller
6
Query Patroller Components
7
Complementary Products to DB2 UDB for Solaris
10
NetData
11
Intelligent Miner
12
DB2 UDB for Solaris Scenarios
14
DB2 UDB ESE with DPF on a Sun Server
15
DB2 UDB ESE with DPF on Multiple Physical Servers
16
DB2 UDB ESE with OFF on a Large SMP Server
17
DB2 UDB Installation
19
Prerequisites
20
Supported Operating System Level
21
Before You Begin
22
Updating the Kernel Configuration Parameters
23
Command Syntax for db2osconf
25
Setting Kernel Parameters
26
Setting up SWAP Space
29
Installing DB2 UDB
30
Installed Directory Structure
51
Considerations in an NIS Environment
53
Distributed Installation
54
Creating a Response File
55
Distributed Installation with a Response File
56
Installing DB2 with db2_install
57
DB2 UDB Environment Definitions
58
DB2 Profile Registry
59
Managing the DB2 Profile Registry
60
The db2set Command
61
Environment Variables
62
DB2 Administration Server DAS
63
Creating a DAS Instance
64
Managing the DAS Instance
65
DB2 Instances
66
Creating a DB2 Instance
67
Starting a DB2 Instance
68
Stopping a DB2 Instance
69
Using the Command Line Processor CLP
70
Uninstalling DB2 Products
74
Removing the DAS Instance
75
Removing DB2 Products
76
Introduction to SUNs Disk Technology
77
Supported File System Types of Solaris
78
NetworkBased File Systems
79
THE UNIX FILE SYSTEM UFS
80
Logical Disk Device Names in Solaris
81
Specifying the Disk Subdirectory
82
Administrative Tasks
83
File System Management Tasks
84
Creating a New File System
85
Example
86
The etcvfstab File
88
Mounting a UFS
89
UFS Direct IO
90
Adding Disks Under Solaris
91
Creating New File Systems
95
Backing Up and Restoring a File System
96
Backing Up a File System
97
Restoring a File System
98
NFS Under Solaris
99
Share Command
100
Mounting File Systems
101
Mounting File Systems Using Mount Command
102
Unmounting File Systems
103
Disk Management
104
Sun StorEdge Veritas Volume Manager
105
Accessing Volumes for IO
109
Software RAID vs Hardware RAID
111
The Visual Administrator
113
Creating Database Objects
115
Databases
117
Schemas
118
Buffer Pools
119
Tablespaces
120
Types of Tablespaces
121
DMS Tablespaces
122
Considerations for RAIDSAN Devices
123
Creating Tablespaces
124
Tablespaces Created by Default
129
Creating Tables
131
Typed Tables
135
Minimize the Space Required for LOB Columns
136
Defining Constraints
137
Defining Referential Constraints
138
Defining Table Check Constraints
142
Indexes
143
Unique Indexes vs NonUnique Indexes
144
Null Values and Indexes
145
Clustering Considerations
146
Creating Triggers
147
Trigger Dependencies
148
DB2 UDB Graphical Tools
150
Control Center
150
Administering Databases Using the Control Center
150
Managing Databases
151
Other Useful Functions of the Control Center
155
Using Wizards
162
Command Center
166
Task Center
170
Creating a Script
171
Scheduling a Script
173
Journal
175
Health Center
178
Other Graphical Tools
181
Run the Control Center Locally or Remotely?
184
Backup and Recovery
185
Version Restore Recovery
187
RollForeword Recovery
188
Recovery Concepts and Issues
189
Database Logs
190
Archival Logging
191
Database Configuration Parameters
192
Log File Usage
195
Preventing Logging
196
Database and Tablespace Backup
197
Using the Control Center Backup Database Notebook
198
Incremental and Delta Backups
205
Other Recovery Considerations
212
Redefining Tablespace Containers During Restore
214
Recovery History File RHF
215
Other Recovery Considerations
216
The QUIESCE Command
217
Tables Related to Other Tables
218
Offline and Online Tablespace States
219
DB2 UDB ClientServer Communications
221
Roadmap to ClientServer Communications
222
Automated Configuration Using Access Profiles
223
DB2 Discovery
224
Examining DB2 UDB Directories
225
Configuring Communications
242
Configuring the DB2 Instance for Communications
243
Using the CLP
245
Configuring DB2 Discovery
247
Bind Utilities
249
Binding Utilities Using the CA
250
Performance Monitoring and Tuning
253
Obtaining Database Access Information
254
Explain Tables
255
Gathering Explain Data
256
EXPLAIN Special Register
257
EXPLAIN BIND Options
258
Using Tools to Gather and Analyze Explain Data
259
Explain with the Command Center or Control Center
260
Guidelines on Using Explain Output
266
The Design Advisor
267
Monitoring DB2 UDB Activity
269
Viewing Snapshot Monitor Data
271
Event Monitoring
275
Creating Event Monitors
276
Starting and Stopping Event Monitors
277
Event Monitor Records
278
Basic Performance Setup
279
Configuring Database Resources
280
Diagnostics and Problem Determination
287
Diagnostic and Service Logs
289
Administration Notification Logs
290
Troubleshooting Information
292
Memory Considerations
293
Clustering DB2 on Solaris
295
Cluster Communication
301
LowLatency Transport LLT
303
Configuring LLT
304
Group MembershipAtomic Broadcast GAB
305
GAB Configuration and Maintenance
308
Cluster Agent Framework
309
Cluster Resources and Agents
311
Service Groups
314
Failover Service Group
315
DB2 UDB Failover Example
316
DiskGroup
317
Mount
318
IP and NIC
319
DB2 Shared Storage Example
320
DB2 with Sun Cluster
324
Multihost Disks
325
Device Group
326
Resource Type Resource and Resource Group
327
Miscellaneous Considerations
329
Configuration of a Particular DB2 Instance
330
Sun Cluster 3x DB2HA Agent
331
Cluster Topology
332
Logical HostnameIP Failover
333
DB2 UDBV7 EEE Sun Cluster Implementation
335
DB2 UDB V8 MultiPartition ESE Sun Cluster Implementation
340
DB2 GA Binary Installation
341
Globalize vardb2 and varlum
342
Updating the DB2 Product License Key
343
HA Enable DB2 Instance
344
Enable HAStorage+ for DB2 Instance
345
Cluster Verification Testing
347
Test 2
348
Test 3
349
Test 5
350
Clustered Pairs
351
Pair + M N + M
352
Customizing Sun Cluster 3x Resource Properties for DB2 UDB
353
Optimizing Cluster File System CFS Performance
354
CFS Mount Options
355
Failover Time and How to Minimize It
356
Recatalog DB2 Database on HA Logical Host
359
Summary
361
Enterprise Server Edition with Data Partitioning Feature
363
DB2 UDB ESE with DPF Concepts
364
Database Partition Groups
367
Partitioning Map
368
Partitioning Keys
370
Installation and Configuration
372
Installing DB2 UDB ESE with DPF
373
PostInstallation Tasks
374
The db2nodescfg Configuration File
375
Creating the Sample Database Optional
379
Environment Tools and Files
381
Default Environment Variables
382
Files
384
Memory
387
LowLevel Memory Design
388
Why Is All This Important?
397
Configuring DB2 to Use the Memory Architecture More Effectively
400
Physical Components
401
Address Translation
403
SHM_SHARE_MMU
407
Segments
408
Paging and SWAP
416
When a System Is Low on Memory
422
Life and Times of a Load Instruction
423
Memory Maps and Address Space
424
DB2 Specifics on Shared Memory
427
CPU
431
CPU Migrations
436
DB2 and CPU Resources
438
Disks and File Systems
439
Partition Tables
442
SMS DMS FILE and DMS Raw Containers
443
DMS Raw and Veritas Quick IO
448
RAID Levels
449
Summary
450
RAID1
451
Summary
452
RAID1+0 and 0+1
455
Just a Bunch of Disks JBOD
457
RAID Comparisons
460
Disk Failures and Data Protection
461
TCPIP v4 Networks
463
Link Layer Header
464
IP Packet Header
465
IP ProtocolSpecific Header
466
Encapsulation and the Analogy of a Courier
467
Subnets
468
Two Hosts on the Same Subnet
474
Two Hosts on Different Subnets
476
Simple Network Debugging
481
Connect Hangs or Host Not Reachable
482
Connection Refused or Connection Failed
487
Finding the Other Side of a Socket
488
Advanced Network Debugging
490
TCP Windows and a Hung Socket
492
Tuning TCPIP
494
Bibliography
497
Index
499
Droits d'auteur

Expressions et termes fréquents

À propos de l'auteur (2004)

TOM BAUCH is a Senior Certified IT Specialist and Technical Lead of the DB2 Ranger Team at IBM Software Group. He has been with the Ranger Team supporting DB2 on Solaris since 1998, and prior to that was a DB2 instructor for IBM. MARK WILDING, Advisory Software Developer at the IBM Toronto Lab, is currently the architect for DB2 Serviceability. Bauch and Wilding co-authored DB2 Universal Database in the Solaris Operating Environment.

Informations bibliographiques