DB2 for Solaris: The Official GuidePrentice 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! |
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 |
Expressions et termes fréquents
administration allocated application backup buffer pool bytes cache line catalog cluster file system column configuration parameters contains Control Center database manager database partition DB2 Connect DB2 instance DB2 UDB DB2 UDB server db2inst2 default defined disk Enterprise Server Edition environment Event Monitor example execute Explain failover Figure file system foreign key host IBM DB2 interface IP address kernel log files logical machine malloc memory segment mount multiple Offline option packet partitioned database performance physical memory protocol query raw device recovery remote resource group response file restore roll-forward Schedule script service group setup shared memory snapshot Solaris operating environment specified SQL statements stored subnet Sun Cluster Sun Cluster 3.x sun-hal sunfish sunfish.torolab.ibm.com SWAP tablespace TCP/IP UDB database unique constraint UNIX update virtual memory Volume Manager wizard xterm