LEADER 05112nam 2200553 a 450 001 9910790632403321 005 20230829003023.0 010 $a1-58347-645-8 035 $a(CKB)2550000001135456 035 $a(EBL)906300 035 $a(OCoLC)793166727 035 $a(MiAaPQ)EBC906300 035 $a(Au-PeEL)EBL906300 035 $a(CaPaEBR)ebr10558299 035 $a(CaONFJC)MIL535164 035 $a(EXLCZ)992550000001135456 100 $a20120524d2006 uy 0 101 0 $aeng 135 $aurcn||||||||| 200 10$aDB2 10 for z/OS database administration$b[electronic resource] $ecertification study guide /$fSusan Lawson, Daniel Luksetich 205 $a1st ed. 210 $aKetchum, Idaho $cMC Press$d2006 215 $a1 online resource (1009 p.) 300 $a"Exam 612"--Cover. 311 $a1-58347-369-6 311 $a1-306-03913-4 320 $aIncludes bibliographical references and index. 327 $aCover; Acknowledgments; Copyright; Contents; Introduction IBM DB2 10 for z/OS Certified Database Administrator ; 1: DB2 Product Fundamentals; DB2 and the On Demand Business; The DB2 Product Family; DB2 Middleware and Connectivity; InfoSphere Optim Data Lifecycle Management for DB2; Additional DB2 Application Development and Administration; Summary and Resources; Practice Questions and Answers; 2: Environment; z/OS; DB2 for z/OS; DB2 and Security; Parallel Sysplex Support; Storage Management Subsystem; DB2 Interfaces; Installation, Migration, and Conversion; DSNZPARMs; Commands 327 $aDB2 Utilities Catalog and Directory; Distributed Data; Memory Management; Summary and Resources; Practice Questions and Answers; 3: Access and Security; DB2 Subsystem Access; Data Set Protection; Encryption; DB2 Object Access; Multilevel Security; Auditing; Summary and Resources; Practice Questions and Answers; 4: Database Objects; Understanding Data Structures; Managing Database Objects; Data Types; Tables; Sequence Objects; Table Spaces; Views; Materialized Query Tables; Clone Tables; Temporal Tables; Hash Tables (Tables with Hash Access Enabled); Indexes; Databases; Storage Groups 327 $aDatabase Design and Implementation Sample Implementation; Summary and Resources; Practice Questions and Answers; 5: Retrieving and Manipulating Database Objects; Data Retrieval; Data Modification; Summary and Resources; Practice Questions and Answers; 6: Advanced SQL Coding; Subqueries; Unions; Excepts; Intersects; Nested Table Expressions; Common Table Expressions; Data Change Tables; Joins; ORDER BY and FETCH FIRST in Subselects and Fullselects; CASE Expressions; Row Expressions; PureXML Usage; OLAP Specification; Predicates and Filtering; Summary and Resources 327 $aPractice Questions and Answers 7: Maintaining Data; Data Movement; Data Maintenance; Rebuilding Indexes; Data Statistics; Real-Time Statistics; Data Maintenance Process; Diagnose Utility; Standalone Utilities; Displaying Utilities; Resolving Restrictive and Advisory States; Summary and Resources; Practice Questions and Answers; 8: Recovery and Restart; Database Recovery Concepts; Logging; Image Copies; Establishing a Point of Consistency; Recovery Concepts; System-Level Backup and Recovery; Backup and Recovery of the DB2 Catalog and Directory; Disaster Recovery; LOB and XML Recovery 327 $aTracker Site Recovery DB2 Restart; Data Sharing Recovery; Summary and Resources; Practice Questions and Answers; 9: Data Sharing; Data Sharing Benefits; Data Sharing Components; Shared Data; Maintaining Data Integrity; Performance; Processing Costs; Movement to Data Sharing; Workload Management and Affinity Processing; Submitting Work; Communicating with a Data Sharing Group; Sysplex Query Parallelism; Recovery Considerations; Summary and Resources; Practice Questions and Answers; 10: Using SQL in an Application Program; Delimiting SQL in a Program; Declaring Table and View Definitions 327 $aSQL Execution Validation 330 $aWritten primarily for database administrators who work on z/OS and who are taking the IBM DB2 10 for z/OS Database Administration certification exam (Exam 612), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator of z/OS mainframes. The guide covers all the topics on the exam, including database design and implementation, operation and recovering, security and auditing, performance, and installation and migration. Complete with sample questions and detailed answers; as well as a full-length practice exam; this study guide service 606 $aElectronic data processing personnel$xCertification 606 $aDatabase management 615 0$aElectronic data processing personnel$xCertification. 615 0$aDatabase management. 676 $a005.75/85 676 $a005.7585 700 $aLawson$b Susan$01487931 701 $aLuksetich$b Dan$01487932 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910790632403321 996 $aDB2 10 for z$93708057 997 $aUNINA