IBM DB2 Books - Page 2

DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide

Roger E. Sanders

Amazon Price: $58.45 List Price: $64.95 Usually ships in 24 hours By: Mc Press Amazon Marketplace: 15 new & used starting at $56.95

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> Linux
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 2 Average rating: 5.0 of 5

Editorial Review:

In DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide, Roger E. Sanders—one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams—covers everything a reader needs to know to pass the DB2 9 UDB DBA Certification Test (731).

This comprehensive study guide steps you through all of the topics that are covered on the test, including server management, data placement, database access, analyzing DB2 activity, DB2 utilities, high availability, security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.

Taking and passing the DB2 9 UDB DBA Certification Test (731) provides validation that you have mastered the next level of DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification. The book includes a complete practice test of 150 questions that closely models the actual exam along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.

With the DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide 8, you will:

• Gain the knowledge necessary to pass the DB2 9 UDB DBA Certification

• Test (731) Learn how to effectively implement and administer a DB2 database with XML data

• Create, maintain, and administer database objects like tables, views, and indexes

• Receive an explanation of every topic included on the test…by someone involved in the creation of the actual exam

• Find 150 practice questions based on the actual exam’s format and approach, along with comprehensive answers to the test questions to help you gain understanding

DB2 for the COBOL Programmer, Part 2, 2nd Ed.

Curtis Garvin, Anne Prince, Steve Eckols

Amazon Price: $40.46 List Price: $45.00 Usually ships in 24 hours By: Mike Murach & Associates Amazon Marketplace: 27 new & used starting at $19.39

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Customer Reviews:
Total reviews: 5 Average rating: 4.5 of 5

Editorial Review:

This new edition of DB2,Part 2, covers the version 4.1 and 5 enhancements to DB2 so programmers can take advantage of all the new and improved features that help them the most. It presents the advanced skills needed to become a top senior programmer or programmer/analyst.

Specifics covered in the 2nd edition:

How to use stored procedures that move SQL code off of the client and onto the database server to reduce network overhead

How to use dynamic SQL so your programs can generate and execute SQL statements as they run

How data sharing works on the parallel sysplex and other System/390 configurations

How to work with DB2 data, where the data is managed by a DB2 subsystem on a system thats connected over a network

How to process DB2 data in CICS programs

Advanced locking concepts that show how locking and data sharing affect each other and what impact that has on program efficiency

The concepts and practices of DB2 database administration that let the programmer design databases, manage database objectives, and set up a quality assurance environment

IBM DB2 9 New Features

Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 38 new & used starting at $11.97

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Editorial Review:

Design and deploy integrated enterprise-class business solutions

Enhance productivity, profitability, and efficiency using IBM DB2 9 and the detailed information in this comprehensive resource. Written by experienced IBM data server professionals, IBM DB2 9 New Features covers the technical details of the major new aspects of DB2 9 alongside real-world business uses, syntax examples, and insider tips. Learn how to manipulate and manage XML data using pureXML, automate maintenance tasks, and seamlessly integrate Java, PHP, and Perl scripts. Plus, you'll get vital coverage of the brand-new DB2 Developer Workbench, enhanced .NET developer support, Ruby on Rails, and database security.

• Learn about all the auto-configuration features that make getting DB2 up and running faster than ever before
• Define, share, and validate data using XML and the unique pureXML DB2 Hybrid Storage Engine
• Improve runtime performance and optimize storage with the new DB2 Compression Technology
• Automatically handle DB2 memory allocation using the Self Tuning Memory Manager
• Use Automatic Storage, Autonomic Computing, and a host of other autonomic features that make managing DB2 a snap
• Create dynamic data server blueprints with Rational Data Architect version 6.1
• Incorporate Java applications using the IBM WebSphere Application Server and DB2 data server
• Develop open-source scripts using PHP, Perl, Toad, and Ruby on Rails
• Utilize the DB2 Developer Workbench or exploit the enhanced .NET developer support
• Deploy the latest DB2 security and high availability features

DB2(R) for z/OS(R) Version 8 DBA Certification Guide (IBM Press Series--Information Management)

Susan Lawson

Amazon Price: $51.99 List Price: $64.99 Usually ships in 24 hours By: IBM Press Amazon Marketplace: 15 new & used starting at $35.55

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> IBM
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 11 Average rating: 3.5 of 5

Editorial Review:

*A practical guide to DB2 z/OS database administration that is 100 percent focused on running DB2 in z/OS environments*The only comprehensive preparation guide for the IBM Certified Database Administrator for DB2 Universal Database V8 z/OS certification*Covers database planning, design, implementation, operation, recovery, security, performance, installation, migration, and more*Sample test questions help you prepare for both IBM DB2 DBA Tests 700 and 702 IBM DB2 Universal Database Version 8 for z/OS offers enterprises unprecedented opportunities to integrate information, deliver it on demand, and manage it simply and cost-effectively. Now, one of the world's leading DB2 consultants presents the definitive guide to administering DB2 UDB V8 databases in z/OS environments. DB2 for z/OS Version 8 DBA Certification Guide also serves as a key tool for anyone preparing for IBM Certified Database Administrator for DB2 Universal Database V8 for z/OS certification.I BM Gold Consultant Susan Lawson presents hundreds of practical techniques, expert guidelines, and useful tips for every facet of DB2 UDB database administration, including database implementation, operation, recovery, security, auditing, performance, installation, migration, SQL, and more.Coverage includes *Understanding the DB2 product family, architecture, attachments, and the DB2 z/OS environment*Securing enterprise-class DB2 installations and applications*Using SQL to create and manage database objects, and manipulate and retrieve information*Mastering key DBA tasks, including loading, reorganizing, quiescing, repairing, and recovering data; recovering and rebuilding indexes; and gathering statistics*Implementing data sharing in Parallel Sysplex environments*Learning the fundamentals of DB2 application development from the DBA's perspective*Leveraging advanced DB2 functions, including stored procedures and other object-relational extensions*Optimizing DB2 applications and the DB2 engine for maximum performance Whether you are administering DB2 UDB V8 in z/OS environments, planning to do so, or preparing for DB2 UDB V8 DBA certification, DB2 for z/OS Version 8 DBA Certification Guide will be your single most valuable resource.

Understanding DB2 9 Security

Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan

Amazon Price: $38.99 List Price: $49.99 Usually ships in 24 hours By: IBM Press Amazon Marketplace: 36 new & used starting at $2.75

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Industries & Professions -> E-commerce -> General
Subjects -> Business & Investing -> Industries & Professions -> E-commerce -> General AAS
Subjects -> Computers & Internet -> Certification Central -> Exams -> Security+

Customer Reviews:
Total reviews: 4 Average rating: 4.0 of 5

Editorial Review:

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 9 for Developers

Philip K. Gunning

Amazon Price: $58.45 List Price: $64.95 Usually ships in 24 hours By: Mc Press Amazon Marketplace: 31 new & used starting at $58.16

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Customer Reviews:
Total reviews: 8 Average rating: 5.0 of 5

Editorial Review:

Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.

DB2(R) Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (5th Edition) (Ibm Db2 Certification Guide Series)

George Baklarz, Bill Wong

Amazon Price: $58.37 List Price: $64.99 Usually ships in 24 hours By: IBM Press Amazon Marketplace: 29 new & used starting at $13.89

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> IBM
Subjects -> Computers & Internet -> Certification Central -> Linux

Customer Reviews:
Total reviews: 15 Average rating: 3.5 of 5

This is the one that the DBA wants 5 out of 5 stars.
1 of 1 people found this review helpful.

I boought and read a couple of other IBM press books looking for this one. If you are a DBA or a wanna be BDA then this is the book that you want to read. I found the writting smooth and usefull. I did read a paragraph that was lifted almost directly from the IBM db2 administration guide. I have not made use of the cd yet nor have I taken the certification test so I can not comment on the works usefullness in those two areas.

I recomend this book to the DBA or the developer. I would not recommend this book to the nontechnical reader.

Editorial Review:

Straight from IBM, this is the only book to offer complete, start-to-finish coverage of DB2 Universal Database V8 administration and development for UNIX, Linux, Windows, and OS/2 exam. This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V8.1, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. DB2 Version 8 represents one of the most feature-packed significant releases in DB2's history! With Version 8 key topics such as Performance Enhancements, Manageability Enhancements, etc are addressed.

The Official Introduction to DB2(R) for z/OS(R): Covers DB2(R) Universal Database for z/OS(R) Version 8 (2nd Edition) (IBM Press Series--Information Management)

Susan Graziano Sloan

List Price: $54.99 By: IBM Press Amazon Marketplace: 8 new & used starting at $22.19

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Customer Reviews:
Total reviews: 2 Average rating: 4.5 of 5

Editorial Review:

The Official Introduction to DB2 UDB for z/OS provides a comprehensive overview of Version 8 of the DB2 UDB for z/OS product. The book serves a dual purpose: it gives new and prospective users a solid introduction to key product features and it covers material contained in the DB2 Family Fundamental exam, the first exam in the DB2 certification series. The book explains basic relational database concepts, the basics of the structured query language (SQL), and gives a solid overview of the various user tasks that are associated with this product. It includes introductory information about designing databases, creating relational objects, managing DB2 on a day-to-day basis, and writing application programs that use DB2 data. It also introduces new users to some of the more complex capabilities of DB2, such as, DB2 in the Web environment, distributed data, and data sharing. Introductory book for the DB2 mainframe audience, parallels Baklarz audience (ISBN 0130463612). Well-written (The Society of Technical Communication recognized the first edition of this book with a Merit award in the Northern California Technical Communication Competition.) Most current coverage of Version 8 of DB2 UDB for z/OS, the single largest release of this product since its inception in 1983-- Includes 8.2

Sams Teach Yourself DB2 Universal Database in 21 Days (2nd Edition)

Susan Visser, Bill Wong

Amazon Price: $35.01 List Price: $44.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 32 new & used starting at $2.85

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Customer Reviews:
Total reviews: 5 Average rating: 3.0 of 5

Editorial Review:

Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.