04631nam 2200589 450 991082204110332120230807205912.01-58347-716-0(CKB)3710000000571479(EBL)4306695(SSID)ssj0001678996(PQKBManifestationID)16489565(PQKBTitleCode)TC0001678996(PQKBWorkID)15023486(PQKB)10262025(MiAaPQ)EBC4306695(Au-PeEL)EBL4306695(CaPaEBR)ebr11137765(CaONFJC)MIL848446(OCoLC)934197927(EXLCZ)99371000000057147920160113h20152015 uy| 0engur|n|---|||||txtccrDB2 10.1/10.5 for Linux, UNIX, and Windows database administration certification study guide /Mohankumar (Mohan) Saraswatipura and Robert (Kent) CollinsFirst edition.Boise, ID :MC Press Online, LLC,[2015]©20151 online resource (1248 p.)Description based upon print version of record.1-58347-375-0 Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 ServerWorking with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning TablesRange Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity ConstraintsInformational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database ServerEvent MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd CommandThe db2val CommandDatabase managementExaminationsStudy guidesDatabase managementExaminations005.7565Saraswatipura Mohankumar1618807Collins RobertMiAaPQMiAaPQMiAaPQBOOK9910822041103321DB2 10.13950746UNINA