LEADER 04664nam 2200601 450 001 9910460827703321 005 20200520144314.0 010 $a1-58347-716-0 035 $a(CKB)3710000000571479 035 $a(EBL)4306695 035 $a(SSID)ssj0001678996 035 $a(PQKBManifestationID)16489565 035 $a(PQKBTitleCode)TC0001678996 035 $a(PQKBWorkID)15023486 035 $a(PQKB)10262025 035 $a(MiAaPQ)EBC4306695 035 $a(Au-PeEL)EBL4306695 035 $a(CaPaEBR)ebr11137765 035 $a(CaONFJC)MIL848446 035 $a(OCoLC)934197927 035 $a(EXLCZ)993710000000571479 100 $a20160113h20152015 uy| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDB2 10.1/10.5 for Linux, UNIX, and Windows database administration $ecertification study guide /$fMohankumar (Mohan) Saraswatipura and Robert (Kent) Collins 205 $aFirst edition. 210 1$aBoise, ID :$cMC Press Online, LLC,$d[2015] 210 4$dİ2015 215 $a1 online resource (1248 p.) 300 $aDescription based upon print version of record. 311 $a1-58347-375-0 327 $aFront 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 Server 327 $aWorking 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 Tables 327 $aRange 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 Constraints 327 $aInformational 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 Server 327 $aEvent 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 Command 327 $aThe db2val Command 606 $aDatabase management$xExaminations$vStudy guides 608 $aElectronic books. 615 0$aDatabase management$xExaminations 676 $a005.7565 700 $aSaraswatipura$b Mohankumar$0884127 702 $aCollins$b Robert 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910460827703321 996 $aDB2 10.1$92214132 997 $aUNINA