DB2 10 1 Fundamentals

Author: Sanders E Roger
Publisher: Mc PressLlc
ISBN: 9781583473498
Format: PDF, ePub, Docs
Download Now
Beginning with an explanation of the certification process and working through fundamental exam objectives, this guide gives test-takers all they need to know to pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610). All the subjects covered on the exam are included: planning, security, data concurrency, working with databases and database objects, working with data using SQL and XQuery, working with DB2 tables, views, and indexes—and more. The book concludes with an extensive set of 150 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. Written by a DB2 authority who has helped IBM develop 21 DB2 certification exams, this is the ultimate resource for those who plan to earn their IBM Certified Database Associate certification.

Oracle to DB2 Conversion Guide Compatibility Made Easy

Author: Yvonne Chan
Publisher: IBM Redbooks
ISBN: 0738438758
Format: PDF
Download Now
This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.

DB2 Essentials

Author: Raul F. Chong
Publisher: IBM Press
ISBN: 0133461920
Format: PDF, ePub, Docs
Download Now
The Easy, Visual Introduction to IBM DB2 Version 10.5 for Linux, UNIX, and Windows Foreword by Judy Huber, Vice President, Distributed Data Servers and Data Warehousing; Director, IBM Canada Laboratory This book covers everything you need to get productive with the latest version of IBM DB2 and apply it to today’s business challenges. It discusses key features introduced in DB2 Versions 10.5, 10.1, and 9.7, including improvements in manageability, integration, security, Big Data support, BLU Acceleration, and cloud computing. DB2 Essentials illuminates key concepts with examples drawn from the authors’ extensive experience with DB2 in enterprise environments. Raul F. Chong and Clara Liu explain how DB2 has evolved, what’s new, and how to choose the right products, editions, and tools. Next, they walk through installation, configuration, security, data access, remote connectivity, and day-to-day administration. Each chapter starts with an illustrative overview to introduce its key concepts using a big picture approach. Clearly explained figures are used extensively, and techniques are presented with intuitive screenshots, diagrams, charts, and tables. Case studies illustrate how “theory” is applied in real-life environments, and hundreds of review questions help you prepare for IBM’s newest DB2 certification exams. Coverage includes • Understanding the role of DB2 in Big Data • Preparing for and executing a smooth installation or upgrade • Understanding the DB2 environment, instances, and databases • Configuring client and server connectivity • Working with database objects • Getting started with BLU Acceleration • Implementing security: authentication and authorization • Understanding concurrency and locking • Maintaining, backing up, and recovering data • Using basic SQL in DB2 environments • Diagnosing and solving DB2 problems This book is for anyone who plans to work with DB2, including DBAs, system administrators, developers, and consultants. It will be a great resource whether you’re upgrading from an older version of DB2, migrating from a competitive database, or learning your first database platform.

DB2 Universal Database V8 Application Development Certification Guide

Author: David Martineau
Publisher: Prentice Hall Professional
ISBN: 9780130463913
Format: PDF, ePub, Docs
Download Now
In this text, a team of IBM's leading DB2 development consultants present a complete, start-to-finish guide to DB2 Universal Database V8/8.1 development and a preparation guide for IBM's DB2 Application Developer certification exam.