DB2: Universal Database Certification Guide / Edition 2

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (10) from $1.99   
  • Used (10) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2006

Feedback rating:

(58641)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Good
Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase benefits world literacy!

Ships from: Mishawaka, IN

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(6507)

Condition: Good
Only lightly used. Book has minimal wear to cover and binding. A few pages may have small creases and minimal underlining.Book selection as BIG as Texas.

Ships from: Dallas, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2007

Feedback rating:

(9463)

Condition: Good
Light shelf wear and minimal interior marks.Millions of satisfied customers and climbing. Thriftbooks is the name you can trust, guaranteed. Spend Less. Read More.

Ships from: Auburn, WA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(1406)

Condition: Good
2nd edition. Noticeably read/ used. Clean & intact. Average wear to cover, pages and/or spine. We ship from Dallas within 1 business day and we LOVE our customers! No hassle ... satisfaction guarantee! Thank you for your business. Read more Show Less

Ships from: Garland, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(7265)

Condition: Good
Light shelving wear with minimal damage to cover and bindings. Pages show minor use.Help save a tree. Buy all your used books from Green Earth Books. Read. Recycle and Reuse.

Ships from: Portland, OR

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$2.49
Seller since 2010

Feedback rating:

(1796)

Condition: Very Good
0130796611 May have highlighting or writing and wear to cover. May not include supplemental items like CDs or access codes. A portion of your purchase of this book will be ... donated to non-profit organizations. We are a tested and proven company with over 900,000 satisfied customers since 1997. Choose expedited shipping (if available) for much faster delivery. Delivery confirmation on all US orders. Read more Show Less

Ships from: Nashua, NH

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$15.99
Seller since 2014

Feedback rating:

(27)

Condition: Good
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.

Ships from: Fort Mill, SC

Usually ships in 1-2 business days

  • Standard, 48 States
$29.51
Seller since 2014

Feedback rating:

(227)

Condition: Good
Possible retired library copy, some have markings or writing.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$31.99
Seller since 2014

Feedback rating:

(227)

Condition: Very Good
Very good.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$32.95
Seller since 2014

Feedback rating:

(227)

Condition: Like New
As new.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

The only official handbook for IBM's DB2 Certification program

Completely updated for DB2 Universal Database

Covers both database administration and application development

IBM's Professional Certification program provides a mark of excellence recognized around the world. Prepare for DB2 Certification with the manual created by IBM's own team of experts.

This self-paced guide familiarizes you in-depth with administering databases and developing applications for DB2 Universal Database. Incorporating all the latest enhancements present in Version 5, this handbook shows you how to use all of DB2's powerful tools, including the new Control Center.

  • Learn from IBM's own team of expert trainers
  • Master all aspects of DB2, from the basic architecture to application programming
  • Discover how DB2 performs in a variety of environments, from small LANs to the entire Internet
  • Fine-tune your SQL programming skills
  • Get real hands-on experience with the interactive exercises included on the CD-ROM

While this second edition of DB2 Universal Database Certification Guide is intended primarily for users who are preparing for certification, it is also an invaluable resource for anyone who wants to gain a deeper understanding of DB2's wide-ranging capabilities.

The accompanying CD-ROM offers hands-on exercises for every chapter in the book. A trial copy of DB2 is included, along with product README files and libraries. The software runs under Windows™ 95, Windows NT® and OS/2®.

Read More Show Less

Editorial Reviews

Booknews
This guide to IBM's DB2 Universal Database Version 5 covers such topics as the installation and configuration of DB2 servers and clients, the Structured Query Language (SQL), database concurrency, database administration and monitoring, alternate programming interfaces, and the development of a static imbedded SQL application. The authors include sample questions for those who wish to become IBM Certified Professionals. A CD-ROM provides a complete set of DB2 products for Windows NT, Windows 95, and OS/2 for 60 days. Annotation c. by Book News, Inc., Portland, Or.
Read More Show Less

Product Details

  • ISBN-13: 9780130796615
  • Publisher: Prentice Hall Professional Technical Reference
  • Publication date: 12/9/1997
  • Series: IBM DB2 Series
  • Edition number: 2
  • Pages: 770
  • Product dimensions: 7.03 (w) x 9.24 (h) x 1.20 (d)

Read an Excerpt

PREFACE: Foreword

Since the publication of the first DB2 Certification Guide in 1996, thousands of readers have learned about DB2 Common Server and earned certification by taking the DB2 Database Administrators and DB2 Database Developers exams. With the introduction of DB2 Universal Database, the newest release of DB2 from IBM, we're pleased to provide a new, updated version of the DB2 Certification Guide.
DB2 Universal Database (UDB) brings together the data management strengths and advanced SQL of DB2 Common Server Version 2 with the scalable parallelism of DB2 Parallel Edition Version 1. To this combination we've added new OLAP functions, enhanced performance, and a rich, integrated set of easy-to-use graphical tools. DB2 UDB is the industry's first multi-media, web-enabled database, that scales from PCs to UNIX platforms, from single-processor machines to SMPs and MPPs, and supports applications from transaction processing to business intelligence.
Businesses today are reaching for extraordinary results in everything they do, in market effectiveness, customer service, product development, quality and logistics. Business Intelligence solutions including data marts, data warehouses and data mining supported by online transaction systems, deliver knowledge to business professionals, and allow better decisions to be made, faster. The role of the trained database professional remains vital to business success, and the shortage of available skills provides opportunities for those who keep current on the latest technological advancements.
This Certification Guide provides the reader with an understanding of the function and tools supported by UDB, and howto use them to do multi-dimensional analysis, to support non-traditional content, or to write an application intended to deliver information over the internet. It gives tips for tuning applications to run their best when using multiple processors, or large memories, or when supporting thousands of users. The reader will learn how to use the new Control Center to define the structure of a database, to view the access plan for SQL using visual explain, and to monitor the execution of an application. The Certification Guide was designed to help you keep current, and to prepare you to meet the needs of your customers and users, within business of all sizes. You'll find the self-study design lets you proceed at your own pace, while learning the material necessary to complete the formal certification exams for a DB2 Database Administrator or DB2 Database Developer. As the importance of data to businesses grows, and as increasingly the responsibility for keeping technical skills current rests with the technical professional, I think you'll find this guide provides a cost-effective and efficient way to meet your business needs. The latest DB2 technology puts customers on the road to getting even more value form their data. I think you'll enjoy being part of the journey.

Hershel Harris
Manager, Database Technology
IBM Software Solutions Division

Preface

This book is a complete guide to the IBM's relational database servers, known as DB2 Universal Database Version 5. DB2 Universal Database (UDB) Version 5 is available on many operating systems, and the book has been written with this in mind. Any significant differences in the implementation of DB2 on various operating systems are highlighted. If you are planning to become certified, or you would simply like to understand the powerful new DB2 database servers from IBM, then read on. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of each chapter. There are exercises provided at the end of many of the chapters to provide hands-on use of DB2.
The book is divided into 3 main sections:
  • DB2 Fundamentals (Chapters 1-5)
    • Installing and configuring DB2 servers and clients are covered in Chapters 1, 2, and 3. The Structured Query Language (SQL) is discussed in Chapter 4 and database concurrency is discussed in Chapter 5.
  • DB2 Database Administration (Chapters 6-8)
    • Creating a DB2 database and its related table spaces is covered in Chapter 6. The common administration tasks are discussed in Chapter 7, database monitoring and performance considerations are discussed in Chapter 8.
  • DB2 Application Development (Chapters 9-10)
    • Developing a static embedded SQL application is covered in Chapter 9. Alternate DB2 programming interfaces, including Call Level Interface (CLI) and dynamic embedded SQL, are discussed in Chapters 9 and 10.
      Exercises are provided at the end of most of the chapters. The exercises make references to files that can be found on the companion CD-ROM. The exercises are provided to enforce that the concepts discussed in the chapter are understood. Any Intel DB2 operating environment can be used to perform the exercises.
      This book can be used as a self-study guide to prepare for the DB2 certification exams or as a complete guide to DB2 Universal Database.
      The path to certification involves successfully completing two exams:

      The test objectives are provided in Appendixes A, B, and C. These should be used as a guide to ensure that you are fully prepared to take the DB2 exams.
      The DB2 Fundamentals Exam (503) covers these skills:
  • Understanding DB2 products and components
  • Creating database objects
  • Understanding various DB2 data types
  • Using SQL to manipulate database objects
  • Describing DB2 concurrency

    For more details on the contents of this exam, see "DB2 Fundamentals (503) - Test Objectives" on page 714.
    The DB2 Database Administration Exam (504) covers these skills:
  • Managing DB2 instances
  • Creating and maintaining database objects
  • Managing table spaces
  • Using utilities: IMPORT, LOAD, REORG, RUNSTATS
  • Managing recovery procedures (BACKUP/RESTORE)
  • Analyzing resource problems
    For more details on the contents of this exam, see "DB2 UDB V5 Database Administration (504) - Test Objectives" on page 718.
    The DB2 Application Development exam (505) covers these skills:
  • Developing static embedded SQL programs
  • Developing dynamic embedded SQL programs
  • Using host variables, parameter markers, and cursors
  • Understanding dynamic SQL (Call Level Interface)
    For more details on the contents of this exam, see "DB2 UDB V5 Application Development (505) - Test Objectives" on page 722.
    Conventions
    Many examples of SQL statements, DB2 commands, and operating system commands are included throughout the book. SQL statements are usually displayed within a shaded box and any of the mandatory sections of the statements are shown in uppercase. An example of an SQL statement is shown:
    SQL is not a case-sensitive language, so the above query would provide the same result regardless of the case of the SQL keywords, or the database object (table names or column names). Of course the data stored in the database is stored exactly as it was entered (including case). Therefore, the above query would only find the candidates with the last name of `JANACEK' or `SNOW'. If the data were stored as `Janacek', it would not be part of the result table.
    If SQL keywords are referred to in the text portion of the book, they will be shown as a bold mono-spaced font. For example, the SELECT statement is used to retrieve data from a DB2 database.
    DB2 commands will be shown using the same method as SQL keywords. For example, the CREATE DATABASE command allows you to define the initial location of database objects. DB2 commands are issued from the Command Line Processor (CLP) utility. This utility will accept the commands in upper and lower case. The CLP program itself is an executable called db2. In some operating systems, such as AIX, the program names are case sensitive. Therefore, be careful to enter the program name using the proper case. There are a few operating system specific commands in this book. If the commands must be in lowercase they will be shown as such. For example, the UNIX command to create a user is the mkuser command.
    Occasionally, notes are provided to highlight a particular point.
    - A note may be used to explain a minor operating system difference or it may be used to summarize a concept.
    There are a few syntax diagrams shown in the book. We recommend that the Command Line Processor be used to verify the syntax of DB2 commands. Some of the commands are shown with the complete syntax as shown in the Command Line Processor. The following is an example of complete syntax of the DB2 BACKUP DATABASE command.
    A syntax diagram shows how the command should be entered using the Command Line Processor. The diagram should be followed from left to right, and from top to bottom. Parameters are regarded as keywords or variables. A parameter can be a combination of a keyword and a variable.
    · Keywords represent constants in the command. They are shown in uppercase in the syntax diagram. For example, BACKUP DATABASE is a keyword. A keyword may be entered in upper-, lower-, or mixed case.
    · Variables are values that are user supplied. They are indicated in the command syntax using lowercase. At the command prompt, they may be entered in either upper-, lower-, or mixed case, unless case restrictions are explicitly stated. Some of the user-supplied variables are required, such as database-alias in the BACKUP DATABASE command.
    The vertical bar "" means that the keyword following is required. Optional parameters are indicated in the syntax with square brackets "" . An optional parameter may have a possible list of user-supplied input values. This is indicated with the combination of "{" and three periods "...". For example, a user may back up multiple table spaces using a single BACKUP DATABASE command. The DB2 SQL Reference should be used to verify the syntax of SQL statements. To emphasize a term or concept, the term is shown in bold type or emphasized with italics.
    How this Book was Created
    This book was a joint effort between the Austin ITSO (International Technical Support Organization) and the IBM Toronto Lab. The ITSO is a group within IBM whose mission is to provide skill transfer on new products and technology worldwide. We provide direct feedback to the IBM software labs as we gather input from various groups of DB2 users, including IBM support personnel, customers and business partners. The ITSO provides a working environment for interested individuals to work with new IBM software products. These individuals may include IBM employees and customers. The team develops a workshop or book, known as a redbook.
    - ITSO redbooks - ...
Read More Show Less

Table of Contents

1. Product Overview.
DB2 Universal Database - The Scalable Database. DB2 Products. DB2 Universal Database (UDB). DB2 UDB Personal Edition. DB2 Workgroup Edition. DB2 Enterprise Edition. DB2 Universal Database Enterprise-Extended Edition. DB2 Connect. DB2 Connect Personal Edition. DB2 Connect Enterprise Edition. DB2 Developer's Edition. Licensing Scenarios. DB2 Client/Server Environment. Supported Communication Protocols. DB2 Resource Usage. Features and Functions. DB2 Universal Database Administrator's Tools. The Control Center. The SmartGuides. The Command Line Processor (CLP). Summary. Questions. Answers.

2. Getting Started and Connected.
Product Installation. Intel Installation. UNIX Installation. DB2 Client Installation. The DB2 Environment. DB2 Profile Registry. Environment Variables. Using the Command Line Processor. DAS and DB2 Instances. DB2 Administration Server (DAS) Instance. DB2 Instances. Creating the Sample Database. Summary. Questions. Answers. Exercises.

3. Controlling Data Access.
Security. Overview of Security. Authentication. Authorization Levels. Security Considerations. DB2 Privileges (Data Control Language). Database Object Privileges. Establishing a DB2 Client/Server Connection. Configuring a DB2 UDB Server. DB2 Directories. DB2 Discovery. Generating a Server Access Profile. Configuring DB2 Clients. Using the Client Configuration Assistant. Configuring a Connection to a DB2 Database. Instance Administration. Summary. Questions. Answers. Exercises.

4. Using SQL.
Understanding Database Objects. Data Types. DB2-Supplied Data Types. Large Objects (LOBs). String Data Types. Numeric Data Types. Datetime Data Types. User-Defined Data Types. Code Page Considerations. Selecting the Correct Data Type. DB2 Certification Database Design and Implementation. Tables. Using SQL Data Definition Language (DDL). Creating a DB2 Database. Views. Indexes. Data Manipulation Language (DML). Data Retrieval (SELECT). Selecting Columns from Multiple Tables. DB2 Functions. Data Modification (INSERT/UPDATE/DELETE). Removing Data. View Classification. Business Rules. User-Defined Defaults. Check Constraints. Triggers. Advanced SQL. Recursive SQL. Outer Join. OLAP Features. Advanced Case Expressions. Summary. Questions. Answers. Exercises.

5. Database Concurrency.
Concurrency. Concurrency Considerations. Lost Update Problem. Uncommitted Read. Non-Repeatable Read. Phantom Read Problem. Isolation Level. Uncommitted Read. Cursor Stability. Read Stability. Repeatable Read. Choosing an Isolation Level. Locking. Lock Attributes. Lock Conversion. Lock Escalation. Lock Wait Behavior. Summary. Questions. Answers. Exercises.

6. Data Placement.
Containers. Table Spaces. Extents. System Managed Storage (SMS) Table Spaces. Database Managed Storage (DMS) Table Spaces. Planning a Table Space Environment. Creating Table Spaces. Performance Considerations. Buffer Pool. Extent Size. NUM_IOSERVERS. I/O Prefetch. Page Cleaners. System Catalogs in DB2. Managing Table Spaces. States of Table Spaces. Summary. Questions. Answers. Exercises.

7. Data Management.
Populating Tables. The LOAD Utility. Using The LOAD Utility. Syntax of the LOAD Command. The IMPORT/EXPORT Utility. The EXPORT Utility. The IMPORT Utility. Data Maintenance. Analyzing Data's Physical Organization: REORGCHK. Table Reorganization: REORG. RUNSTATS. The REBIND Utility. Data Maintenance Process. Modelling a Production Environment. User Maintenance. Fenced and Not Fenced Procedures and Functions. Database Recovery. Use of Log Files. Types of Logging. Backup and Restore. Restore Database SmartGuide. Summary of Backup/Restore Consideration. The QUIESCE Command. The Recovery History File. Administration Tools for Data Maintenance. The Script Center. The Journal. Data Replication. Summary. Answers. Exercises.

8. Database Monitoring and Tuning.
Monitoring Methods. Obtaining Database Access Information. Explain Facilities. Query Compilation. Gathering Explain Data. Examining EXPLAIN Data. Database Monitoring. Event Monitoring. Visual Performance Monitors. Performance Monitor. DB2 Governor. Performance Issues. Configuring Database Resources. DB2 Sorting Methods. DB2 Server Resources. Query Parallelism. Performance Tuning Scenario. Diagnostics and Problem Determination. Error Messages and SQL Codes. Tracing Problems in DB2 Universal Database. Database Analysis and Repair Tool. Summary. Questions. Answers. Exercises.

9. DB2 Application Programming.
DB2 Application Development Environment. Client/Server Platform. Choosing a DB2 Programming Method. Static Embedded SQL. Dynamic Embedded SQL. Call Level Interface (CLI). DB2 Application Programming Interfaces (APIs). Accessing Data from an Application. Using Schemas. Using an Alias. Creating Packages. Binding Applications. Binding Utilities. Parts of a DB2 Embedded Static SQL Application. Host Variables. Indicator Variables. Using Cursors. Handling Application Termination. Interrupt Handling. Large Objects. Direct LOB Reference. Reference by LOB Locator. LOB File Reference Variables. Unique Keys and Referential Integrity. Online Analytical Processing. STAR Schemas. OLAP Indexes. Dynamic Bitmap Index ANDing. STAR Joins. OLAP SQL. Summary. Questions. Answers. Exercises.

10. DB2 Advanced Application Programming.
Writing Dynamic Programs. First Look at Dynamic SQL. Dynamic SQL Phases. Types of Dynamic SQL Statements. Dynamic SQL - Callable SQL Interfaces. ODBC vs. CLI. Embedded Dynamic vs. Call Level Interface. Setting Up a CLI Development Environment. Stored Procedures. User Defined Functions. Support For Java Programming. Compound SQL. Summary. Questions. Answers. Exercises.

Appendix A - Test Objectives.
DB2 UDB V5 Fundamentals (503).

Appendix B - Test Objectives.
DB2 UDB V5 Database Administration (504).

Appendix C - Test Objectives.
DB2 UDB V5 Application Development (505).

Appendix D - DB2 Tools and Utilities.
Appendix E - DB2 Example Source Code.
Index.
CD-ROM Installation.
Read More Show Less

Preface

PREFACE: Foreword

Since the publication of the first DB2 Certification Guide in 1996, thousands of readers have learned about DB2 Common Server and earned certification by taking the DB2 Database Administrators and DB2 Database Developers exams. With the introduction of DB2 Universal Database, the newest release of DB2 from IBM, we're pleased to provide a new, updated version of the DB2 Certification Guide.
DB2 Universal Database (UDB) brings together the data management strengths and advanced SQL of DB2 Common Server Version 2 with the scalable parallelism of DB2 Parallel Edition Version 1. To this combination we've added new OLAP functions, enhanced performance, and a rich, integrated set of easy-to-use graphical tools. DB2 UDB is the industry's first multi-media, web-enabled database, that scales from PCs to UNIX platforms, from single-processor machines to SMPs and MPPs, and supports applications from transaction processing to business intelligence.
Businesses today are reaching for extraordinary results in everything they do, in market effectiveness, customer service, product development, quality and logistics. Business Intelligence solutions including data marts, data warehouses and data mining supported by online transaction systems, deliver knowledge to business professionals, and allow better decisions to be made, faster. The role of the trained database professional remains vital to business success, and the shortage of available skills provides opportunities for those who keep current on the latest technological advancements.
This Certification Guide provides the reader with an understanding of the function and tools supported by UDB, andhowto use them to do multi-dimensional analysis, to support non-traditional content, or to write an application intended to deliver information over the internet. It gives tips for tuning applications to run their best when using multiple processors, or large memories, or when supporting thousands of users. The reader will learn how to use the new Control Center to define the structure of a database, to view the access plan for SQL using visual explain, and to monitor the execution of an application. The Certification Guide was designed to help you keep current, and to prepare you to meet the needs of your customers and users, within business of all sizes. You'll find the self-study design lets you proceed at your own pace, while learning the material necessary to complete the formal certification exams for a DB2 Database Administrator or DB2 Database Developer. As the importance of data to businesses grows, and as increasingly the responsibility for keeping technical skills current rests with the technical professional, I think you'll find this guide provides a cost-effective and efficient way to meet your business needs. The latest DB2 technology puts customers on the road to getting even more value form their data. I think you'll enjoy being part of the journey.

Hershel Harris
Manager, Database Technology
IBM Software Solutions Division

Preface

This book is a complete guide to the IBM's relational database servers, known as DB2 Universal Database Version 5. DB2 Universal Database (UDB) Version 5 is available on many operating systems, and the book has been written with this in mind. Any significant differences in the implementation of DB2 on various operating systems are highlighted. If you are planning to become certified, or you would simply like to understand the powerful new DB2 database servers from IBM, then read on. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of each chapter. There are exercises provided at the end of many of the chapters to provide hands-on use of DB2.
The book is divided into 3 main sections:
  • DB2 Fundamentals (Chapters 1-5)
    • Installing and configuring DB2 servers and clients are covered in Chapters 1, 2, and 3. The Structured Query Language (SQL) is discussed in Chapter 4 and database concurrency is discussed in Chapter 5.
  • DB2 Database Administration (Chapters 6-8)
    • Creating a DB2 database and its related table spaces is covered in Chapter 6. The common administration tasks are discussed in Chapter 7, database monitoring and performance considerations are discussed in Chapter 8.
  • DB2 Application Development (Chapters 9-10)
    • Developing a static embedded SQL application is covered in Chapter 9. Alternate DB2 programming interfaces, including Call Level Interface (CLI) and dynamic embedded SQL, are discussed in Chapters 9 and 10.
      Exercises are provided at the end of most of the chapters. The exercises make references to files that can be found on the companion CD-ROM. The exercises are provided to enforce that the concepts discussed in the chapter are understood. Any Intel DB2 operating environment can be used to perform the exercises.
      This book can be used as a self-study guide to prepare for the DB2 certification exams or as a complete guide to DB2 Universal Database.
      The path to certification involves successfully completing two exams:

      The test objectives are provided in Appendixes A, B, and C. These should be used as a guide to ensure that you are fully prepared to take the DB2 exams.
      The DB2 Fundamentals Exam (503) covers these skills:
  • Understanding DB2 products and components
  • Creating database objects
  • Understanding various DB2 data types
  • Using SQL to manipulate database objects
  • Describing DB2 concurrency

    For more details on the contents of this exam, see "DB2 Fundamentals (503) - Test Objectives" on page 714.
    The DB2 Database Administration Exam (504) covers these skills:
  • Managing DB2 instances
  • Creating and maintaining database objects
  • Managing table spaces
  • Using utilities: IMPORT, LOAD, REORG, RUNSTATS
  • Managing recovery procedures (BACKUP/RESTORE)
  • Analyzing resource problems
    For more details on the contents of this exam, see "DB2 UDB V5 Database Administration (504) - Test Objectives" on page 718.
    The DB2 Application Development exam (505) covers these skills:
  • Developing static embedded SQL programs
  • Developing dynamic embedded SQL programs
  • Using host variables, parameter markers, and cursors
  • Understanding dynamic SQL (Call Level Interface)
    For more details on the contents of this exam, see "DB2 UDB V5 Application Development (505) - Test Objectives" on page 722.
    Conventions
    Many examples of SQL statements, DB2 commands, and operating system commands are included throughout the book. SQL statements are usually displayed within a shaded box and any of the mandatory sections of the statements are shown in uppercase. An example of an SQL statement is shown:
    SQL is not a case-sensitive language, so the above query would provide the same result regardless of the case of the SQL keywords, or the database object (table names or column names). Of course the data stored in the database is stored exactly as it was entered (including case). Therefore, the above query would only find the candidates with the last name of `JANACEK' or `SNOW'. If the data were stored as `Janacek', it would not be part of the result table.
    If SQL keywords are referred to in the text portion of the book, they will be shown as a bold mono-spaced font. For example, the SELECT statement is used to retrieve data from a DB2 database.
    DB2 commands will be shown using the same method as SQL keywords. For example, the CREATE DATABASE command allows you to define the initial location of database objects. DB2 commands are issued from the Command Line Processor (CLP) utility. This utility will accept the commands in upper and lower case. The CLP program itself is an executable called db2. In some operating systems, such as AIX, the program names are case sensitive. Therefore, be careful to enter the program name using the proper case. There are a few operating system specific commands in this book. If the commands must be in lowercase they will be shown as such. For example, the UNIX command to create a user is the mkuser command.
    Occasionally, notes are provided to highlight a particular point.
    - A note may be used to explain a minor operating system difference or it may be used to summarize a concept.
    There are a few syntax diagrams shown in the book. We recommend that the Command Line Processor be used to verify the syntax of DB2 commands. Some of the commands are shown with the complete syntax as shown in the Command Line Processor. The following is an example of complete syntax of the DB2 BACKUP DATABASE command.
    A syntax diagram shows how the command should be entered using the Command Line Processor. The diagram should be followed from left to right, and from top to bottom. Parameters are regarded as keywords or variables. A parameter can be a combination of a keyword and a variable.
    · Keywords represent constants in the command. They are shown in uppercase in the syntax diagram. For example, BACKUP DATABASE is a keyword. A keyword may be entered in upper-, lower-, or mixed case.
    · Variables are values that are user supplied. They are indicated in the command syntax using lowercase. At the command prompt, they may be entered in either upper-, lower-, or mixed case, unless case restrictions are explicitly stated. Some of the user-supplied variables are required, such as database-alias in the BACKUP DATABASE command.
    The vertical bar "" means that the keyword following is required. Optional parameters are indicated in the syntax with square brackets "" . An optional parameter may have a possible list of user-supplied input values. This is indicated with the combination of "{" and three periods "...". For example, a user may back up multiple table spaces using a single BACKUP DATABASE command. The DB2 SQL Reference should be used to verify the syntax of SQL statements. To emphasize a term or concept, the term is shown in bold type or emphasized with italics.
    How this Book was Created
    This book was a joint effort between the Austin ITSO (International Technical Support Organization) and the IBM Toronto Lab. The ITSO is a group within IBM whose mission is to provide skill transfer on new products and technology worldwide. We provide direct feedback to the IBM software labs as we gather input from various groups of DB2 users, including IBM support personnel, customers and business partners. The ITSO provides a working environment for interested individuals to work with new IBM software products. These individuals may include IBM employees and customers. The team develops a workshop or book, known as a redbook.
    - ITSO redbooks - ...
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)