05112nam 2200553 a 450 991079063240332120230829003023.01-58347-645-8(CKB)2550000001135456(EBL)906300(OCoLC)793166727(MiAaPQ)EBC906300(Au-PeEL)EBL906300(CaPaEBR)ebr10558299(CaONFJC)MIL535164(EXLCZ)99255000000113545620120524d2006 uy 0engurcn|||||||||DB2 10 for z/OS database administration[electronic resource] certification study guide /Susan Lawson, Daniel Luksetich1st ed.Ketchum, Idaho MC Press20061 online resource (1009 p.)"Exam 612"--Cover.1-58347-369-6 1-306-03913-4 Includes bibliographical references and index.Cover; 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; CommandsDB2 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 GroupsDatabase 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 ResourcesPractice 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 RecoveryTracker 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 DefinitionsSQL Execution ValidationWritten 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 serviceElectronic data processing personnelCertificationDatabase managementElectronic data processing personnelCertification.Database management.005.75/85005.7585Lawson Susan1487931Luksetich Dan1487932MiAaPQMiAaPQMiAaPQBOOK9910790632403321DB2 10 for z3708057UNINA