Muutke küpsiste eelistusi

DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Study Guide [Pehme köide]

2.00/5 (1 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 1248 pages, kõrgus x laius x paksus: 229x178x76 mm, kaal: 1619 g
  • Ilmumisaeg: 01-Sep-2015
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583473750
  • ISBN-13: 9781583473757
Teised raamatud teemal:
DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Study GuideSuurem pilt
  • Formaat: Paperback / softback, 1248 pages, kõrgus x laius x paksus: 229x178x76 mm, kaal: 1619 g
  • Ilmumisaeg: 01-Sep-2015
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583473750
  • ISBN-13: 9781583473757
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781583473757.html
Much more than a simple certification study aid, this comprehensive 1,248 page book is designed to help you master all aspects of IBM DB2 database administration and prepare you to take and pass IBM's Certification Exams 611 and 311: Certified Database Administrator. Building on years of extensive hands-on experience, the authors step you through all the areas covered on the test. The book dives deep inside each certification topic: DB2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, security, and connectivity and networking. There is even a "crash course" chapter on DB2 10.5 features. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book provides more than 400 practice questions and answers, more than 120 "flash cards" to help you study for the exam, and 50 step-by-step DB2 feature implementation procedures.

Arvustused

"This resource is designed to give the DB2 professional the information required in order to successfully obtain certification, or even to simply enhance their existing scope of DB2 knowledge. The authors have done an excellent job of distilling their many years of experience, both within the lab environment and within the live production environment into a logical, well-organized reference. Each section contains the fundamentals, plus valuable insights from the authors, and is backed up with sample exam questions, as well as detailed answers . . . . I am confident that with this guide, your certification will not be far away!" Eric Sheley, Global IT Director, FTSE 100 Global Consumer Goods Company

About the Authors v
Acknowledgments vii
Foreword xix
1 IBM DB2 10.1 Certification 1(22)
DB2 10.1 Certification Roles
1(1)
DB2 10.1 Certification Tracks
2(7)
The Certification Process
9(3)
Taking an IBM Certification Exam
12(11)
2 DB2 Server Management 23(138)
Exam Objectives
23(1)
Working with Instances
24(10)
Configuring the DB2 System Environment
34(7)
Configuring DB2 Instances and Databases
41(35)
DB2 Autonomic Computing Features
76(8)
Automatic Storage
84(4)
Data Compression
88(1)
Automatic Database Maintenance
89(10)
The Configuration Advisor
99(4)
Adaptive Utility Throttling
103(3)
Taking Control of a DB2 Server
106(4)
Working with IBM Data Studio
110(1)
Connecting to Instances and Databases
111(3)
Generating Data Definition Language Scripts
114(1)
Performing Database Administration Tasks
114(1)
Performing Database Development Tasks
115(1)
Scheduling Database Jobs
116(7)
Analyzing SQL Queries
123(4)
Chapter Summary
127(1)
Practice Questions
128(18)
Answers
146(15)
3 Physical Design 161(146)
Exam Objectives
161(1)
Servers, Instances, and Databases
162(1)
DB2 Database Objects
162(1)
Creating a DB2 Database
163(7)
A Complete CREATE DATABASE Command
170(5)
Design Aspects of Databases
175(3)
Buffer Pools
178(4)
Table Spaces
182(18)
Reclaimable Storage
200(5)
Storage Groups
205(4)
Schemas
209(4)
Range Clustering and Range Partitioning Tables
213(1)
Range Clustered Tables
213(2)
Range Partitioned Tables
215(7)
Multi-temperature Storage
222(9)
Time Travel Query Using Temporal Tables
231(8)
Utilities, Tools, and File Type Modifiers
239(1)
Restrictions for System-Period Temporal Tables
240(1)
Application-Period Temporal Tables
241(5)
Bitemporal Period Tables
246(5)
Working with XML Data
251(11)
Data Compression
262(7)
DB2 9.7-Increasing the Compression Landscape
269(4)
Chapter Summary
273(1)
Practice Questions
274(20)
Answers
294(13)
4 Business Rules Implementation 307(82)
Exam Objectives
307(1)
Business Rules
308(1)
Not Null Constraints
308(2)
Default Constraints
310(3)
Check Constraints
313(3)
Unique Constraints
316(4)
Referential Integrity Constraints
320(17)
Informational Constraints
337(2)
The Set Integrity Command
339(5)
Creating Tables and Constraints
344(7)
Creating Views with the Check Option
351(7)
Creating and Using Triggers
358(12)
Chapter Summary
370(1)
Practice Questions
371(11)
Answers
382(7)
5 Monitoring DB2 Activity 389(180)
Exam Objectives
389(1)
The Database System Monitor
390(1)
The Snapshot Monitor
391(14)
Table Functions for Monitoring
405(24)
Functions Quick Reference
429(1)
Administrative Views for Monitoring
430(1)
Buffer Pool Hit Ratio and I/O Response Time
431(1)
Currently Running Expensive SQL Statement
432(1)
Current Lock-wait Chains in the Database
433(1)
Understanding Your Table Spaces
434(1)
Getting to Know Your Database Server
435(2)
Event Monitors
437(7)
Event Types and Examples
444(23)
Reading Unformatted Event Data
467(8)
Unformatted Event Data Format Table Functions
475(14)
Analyzing SQL with the Explain Facility
489(1)
The Explain Tables
490(1)
Collecting Explain Data
491(5)
Evaluating Explain Data
496(16)
DB2 Troubleshooting Tools
512(1)
Obtaining Information About an Error Code
513(1)
Reason Codes
514(1)
The db2diag Utility
515(1)
First Occurrence Data Capture (FODC)
516(6)
The DB2 Diagnostic Log File
522(1)
The Administration Notification Log
523(1)
Controlling How Much Information Is Collected
523(1)
Interpreting the Notification and Diagnostic Log Entries
524(2)
The db2pdcfg Command
526(4)
The db2bfd Command
530(2)
The db2val Command
532(3)
The db2mtrk Command
535(3)
The db2pd Command
538(5)
The db2top Command
543(4)
The db2trc Command
547(3)
The inspect Command
550(2)
The db2dart Command
552(2)
The db2support Tool
554(1)
Chapter Summary
554(1)
Practice Questions
555(8)
Answers
563(6)
6 DB2 Utilities 569(150)
Exam Objectives
569(1)
Data Movement Utilities and File Formats
570(1)
Data Movement File Formats
570(4)
Extracting Columnar Data from External Files
574(2)
The DB2 Export Utility
576(8)
The DB2 Import Utility
584(27)
The DB2 Load Utility
611(3)
The Four Phases of a Load Operation
614(1)
Performing a Load Operation
615(15)
Loading XML Data
630(1)
Loading from a CURSOR
631(1)
Loading from a Pipe
632(1)
A Nonrecoverable Load Operation
633(1)
Monitoring a Load Operation
634(2)
The Set Integrity Command
636(2)
The DB2 Ingest Utility
638(5)
Formatting the Input Values
643(3)
Ingesting Data from a Pipe
646(1)
DML Operations
647(4)
DB2 Ingest Parameters
651(1)
Handling Ingest Data Problems
652(3)
Recovering a Failed Ingest Command
655(3)
Monitoring Ingest Operations
658(1)
Ingest Performance Tuning Tips
659(1)
Comparison Between Ingest, Load, and Import Utilities
660(1)
Ingest Utility Limitations
660(1)
Other DB2 Data Movement Options
661(13)
Relocate a Database by Using db2relocatedb
674(5)
The db2move and db2look Commands
679(1)
Database Maintenance Utilities
680(1)
The REORGCHK Utility
680(1)
The REORG Utility
681(3)
The RUNSTATS Utility
684(2)
The Rebind Utility
686(1)
Flushing the Package Cache
687(1)
Performance-related Utilities
688(1)
The db2batch Utility
688(4)
The DB2 Design Advisor
692(7)
Chapter Summary
699(1)
Practice Questions
700(10)
Answers
710(9)
7 High Availability 719(106)
Exam Objectives
719(1)
Transactions
720(3)
Transaction Logging
723(2)
Transaction Logging Strategies
725(3)
Other Logging Considerations
728(1)
Controlling How "Disk Full" Errors Are Handled
729(1)
Database Recovery Concepts
730(3)
Recoverable and Nonrecoverable Databases
733(1)
Online Versus Offline Backup and Recovery
734(1)
Incremental and Delta Backup and Recovery
734(2)
Performing a Crash Recovery Operation
736(3)
Backup and Recovery
739(32)
Rebuilding Invalid Indexes
771(1)
Backing Up a Database with Split Mirroring
772(3)
Initializing a Split Mirror with db2inidb
775(1)
High Availability Disaster Recovery (HADR)
776(1)
Requirements for HADR Environments
777(2)
Read on Standby Feature
779(2)
Read On Standby Restrictions
781(1)
HADR Multiple Standbys
782(1)
Setting Up an HADR Multiple Standby Environment
783(6)
Load Operations and HADR
789(2)
DB2 pureScale-An Overview
791(3)
Working with a pureScale Cluster
794(3)
Chapter Summary
797(1)
Practice Questions
798(17)
Answers
815(10)
8 DB2 Security 825(112)
Exam Objectives
825(1)
Controlling Database Access
826(1)
Authentication
826(1)
Where Does Authentication Occur?
826(3)
Security Plug-ins
829(1)
Trusted and Untrusted Clients
830(1)
Authorities and Privileges
831(1)
Authorities
832(9)
Privileges
841(10)
Granting Authorities and Privileges
851(1)
Granting Authorities and Privileges from IBM Data Studio
852(1)
Granting Authorities and Privileges with the GRANT command
853(7)
GRANT SQL Statement Examples
860(1)
Revoking Authorities and Privileges with the REVOKE SQL Statement
861(7)
REVOKE SQL Statement Examples
868(1)
Requirements for Granting and Revoking Authorities and Privileges
869(1)
Authorities and Privileges Needed to Perform Common Tasks
870(2)
Role-based Access Control
872(1)
A Comparison Between Roles and Groups
873(6)
Trusted Contexts and Trusted Connections
879(4)
Securing Data with Label-based Access Control
883(1)
Implementing Row-level LBAC
883(1)
Defining a Security-label Component
884(1)
Defining a Security Policy
885(1)
Defining Security Labels
886(2)
Creating a LBAC-Protected Table
888(1)
Granting Security Labels to Users
889(1)
Putting Row-level LBAC into Action
890(2)
Implementing Column-level LBAC
892(1)
Defining a Security-label Component
892(1)
Defining a Security Policy
893(1)
Defining Security Labels
893(1)
Creating an LBAC-Protected Table
893(1)
Granting Security Labels to Users
894(1)
Creating LBAC-Protected Columns
895(1)
LBAC Rule Set-DB2LBACRULES
896(1)
LBAC Rule Exemptions
897(1)
Putting Column-level LBAC into Action
898(1)
Combining Row-level and Column-level LBAC
899(2)
Row and Column Access Control
901(1)
Implementing Row Permissions
901(5)
Understanding the DML Behavior Under RCAC
906(1)
Deactivating the Row Access Control
907(1)
Creating Column Masks
907(4)
Built-in Scalar Functions
911(1)
Advantages of Using RCAC
911(1)
The DB2 Audit Facility
912(1)
db2audit Tool Command
913(3)
AUDIT SQL Statements
916(3)
Chapter Summary
919(1)
Practice Questions
920(9)
Answers
929(8)
9 Connectivity and Networking 937(48)
Exam Objectives
937(1)
Configuring Communications
937(2)
Manually Configuring DB2 Server Communications
939(3)
DB2 Directory Files
942(4)
Cataloging Remote Servers and Databases
946(1)
Cataloging a DB2 Database
946(4)
Cataloging a Remote DB2 Node (Server)
950(3)
Cataloging a DCS Database
953(1)
Binding Utilities and Applications
954(3)
Configuring Communications to System z and System i
957(1)
DB2 Discovery
957(5)
Fast Communications Manager (FCM)
962(3)
Configuring LDAP Connections
965(1)
Registering the DB2 Server with LDAP
966(2)
Registering the DB2 Database with LDAP
968(1)
Deregistering the DB2 Server from LDAP
968(1)
Deregistering the DB2 Database from LDAP
968(1)
Troubleshooting Communications Errors
969(1)
Chapter Summary
970(1)
Practice Questions
971(6)
Answers
977(8)
10 DB2 10.5 Exam Crash Course 985(180)
Exam Objectives
985(1)
DB2 Server Management
986(11)
The pureScale Model
997(8)
Managing Access to the Database Server
1005(1)
Groups, Roles, User IDs
1006(2)
BLU Technology
1008(13)
Deep Dive into BLU
1021(2)
Separate Row and Column Instances on a Database Server
1023(8)
BLU Social
1031(1)
Physical Design
1031(15)
JSON
1046(1)
Configuring the Database
1047(2)
Managing JSON
1049(1)
Working with Data Studio V4.1.1
1049(1)
Configuring a DB2 Database
1050(9)
Tuning SQL
1059(9)
Workload Management
1068(4)
Changing a Database's Code Set
1072(1)
Using Export
1073(1)
Shadow Tables
1074(1)
Deploying Shadow Tables
1075(30)
Utilities: Converting Row Tables to Column
1105(1)
Reclaiming Deleted Space in Column-Organized Tables
1106(1)
PureScale
1107(15)
Backup and Restore Enhancements
1122(9)
Supporting Multiple Databases in pureScale
1131(1)
CF Self-Tuning Memory Feature
1131(1)
Monitoring DB2 Activity
1132(9)
Connectivity and Networking
1141(4)
High Availability
1145(1)
The "Oops" Recovery Factor
1146(1)
Chapter Summary
1147(1)
Practice Questions
1148(13)
Answers
1161(4)
11 DB2 10.1/10.5 Question Bank 1165(48)
Practice Questions
1165(29)
Answers
1194(19)
Appendix A: DSFA Guidelines 1213(14)
Appendix B: Resources 1227
Robert Collins, a resident of Kansas, is passionate about his region. He has authored several books on the history and sightseeing possibilities of Kansan railroads as well as the biography General James G. Blunt: Tarnished Glory and continues to write articles on history and science fiction for several magazines.