search for books and compare prices
Tables of Contents for The DB2 Universal Drda Certification Guide
Chapter/Section Title
Page #
Page Count
Preface
xi
 
How This Book was Created
xiv
 
Chapter 1. Overview
1
20
1.1 DB2 Family of Products
1
2
1.1.1 DB2 Universal Database--The Scalable Database
2
1
1.2 DB2 UDB Family of Products
3
2
1.3 DB2 Connect
5
5
1.3.1 DB2 Connect Personal Edition
6
1
1.3.2 DB2 Connect Enterprise Edition
7
1
1.3.3 DB2 Connect Features
8
2
1.4 Introduction to DRDA
10
11
1.4.1 SQL as Common DRDA Database Access Language
11
1
1.4.2 Application Requester and Application Server
11
1
1.4.3 Unit of Work
12
1
1.4.4 Openness
13
1
1.4.5 Comparing DRDA-1 and DRDA-2
13
2
1.4.6 Controlling Two-Phase Commit
15
1
1.4.7 SPM Scenarios
16
5
Chapter 2. DRDA Using SNA
21
54
2.1 Introduction to SNA
21
1
2.2 DB2 Universal Database
22
26
2.2.1 DB2 Connect (DB2 UDB as an Application Requester)
24
18
2.2.2 DB2 UDB as an Application Server
42
6
2.3 DB2 for OS/390
48
12
2.3.1 DB2 for OS/390 as an Application Requester
49
8
2.3.2 DB2 for OS/390 as an Application Server
57
3
2.4 AS/400
60
15
2.4.1 Common Steps for Both AR and AS
60
4
2.4.2 AS/400 as an Application Requester
64
7
2.4.3 AS/400 as an Application Server
71
4
Chapter 3. DRDA Using TCP/IP
75
36
3.1 Introduction to TCP/IP
75
2
3.2 DB2 Universal Database
77
20
3.2.1 DB2 Connect (DB2 UDB as an Application Requester)
79
15
3.2.2 DB2 UDB as an Application Server
94
3
3.3 DB2 for OS/390
97
7
3.3.1 DB2 for OS/390 as an Application Requester
97
4
3.3.2 DB2 for OS/390 as an Application Server
101
3
3.4 AS/400
104
7
3.4.1 AS/400 as an Application Requester
104
3
3.4.2 AS/400 as an Application Server
107
4
Chapter 4. Considerations when Configuring a Gateway
111
24
4.1 Setup Communications on the Gateway
112
9
4.1.1 Setup Gateway Communications Using the Control Center
113
3
4.1.2 Setup Communications on the Gateway Using the CLP
116
5
4.2 Configuring the Administration Server on the Gateway
121
3
4.3 Cataloging on the Clients
124
11
4.3.1 Cataloging on the Client using the CCA
125
5
4.3.2 Using the Command Line Processor
130
5
Chapter 5. Performance and System Management Considerations
135
30
5.1 Binding DB2 Connect Utilities
135
4
5.1.1 Binding Privileges
136
1
5.1.2 Bind Files and Packages
137
1
5.1.3 Bind Command
138
1
5.2 Security Considerations
139
14
5.2.1 UDB DRDA AR Using SNA Via a Direct Connection
139
4
5.2.2 UDB DRDA AR Using SNA Via a Gateway Connection
143
4
5.2.3 UDB DRDA AR Using TCP/IP Via a Direct Connection
147
1
5.2.4 UDB DRDA AR Using TCP/IP Via a Gateway Connection
148
2
5.2.5 UDB as a DRDA AS
150
3
5.3 Connection Limits
153
5
5.3.1 SNA Configurations
153
2
5.3.2 VTAM
155
2
5.3.3 DB2 for OS/390
157
1
5.3.4 Other Factors Related to Connection Limits
158
1
5.4 Performance Considerations
158
7
5.4.1 Problem Source Identification
159
1
5.4.2 Network Hardware Considerations
159
3
5.4.3 VTAM
162
1
5.4.4 Communication System Tuning
162
1
5.4.5 DB2 Connect
163
1
5.4.6 Application Design
163
1
5.4.7 CLI/ODBC keywords
164
1
Chapter 6. Diagnostic Tips and Techniques
165
46
6.1 Problem Determination Objectives
165
1
6.2 Approach to Problem Determination and Resolution
166
17
6.2.1 Failure to Connect
167
12
6.2.2 Failure to Execute SQL Statements
179
2
6.2.3 Performance Problems
181
2
6.3 PD/PSI Tools
183
28
6.3.1 DB2 UDB Logs
183
2
6.3.2 Operating System Logs
185
1
6.3.3 DB2 UDB Traces
185
9
6.3.4 The SNA Layer
194
15
6.3.5 DB2 CLI Traces
209
2
Appendix A. Test Objectives
211
10
A.1 Objectives
211
1
A.1.1 DRDA Concepts
211
1
A.1.2 Setup APPC Communications for DB2 Connect and DRDA
211
1
A.1.3 Alternative DB2 Connect/DRDA Communication Protocols
212
1
A.2 Questions
212
7
A.3 Answers
219
2
Appendix B. SNA Configuration
221
46
B.1 Comms Server for NT and PComms for NT
223
11
B.2 Integrated SNA Support
234
4
B.3 Microsoft SNA Server
238
8
B.4 IBM Comms Server for AIX
246
7
B.5 IBM Comms Server for OS/2
253
14
Appendix C. TCP/IP Configuration
267
18
C.1 TCP/IP Configuration on Windows NT
267
6
C.2 TCP/IP Configuration on OS/2
273
6
C.3 TCP/IP Configuration on the AS/400
279
6
Appendix D. Related Publications
285
 
D.1 International Technical Support Organization Publications
285
1
D.2 Other Publications
285