Muutke küpsiste eelistusi

DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737 [Pehme köide]

4.50/5 (4 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 350 pages, kõrgus x laius x paksus: 229x178x23 mm, kaal: 553 g
  • Ilmumisaeg: 15-Aug-2010
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583470964
  • ISBN-13: 9781583470961
Teised raamatud teemal:
DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737Suurem pilt
  • Formaat: Paperback / softback, 350 pages, kõrgus x laius x paksus: 229x178x23 mm, kaal: 553 g
  • Ilmumisaeg: 15-Aug-2010
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583470964
  • ISBN-13: 9781583470961
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781583470961.html

Written with system administrators in mind, this reference offers information about both DB2 and z/OS operating systems as well as guidance for preparing for the IBM Certification Test 737. Helpful and thorough, this technical guide summarizes the new features of DB2 9 environments and provides essential system administration information, such as installation and maintenance procedures. With chapters on troubleshooting, performance and tuning, and securing and auditing, as well as practice questions, this reference is a one-stop shop for DB2 system administrators.

Chapter 1 Introduction to DB2 9 for z/OS
1(4)
Purpose of the Book
1(1)
Test 737: DB2 9 System Administrator for z/OS
1(1)
Certification Web Site
2(1)
DB2 System Administration Requirements
3(2)
Chapter 2 DB2 for z/OS Overview
5(102)
CSECTs and Subcomponents
5(1)
DB2 Resource Managers
6(1)
Address Spaces
6(5)
Work Requests in DB2
11(1)
DB2 9 System Structure Basics
12(1)
Attachment Facilities
13(1)
Threads
14(1)
Storage
15(2)
Distributed Data Facility
17(2)
DDF and z/OS Shared Virtual Memory
19(4)
Distributed Thread Processing
23(2)
Private Protocol Access
25(1)
Native Stored Procedures in DB2 9
26(1)
Database Management
26(6)
DB2 Directory
32(1)
EDM Pool
32(8)
SYSUTILX
40(1)
SYSLGRNX
41(1)
Catalog/Directory Access Methods
41(2)
Storage Above and Below the Bar
43(2)
Storage Pools
45(1)
MAXKEEPD
46(1)
Stored Procedures
46(1)
DSN1CHKR
47(1)
BINDNV DSNZPARM
47(1)
RID Pools
48(2)
Physical Rows and Pages for Table Spaces
50(5)
Base and Clone Tables
55(1)
Universal Table Spaces
56(1)
Index Structure
57(1)
BRF and RRF Formats and Logging
58(1)
Index Compression
59(2)
Active Logs
61(13)
Virtual Buffer Pools
74(4)
Work File Database
78(4)
Sort Pool
82(1)
System Error Reporting
83(3)
DB2 Tools for Problem Diagnosis
86(7)
Storage Management Subsystem
93(3)
Parallel Sysplex and DB2
96(1)
Workload Manager
97(2)
Enclave
99(1)
Stored Procedures
100(1)
Administrative Tasks
100(1)
z9 Processor and Specialty Engines
101(2)
Practice Questions
103(4)
Chapter 3 Installation and Migration
107(82)
Preparing to Install or Migrate
107(2)
Program Directories
109(2)
DB2 Products and Features
111(4)
Release Information for DB2 9 for z/OS
115(2)
How the DB2 Support Level is Maintained
117(9)
How, Where, and When Do You Apply Maintenance?
126(7)
DB2 SMP/E Data Sets
133(1)
System Managed Storage
133(1)
Consolidated Service Test (CST)
133(1)
Acquiring Fixes
134(1)
Obtaining RSUs Using ShopzSeries
135(2)
Software Subscription and Support at IBM
137(1)
V8-to-V9 Release Incompatibilities and Preplanning
137(9)
V8-to-V9 Migration and Installation: Changes and Incompatibilities
146(2)
Tailoring DB2 Jobs and the Installation CLIST
148(23)
Installation, Migration, Fallback, and Remigration
171(6)
A Closer Look at Migration Modes
177(5)
Enhancements to the Installation CLIST and Panels
182(3)
Practice Questions
185(4)
Chapter 4 Security and Auditing
189(30)
IBM Security Solutions
189(1)
Data Security in DB2
190(1)
Encryption Solutions for DB2
190(3)
User Authentication
193(1)
Trusted Context and Role-Based Security
193(4)
Defining Trusted Contexts
197(1)
Trusted Connections
198(2)
Setting Authorization in DB2 Security
200(1)
Administrative Authorities
201(3)
Authorization Checking with RACF
204(5)
Multilevel Security in DB2
209(1)
DB2 Column-Level Encryption
210(1)
Encryption at the Hardware Level
211(1)
Tools for Auditing
212(1)
DB2 Audit Trace
213(2)
DB2 Audit Trace
215(1)
Practice Questions
216(3)
Chapter 5 System Backup and Recovery
219(38)
System-Level Requirements
219(1)
REPORT RECOVERY Utility
220(2)
MODIFY RECOVERY Utility
222(1)
System Disaster Recovery Process
223(12)
Helpful Commands
235(2)
Data Sharing
237(1)
BACKUP SYSTEM and RESTORE SYSTEM
237(9)
RESTORE SYSTEM
246(1)
Recovery Point
247(2)
Recovery Scenarios
249(3)
DB2 Tracker
252(1)
Practice Questions
253(4)
Chapter 6 Performance and Tuning
257(48)
Key Elements in Tuning
257(1)
Tracing DB2
258(10)
Trace Commands
268(5)
Performance and the EDM Pool
273(4)
Automated Memory Monitoring
277(1)
Virtual Buffer Pools
277(2)
Read Methods
279(2)
WRITE Operations
281(1)
Buffer Pool Thresholds
281(7)
Buffer Pool Hit Ratios
288(2)
Buffer Pool Page Management
290(1)
Buffer Pool Statistics
291(1)
How Buffer Pools Affect Performance
292(1)
Automatic Buffer Pool Management
293(1)
Sort Pool
294(1)
Work Files and the DSNDB07 Database
295(2)
EDM Pool
297(1)
Dynamic Cache
298(1)
DBD Structures
299(1)
RID Pool
299(1)
Workload Manager and Stored Procedures
299(1)
Thread Management
300(1)
Maximum Number of Data Sets
300(1)
Practice Questions
301(4)
Chapter 7 Systems Operations and Troubleshooting
305(50)
Managing DB2 Components and Processes
305(4)
DB2 Commands
309(15)
z/OS IRLM Commands
324(2)
DB2 Utilities
326(7)
DB2 Subsystem Recommendation
333(1)
MVS Commands
333(1)
Stand-Alone Utilities
334(3)
Log Formats
337(1)
Log Performance
337(1)
Problem Resolution Methods
338(1)
Space Issues
339(3)
WLM and Stored Procedures
342(1)
Changing VCAT Names
343(1)
CATMAINT
344(1)
Uncompressed Log Records
344(1)
EDM Pool
344(1)
DBD Size
344(1)
Data Sharing
345(6)
DB2 Administration Tool
351(1)
Practice Questions
352(3)
Appendix A DB2 Message Numbers
355(2)
Appendix B References
357(4)
Useful Web Sites
357(1)
DB2 9 for z/OS Manuals
357(1)
Program Directories for DB2 9 for z/OS
358(1)
Program Directories for DB2 9 for z/OS VUE
359(1)
Program Directories for DB2 Accessories Suite for z/OS
359(2)
Appendix C Answers to the Practice Questions
361
Chapter 2
361(4)
Chapter 3
365(4)
Chapter 4
369(4)
Chapter 5
373(4)
Chapter 6
377(4)
Chapter 7
381
Judy H. Nall is an internationally recognized lecturer, consultant, writer, educator, and expert in DB2. She is the president of Computer Business International, Inc., a member of the IBM DB2 Gold Consultants Group, and the recipient of an IBM Data Champion award for contributions to the IBM Data Management community. She lives in Reno, Nevada.