Muutke küpsiste eelistusi

Universal Guide to DB2 for Windows NT [Multiple-component retail product]

, ,
  • Formaat: Multiple-component retail product, 528 pages, kõrgus x laius x paksus: 233x175x34 mm, kaal: 1020 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 30-Dec-1998
  • Kirjastus: IBM Press
  • ISBN-10: 0130997234
  • ISBN-13: 9780130997234
Teised raamatud teemal:
  • Multiple-component retail product
  • Hind: 68,36 €*
  • * 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
Universal Guide to DB2 for Windows NTSuurem pilt
  • Formaat: Multiple-component retail product, 528 pages, kõrgus x laius x paksus: 233x175x34 mm, kaal: 1020 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 30-Dec-1998
  • Kirjastus: IBM Press
  • ISBN-10: 0130997234
  • ISBN-13: 9780130997234
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780130997234.html
Märksõnad:
If you're faced with designing, building, administering and tuning DB2 Universal Database 5.0 on NT - or passing IBM's challenging DB2 certification exams - this end-to-end guide was written just for you. In this book, an IBM team of DB2 experts introduces you to the DB2 family of products running on Windows NT, and shows how these products fully leverage Windows NT's power and security features. Understand DB2's data storage model, configure DB2 as a database server or DRDA gateway to communicate with remote clients, and provide remote access - including access for ODBC-based applications. You'll find detailed coverage of monitoring DB2 objects using both Windows NT's Performance Monitor utility and DB2-specific utilities provided by IBM. Discover how DB2 works with Windows NT's trusted domains; how to enable NetBIOS protocol support; how to perform DB2 traces on NT, and more. Finally, there is comprehensive coverage of troubleshooting errors and problems specific to DB2 on Windows NT.

Muu info

If you're faced with designing, building, administering and tuning DB2 Universal Database 5.0 on NT - or passing IBM's challenging DB2 certification exams - this end-to-end guide was written just for you. In this book, an IBM team of DB2 experts introduces you to the DB2 family of products running on Windows NT, and shows how these products fully leverage Windows NT's power and security features. Understand DB2's data storage model, configure DB2 as a database server or DRDA gateway to communicate with remote clients, and provide remote access - including access for ODBC-based applications. You'll find detailed coverage of monitoring DB2 objects using both Windows NT's Performance Monitor utility and DB2-specific utilities provided by IBM. Discover how DB2 works with Windows NT's trusted domains; how to enable NetBIOS protocol support; how to perform DB2 traces on NT, and more. Finally, there is comprehensive coverage of troubleshooting errors and problems specific to DB2 on Windows NT.
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
Jonathon Cook, Calene Janacek and Dwaine Snoware software professionals at IBM's International Technical Support Organization, Austin, TX.