Understanding DB2

by Raul F. Chong

Author	: Raul F. Chong
Publisher	: Pearson Education
Total Pages	: 1138
Release	: 2007-12-29
Genre	: Computers
ISBN	: 0132797410

GET BOOK

The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5 IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges. Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables. This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736. Coverage includes Choosing the right version of DB2 for your needs Installing and configuring DB2 Understanding the DB2 environment, instances, and databases Establishing client and server connectivity Working with database objects Utilizing breakthrough pureXMLTM technology, which provides for nativeXML support Mastering administration, maintenance, performance optimization, troubleshooting, and recovery Understanding improvements in the DB2 process, memory, and storage models Implementing effective database security Leveraging the power of SQL and XQuery

Understanding DB2 9 Security

by Rebecca Bond

Author	: Rebecca Bond
Publisher	: Pearson Education
Total Pages	: 447
Release	: 2006-12-13
Genre	: Computers
ISBN	: 0132704439

GET BOOK

Understanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM® DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security. This book’s material is organized to support you through every step of securing DB2 in Windows®, Linux®, or UNIX® environments. You’ll start by exploring the regulatory and business issues driving your security efforts, and then master the technological and managerial knowledge crucial to effective implementation. Next, the authors offer practical guidance on post-implementation auditing, and show how to systematically maintain security on an ongoing basis. Coverage includes Establishing effective security processes, teams, plans, and policies Implementing identification and authentication controls, your first lines of defense DB2 in Windows environments: managing the unique risks, leveraging the unique opportunities Using the new Label Based Access Control (LBAC) of DB2 9 to gain finer-grained control over data protection Encrypting DB2 connections, data “in flight,” and data on disk: step-by-step guidance Auditing and intrusion detection: crucial technical implementation details Using SSH to secure machine-to-machine communication in DB2 9 multi-partitioned environments Staying current with the latest DB2 security patches and fixes

DB2 Essentials

by Raul F. Chong

Author	: Raul F. Chong
Publisher	: IBM Press
Total Pages	: 783
Release	: 2013-10-26
Genre	: Computers
ISBN	: 0133461920

GET BOOK

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.

Advanced DBA Certification Guide and Reference for DB2 Universal Database V8 for Linux, UNIX, and Windows

by Dwaine Snow

Author	: Dwaine Snow
Publisher	: Prentice Hall Professional
Total Pages	: 806
Release	: 2003
Genre	: Computers
ISBN	: 9780130463883

GET BOOK

Straight from IBM, Advanced DBA Certification Guide and Reference for DB2 Universal Database v8for Linux, UNIX, and Windowsis the definitive guide to enterprise-class DB2 v8 administration - andthe onlyauthoritative self-study guide for IBM's new DB2 advanced DBA exam. Delivers proventechniques for enterprise-class security, user management, recovery, scalability, optimization,troubleshooting, remote administration, and more! CD-ROM: DB2 Universal Database v8 EnterpriseServer Edition trial version plus complete documentation.

DB2 Developer's Guide

by Craig S. Mullins

Author	: Craig S. Mullins
Publisher	: IBM Press
Total Pages	: 1657
Release	: 2012-05-01
Genre	: Computers
ISBN	: 0132836440

GET BOOK

DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for DB2 v9 and v10. Mullins fully covers new DB2 innovations including temporal database support; hashing; universal tablespaces; pureXML; performance, security and governance improvements; new data types, and much more. Using current versions of DB2 for z/OS, readers will learn how to: * Build better databases and applications for CICS, IMS, batch, CAF, and RRSAF * Write proficient, code-optimized DB2 SQL * Implement efficient dynamic and static SQL applications * Use binding and rebinding to optimize applications * Efficiently create, administer, and manage DB2 databases and applications * Design, build, and populate efficient DB2 database structures for online, batch, and data warehousing * Improve the performance of DB2 subsystems, databases, utilities, programs, and SQL stat DB2 Developer's Guide, Sixth Edition builds on the unique approach that has made previous editions so valuable. It combines: * Condensed, easy-to-read coverage of all essential topics: information otherwise scattered through dozens of documents * Detailed discussions of crucial details within each topic * Expert, field-tested implementation advice * Sensible examples

Beginning DB2

by Grant Allen

Author	: Grant Allen
Publisher	: Apress
Total Pages	: 520
Release	: 2008-11-20
Genre	: Computers
ISBN	: 1430205482

GET BOOK

IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find: A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.

DB2 SQL Tuning Tips for z/OS Developers

by Tony Andrews

Author	: Tony Andrews
Publisher	: IBM Press
Total Pages	: 391
Release	: 2012-10-15
Genre	: Computers
ISBN	: 0133038521

GET BOOK

The Definitive Solutions-Oriented Guide to IBM® DB2® for z/OS®: Now Fully Updated for Both v9 and v10! The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance. DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability. This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application. Coverage includes Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs Providing many programming and SQL coding examples Establishing standards and guidelines that lead to high-performance SQL Implementing time-efficient code walkthroughs to ensure that your standards are followed Focusing on the small number of SQL statements that consume the most resources Identifying simple solutions that deliver the most sizable benefits Optimizing performance by rewriting query predicates more efficiently Providing a better understanding of SQL optimization and Runstat statistics Recognizing opportunities to tweak your code more effectively than the Optimizer Optimizing SQL code with COBOL applications Efficiently checking for the existence of data, rows, or tables Using Runstats’ newest capabilities to consistently optimize paths to data

DB2 Essentials

by Raul F. Chong

Author	: Raul F. Chong
Publisher	: IBM Press
Total Pages	: 783
Release	: 2013
Genre	: Computers
ISBN	: 0133461904

GET BOOK

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. 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.

Understanding IBM SOA Foundation Suite

by Tinny Ng

Author	: Tinny Ng
Publisher	: Pearson Education
Total Pages	: 527
Release	: 2009-08-17
Genre	: Computers
ISBN	: 0137034288

GET BOOK

Understanding IBM SOA Foundation Suite Learning Visually with Examples Master the IBM SOA Foundation Through 26 Hands-On, Start-to-Finish Tutorials The IBM SOA Foundation Suite is an integrated, open-standards-based set of software, best practices, and patterns that help you systematically maximize the business value of SOA. Understanding IBM SOA Foundation Suite brings together 26 hands-on tutorials that will help you master IBM SOA Foundation and apply it successfully in your organization. Four of IBM’s SOA practitioners identify core IBM SOA Foundation components and usage scenarios, and walk you step-by-step through implementing them in real-world environments. This book’s self-contained tutorials are presented both in print and through video on the accompanying CD-ROM, showing you the results of every action immediately, whether you’re running the software or not. Using these tutorials, technical professionals can quickly move up the learning curve, discovering how each product works, and how they fit together. You’ll gain the big picture overview you need to make intelligent up-front decisions, and all the hands-on practice you need to prototype working solutions. Coverage includes Designing services with UML, sharing designs via HTML files, and transforming designs to and from Java with IBM Rational Software Architect Creating services with IBM Rational Application Developer, and deploying them with IBM WebSphere Application Server Implementing effective service governance with IBM WebSphere Service Registry and Repository Integrating existing services into new business processes with IBM WebSphere Integration Developer and IBM WebSphere Process Server Connecting services with IBM WebSphere Message Broker Developing, testing, deploying, and managing portlets with IBM WebSphere Portlet Factory and IBM WebSphere Portal Systematically securing services with IBM Tivoli Federated Identity Manager