search for books and compare prices
Tables of Contents for The Universal Guide to DB2 for Windows Nt
Chapter/Section Title
Page #
Page Count
Figures
xi
8
Tables
xix
2
Preface
xxi
How This Book is Organized
xxi
1
The Team That Wrote This Book
xxii
Chapter 1. Overview
1
22
1.1 DB2 Family of Products
1
2
1.2 DB2 UDB Family of Products
3
13
1.2.1 DB2 UDB Personal Edition
5
1
1.2.2 DB2 Workgroup Edition
6
2
1.2.3 DB2 Enterprise Edition
8
1
1.2.4 DB2 Universal Database Enterprise-Extended Edition
9
1
1.2.5 DB2 Connect
10
3
1.2.6 DB2 Developer's Edition
13
3
1.3 DB2 UDB in the Windows NT Environment
16
1
1.3.1 Introduction of Windows NT
16
1
1.4 DB2 UDB for Windows NT Scenarios
17
5
1.4.1 Small Workgroup Example
17
1
1.4.2 Trusted Domain Example
18
2
1.4.3 Enterprise Example
20
2
1.5 Summary
22
1
Chapter 2. DB2 UDB and Windows NT Security
23
60
2.1 Windows NT Security Concepts
25
8
2.1.1 Workgroups in Windows NT
25
4
2.1.2 Domains in Windows NT
29
4
2.2 Groups and User Authentication
33
9
2.2.1 User Accounts
34
1
2.2.2 Global Groups
35
2
2.2.3 Local Groups
37
2
2.2.4 Domain Scenario
39
1
2.2.5 Windows NT Authentication
40
2
2.3 Trust Relationships Between Domains
42
11
2.3.1 Trusted Domains
42
2
2.3.2 Creating a Trust Relationship
44
2
2.3.3 Models of Domain Trust
46
7
2.4 DB2 UDB for Windows NT Authentication and Security
53
13
2.4.1 DB2 UDB for Windows NT Group Resolution
53
2
2.4.2 Forcing Local Authentication
55
1
2.4.3 Authority Levels
56
5
2.4.4 Controlling Client Access to DB2 Databases
61
1
2.4.5 DB2 Authentication Methods
61
2
2.4.6 Example Scenarios
63
3
2.5 The DB2 for Windows NT Environment
66
17
2.5.1 User ID and Group ID Limitations
67
2
2.5.2 DB2 for Windows NT Security Server Service
69
1
2.5.3 DB2 Instances and Windows NT Services
70
1
2.5.4 Planning for DB2 UDB in a Windows NT Environment
71
2
2.5.5 Example Scenarios
73
6
2.5.6 Frequently Asked Questions
79
4
Chapter 3. DB2 UDB Installation
83
40
3.1 Installing DB2 UDB Servers
83
23
3.1.1 Pre-Installation
83
2
3.1.2 Running the Installation Program
85
17
3.1.3 Post-Installation
102
2
3.1.4 Summary of the Installation
104
2
3.2 Uninstalling DB2 UDB
106
4
3.2.1 Stop All DB2 Applications and Processes
107
2
3.2.2 Execute the DB2 UDB Uninstall Program
109
1
3.2.3 Summary of the Uninstall Process
109
1
3.3 Installing DB2 UDB Clients
110
8
3.3.1 Pre-Installation
110
2
3.3.2 Installing the DB2 Client Application Enabler
112
5
3.3.3 Installing the DB2 Software Developer's Kit
117
1
3.4 Applying a DB2 UDB Fixpack
118
5
Chapter 4. DB2 UDB Client/Server Communications
123
68
4.1 DB2 UDB Client/Server Overview
123
2
4.2 Discovery
125
8
4.2.1 Search Discovery
126
2
4.2.2 Known Discovery
128
2
4.2.3 Configuring Discovery
130
2
4.2.4 Restricting Discovery
132
1
4.3 DB2 Administration Server (DAS) Instance
133
15
4.3.1 Creation of a DAS instance
136
3
4.3.2 DAS Instance Owner
139
1
4.3.3 Managing a DAS Instance
140
3
4.3.4 Configuring DAS Instance Communications After Installation
143
5
4.4 Client Configuration Assistant
148
17
4.4.1 Search Discovery Using the CCA
150
6
4.4.2 Known Discovery Using the CCA
156
9
4.5 Access Profiles
165
10
4.5.1 Server Access Profiles
165
5
4.5.2 Client Access Profiles
170
5
4.6 Manual Configuration Using the CCA
175
11
4.6.1 Using TCP/IP
175
4
4.6.2 Using NetBIOS
179
1
4.6.3 Named Pipes
180
2
4.6.4 Using IPX/SPX
182
2
4.6.5 Using APPC
184
2
4.7 Configuration Using the Control Center
186
4
4.7.1 Adding Databases to the Control Center
186
3
4.7.2 Changing the Communications Settings for an Instance
189
1
4.8 Summary
190
1
Chapter 5. DB2 UDB Graphical Tools
191
32
5.1 Overview of the Graphical Tools
191
32
5.1.1 Enabling Remote Administration
195
1
5.1.2 Control Center
196
10
5.1.3 Command Center
206
3
5.1.4 Script Center
209
4
5.1.5 Journal
213
4
5.1.6 DB2 UDB SmartGuides
217
6
Chapter 6. Backup and Recovery
223
40
6.1 Overview of Database Recovery
223
4
6.1.1 Crash Recovery
223
2
6.1.2 Restore Recovery
225
1
6.1.3 Roll-forward Recovery
226
1
6.2 Recovery Concepts and Issues
227
22
6.2.1 Unit of Work or Transaction
227
1
6.2.2 Point of Recovery
228
1
6.2.3 Database Logs
228
2
6.2.4 Database Configuration Parameters
230
3
6.2.5 Database and Table Space Backup
233
1
6.2.6 Using the Control Center Backup Database Notebook
234
3
6.2.7 Backup File Format
237
2
6.2.8 Database and Table Space Restore
239
8
6.2.9 Redefining Table Space Containers During Restore
247
1
6.2.10 Recovery History File
248
1
6.3 Database Backup and Recovery Using the SmartGuides
249
5
6.3.1 Backup Database SmartGuide
249
3
6.3.2 Restore Database SmartGuide
252
2
6.4 DB2 UDB for Windows NT Tape Support
254
9
6.4.1 Backing Up To Tape
259
1
6.4.2 Restoring From Tape
260
2
6.4.3 Disaster Recovery Considerations
262
1
Chapter 7. DB2 UDB Enterprise-Extended Edition
263
38
7.1 DB2 UDB EEE Concepts
263
8
7.1.1 Database Partition Servers per Machine
264
1
7.1.2 Coordinator Node
265
1
7.1.3 Nodegroups
265
2
7.1.4 The DB2 Node Configuration File
267
2
7.1.5 Partitioning
269
2
7.2 Managing DB2 UDB EEE Instances
271
10
7.2.1 Creating a Multipartition Instance
271
3
7.2.2 Updating a DB2 instance to a Multipartition System
274
1
7.2.3 Listing Instances
275
1
7.2.4 Starting a DB2 Instance
275
1
7.2.5 Stopping a DB2 Instance
276
1
7.2.6 Adding the DB2 Instance to the Control Center
277
3
7.2.7 Removing a DB2 Instance
280
1
7.3 Managing DB2 Database Partitions
281
2
7.3.1 Listing Database Partition Servers
281
1
7.3.2 Connecting to a Logical Node
281
2
7.4 Installing DB2 UDB EEE
283
18
7.4.1 Installation Pre-Requisites
283
1
7.4.2 Pre-Installation Tasks
284
5
7.4.3 Run the Installation Program
289
12
Chapter 8. Failover Support with DB2 UDB EEE
301
100
8.1 Microsoft Cluster Server
301
10
8.1.1 MSCS Concepts
302
1
8.1.2 Clusters of Nodes
302
1
8.1.3 Resources in MSCS
303
4
8.1.4 Virtual Server
307
1
8.1.5 Failover
308
2
8.1.6 Shared Disk versus Shared Nothing
310
1
8.2 DB2 UDB EEE Failover Support
311
31
8.2.1 DB2 UDB EEE Failover Configurations
311
2
8.2.2 Implementing a DB2 UDB EEE Instance with Failover Support
313
2
8.2.3 Using DB2MSCS to Enable MSCS Support
315
6
8.2.4 Using the Cluster Administrator to Enable MSCS Support
321
12
8.2.5 Registering Database Drive Mappings
333
4
8.2.6 Changing DB2 Node Configuration Information
337
1
8.2.7 Disabling DB2 Resource Failover to the second MSCS node
338
1
8.2.8 Failback Considerations
339
1
8.2.9 Application Support Considerations
340
1
8.2.10 Miscellaneous DB2 UDB EEE Concepts
341
1
8.3 Administering DB2 in an MSCS Environment
342
9
8.3.1 Starting and Stopping DB2 Resources
343
1
8.3.2 Running Scripts
343
5
8.3.3 Database Considerations
348
1
8.3.4 Windows NT User and Group Support
349
1
8.3.5 Communications Considerations
349
1
8.3.6 System Time Considerations
350
1
8.3.7 Administration Server and Control Center Considerations
350
1
8.3.8 Limitations and Restrictions
351
1
8.4 DB2 UDB EEE Two-Node Mutual Takeover Example
351
50
8.4.1 Creating the MSCS Cluster
352
12
8.4.2 Configuring DB2 UDB EEE and MSCS for Failover Support
364
26
8.4.3 Registering Database Drive Mappings for DB2
390
1
8.4.4 Configuring the DB2 Administration Server for MSCS Failover
391
2
8.4.5 Additional Configuration to Support FCM communications
393
4
8.4.6 Verifying Failover and Failback
397
4
Chapter 9. Performance Monitoring
401
40
9.1 Windows NT Performance Monitor
401
17
9.1.1 Registering DB2 Performance Counters
402
1
9.1.2 Using the NT Performance Monitor with DB2
403
15
9.2 DB2 UDB Monitoring
418
23
9.2.1 Snapshot Monitoring
419
11
9.2.2 Event Monitoring
430
11
Chapter 10. Problem Determination
441
50
10.1 Approach to DB2 UDB Problem Determination
441
1
10.2 Describing the Problem
442
1
10.2.1 Example Problem Descriptions
443
1
10.3 Gathering the Appropriate Diagnostic Information
443
15
10.3.1 Choosing the Correct Diagnostic Level
444
1
10.3.2 The DB2 Trace Facility
445
6
10.3.3 CLI/ODBC Traces
451
2
10.3.4 The Windows NT Event Log
453
3
10.3.5 Database Analysis and Repair Tool
456
2
10.4 Examining the Diagnostic Information
458
16
10.4.1 DB2DIAG.LOG File Entry Format
458
3
10.4.2 Dump Files
461
1
10.4.3 Trap Files
462
2
10.4.4 Formatting the DB2 Trace
464
1
10.4.5 The Format of a Trace Entry
465
1
10.4.6 Trace Information That is Not Captured
466
1
10.4.7 Verifying That the Error Has Been Captured
467
1
10.4.8 Examining a CLI/ODBC Trace
467
7
10.5 Determining the Source of the Problem
474
9
10.5.1 Online Help
474
4
10.5.2 DB2 Technical Library on the Web
478
5
10.6 Installation Problems
483
4
10.6.1 Common Installation Errors
484
3
10.7 Information to Collect for IBM Support
487
4
10.7.1 What to Collect
487
1
10.7.2 History of Reported Problems
488
3
Appendix A. Related Publications
491
2
A.1 International Technical Support Organization Publications
491
1
A.2 Other Publications
491
2
Index
493