This IBM Redbooks publication is designed as a study guide for professionals wanting to prepare for the certification exam to achieve IBM Certified Systems Expert - eServer p5 and pSeries Enterprise Technical Support AIX 5L V5.3. This technical support certification validates a broad scope of configuration, installation, and planning skills. In addition, it covers administrative and diagnostic activities needed to support logical partitions and virtual resources. This publication helps IBM eServer p5 and pSeries professionals seeking a comprehensive and task-oriented guide for developing the knowledge and skills required for the certification. It is designed to provide a combination of theory and practical experience needed for a general understanding of the subject matter. This publication does not replace the practical experience you should have, but is an effective tool that, when combined with education activities and experience, should prove to be a very useful preparation guide for the exam. Due to the close association with the certification content, this publication might reflect older software and firmware levels of the IBM eServer p5 systems and available features. If you are planning to take the eServer p5 and pSeries Enterprise Technical Support AIX 5L V5.3 certification exam, this book is for you.

Mastering material for dealing with DBA certification exams Key Features Prepare yourself for the IBM C2090-600 certification exam Cover over 50 Db2 procedures including database design, performance, and security Work through over 150 Q&As to gain confidence on each topic Book Description IBM Db2 is a relational database management system (RDBMS) that helps you store, analyze, and retrieve data efficiently. This comprehensive 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 C2090-600. Building on years of extensive experience, the authors take you through all areas covered by the test. The book delves deep into each certification topic: Db2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, and security. IBM Db2 11.1 Certification Guide provides you with more than 150 practice questions and answers, simulating real certification examination questions. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book will not just prepare you for the C2090-600 exam but also help you troubleshoot day-to-day database administration challenges. What you will learn Configure and manage Db2 servers, instances, and databases Implement Db2 BLU Acceleration and a DB2 pureScale environment Create, manage, and alter Db2 database objects Use the partitioning capabilities available within Db2 Enforce constraint checking with the SET INTEGRITY command Utilize the Db2 problem determination (db2pd) and dsmtop tools Configure and manage HADR Understand how to encrypt data in transit and at rest Who this book is for The IBM Db2 11.1 Certification Guide is an excellent choice for database administrators, architects, and application developers who are keen to obtain certification in Db2. Basic understanding of Db2 is expected in order to get the most out of this guide.

This IBM Redbooks publication is designed as a study guide for professionals wishing to prepare for the certification exam (Test 222) to achieve: IBM Certified Specialist eServer p5 and pSeries Administration and Support for AIX 5L Version 5.3. The certification validates a broad scope of AIX 5L administration, support, problem determination skills, and the ability to perform general AIX 5L software system maintenance. This book helps AIX 5L professionals seeking a comprehensive and task-oriented guide for developing the knowledge and skills required for the certification. It is designed to provide a combination of theory and practical experience needed for a general understanding of the subject matter. This book does not replace practical experience you should have, but is an effective tool that, when combined with education activities and experience, should prove to be a very useful preparation guide for the exam. Due to the practical nature of the certification content, this publication can also be used as a desk-side reference. So, whether you are planning to take the eServer p5 and pSeries Administration and Support for AIX 5L Version 5.3 certification exam, or if you just want to validate your AIX 5L skills, this book is for you.

Written primarily for database administrators who work on z/OS and who are taking the IBM DB2 11 for z/OS Database Administration certification exam (Exam 312), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator of z/OS mainframes. This study guide is designed to provide those seeking certification with an intense overview of DB2 11 for z/OS and all topics covered on the exam. Sample questions are provided at the end of each chapter, along with answers and explanations.

Written with system administrators in mind, this reference offers information about both DB2 and z/OS operating systems as well as guidance for preparing for the IBM Certification Test 737. Helpful and thorough, this technical guide summarizes the new features of DB2 9 environments and provides essential system administration information, such as installation and maintenance procedures. With chapters on troubleshooting, performance and tuning, and securing and auditing, as well as practice questions, this reference is a one-stop shop for DB2 system administrators.

Beginning with an explanation of the certification process and working toward fundamental exam objectives, this guide gives test-takers all they need to know to pass the DB2 10.1 Fundamentals certification exam (Exam 610). Each chapter is followed by an extensive set of practice questions that mirror the questions found on the exam and detailed answers that explain why the chosen answer is correct and why the others are wrong. Additional topics covered include database objects, working with data using SQL and XQuery, working with DB2 tables, views and indexes, and data concurrency. Complete with a practice exam and answer key containing full explanations of correct answers, this is the ultimate resource for those who plan to earn their DB2 10.1 Fundamentals certification.

A comprehensive introduction to IBM i—the operating system that runs on IBM's midrange computer systems (System i, iSeries, AS/400)—and its facilities, this in-depth resource uses step-by-step exercises, review questions, and chapter labs to teach new programmers the latest system concepts and tools. Reflecting system changes that have occurred since 2000, topics include Rational Developer for Power (RDP), RDP Screen Designer and Report Designer, IBM i Access for Windows, IBM i Access for Web, IBM DB2 Web Query for i, and Remote System Explorer (RSE).