Home > Computing and Information Technology > Computer certification > DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide
DB2 Universal Database V6.1 for Unix, Windows and OS/2  Certification Guide

DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

This is IBM's definitive guide to the newest version of DB2 Universal Database. It contains end-to-end coverage for every DB2 developer and administrator -- and for anyone who wants to achieve IBM DB2 certification. Start with a detailed overview of the DB2 family of products, key DB2 concepts, and terminology. Next, walk through installing DB2, setting up DB2 clients (including ODBC support); and controlling data access through authentication, assigned authorities, and user/group privileges. Understand DB2 SQL in depth, including database objects, the Data Definition Language (DDL), triggers, outer joins, OLAP SQL, table hierarchies, and concurrency. Master DB2 administration, including the optimal physical placement of data; populating DB2 tables with IBM's import and load utilities; monitoring, maintenance and tuning; logging; and database recovery. Finally, master the basics of DB2 application development. Review each programming method and interface provided by DB2; master embedded SQL; even learn the basics of CLI, ODBC, JDBC, and ADO.

Table of Contents:
I. INTRODUCTION TO DB2 UDB. 1. Product Overview. DB2 Universal Database—The Scalable Database. DB2 Universal Database Products. DB2 Universal Database. DB2 UDB Personal Edition. DB2 UDB Workgroup Edition. DB2 UDB Enterprise Edition. DB2 UDB Enterprise-Extended Edition. DB2 Connect. DB2 Connect Personal Edition. DB2 Connect Enterprise Edition. DB2 Developer's Edition. DB2 Satellite Edition. Satellite Components. Logical Components. Model Office. Maintenance of Satellite Systems. DB2 Data Links Manager. DB2 Data Links Manager System Overview. Components of a Data Links Server. Data Links Manager Facilities. DB2 Query Patroller. DB2 Licensing. Client/Server Communication Protocols. DB2 UDB Resource Usage. Features and Functions. The Control Center. Other Tools Available from the Control Center. The SmartGuides. Other DB2 UDB Tools. The Command Line Processor (CLP). Summary. Questions. Answers. 2. Getting Started. Product Installation. Windows NT/9x and OS/2 Installation. UNIX Installation. DB2 Client Installation. Distributed Installation. The DB2 UDB 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. Using the Command Line. Using First Steps. Summary. Questions. Answers. Exercises. 3. Getting Connected. Roadmap to Client/Server Communications. Automated Configuration using Discovery. Automated Configuration Using Access Profiles. Manual Configuration. DB2 Discovery. DB2 Directories. Examining DB2 UDB Directories. Configuring DB2 Clients. Automated Configuration using Discovery. Using Access Profiles. Manual Configuration. Summary of Configuring Connections. Configuring Communications. Configuring the DB2 Instance for Communications. Configuring the DAS Instance. Configuring DB2 Discovery. Binding Utilities. Binding Utilities Using the CCA. Instance Administration. Local Instance Administration. Attaching to an Instance using the Control Center. Summary. Questions. Answers. 4. Controlling Data Access. Security. Overview of Security. Authentication. Authorities and Privileges. Windows NT Considerations. Auditing. Summary. Questions. Answers. Exercises. II. USING SQL. 5. Database Objects. Understanding Database Objects. Data Types. Tables. Schemas. Table Spaces. Views. Indexes. Packages. Buffer Pools. Transactions. Locks. Log Files. Creating a DB2 UDB Database. Managing Database Objects. Using SQL Data Definition Language (DDL). Data Types. Tables. Views. Indexes. Database Design and Implementation. DB2CERT Database Table Descriptions. Define User-Defined Data Types. Defining Columns. Keys. Defining Primary Keys. Defining Unique Keys. Defining Foreign Keys. Summary. Questions. Answers. Exercises. 6. Manipulating Database Objects. Data Retrieval. Retrieving the Entire Table. Projecting Columns from a Table. Changing the Order of the Columns. Restricting Rows from a Table. Predicate Evaluation for UDTs. Restricting Rows Using Multiple Conditions. Selecting Columns from Multiple Tables. Using Correlation Names. Sorting Your Output. Derived Columns. DB2 Functions. Grouping Values. Eliminating Duplicates. Searching for String Patterns. Searching for Data in Ranges. Searching for Null Values. Searching for Negative Conditions. Searching for a Set of Values. Sub-Queries. Quantified Predicates. Case Expressions. Nested Table Expressions. Scalar Fullselect. Common Table Expressions. Set Operators. Data Modification. Inserting Data Records. Updating Data Records. Removing Data. View Classification. Deletable Views. Updatable Views. Insertable Views. Read-Only Views. Inoperative views. Summary. Questions. Answers. Exercises. 7. Advanced SQL. Triggers. Trigger Usage. Trigger Activation. Trigger Example (After Trigger). Trigger Example (Before Trigger). Recursive SQL. Outer Join. Left Outer Join. Right Outer Join. Full Outer Join. Combining Outer Joins. OLAP Features. STAR Schemas. OLAP Indexes. STAR Joins. Super Grouping. Advanced CASE Expressions. Using CASE expressions to Group Values. Using CASE expressions in Functions. Structured Types and Typed Tables. Creating Structured Types. Altering Structured Types. Creating Typed Tables. Dropping Typed Tables. Inserting Rows into a Typed Table. Selecting a Row from a Typed Table. Updating and Deleting Rows from Typed Tables. Physical Implementation of Typed Tables. Reference Columns. View Hierarchies. SQL Functions for typed tables and typed views. TYPE Predicate. Considerations when using Typed tables and views. Examples of a Typed Table Hierarchy. Summary Tables. Creating a summary table. CURRENT REFRESH AGE Special Register. Considerations of using Summary Tables. System Catalog Information for Summary Tables. Summary. Exercises. 8. Concurrency. Concurrency. Concurrency Considerations. Isolation Levels. Uncommitted Read. Cursor Stability. Read Stability. Repeatable Read. Choosing an Isolation Level. Locking. Lock Attributes. Lock Conversion. Lock Escalation. Lock Wait Behavior. Lock Table Statement. LOCKSIZE parameter of ALTER TABLE statement. Summary. Questions. Answers. Exercises. III. DB2 UDB ADMINISTRATION. 9. Data Storage Management. Buffer Pools. Table Spaces. SMS Table Spaces. DMS Table Spaces. Regular Table Spaces. Long Table Spaces. Temporary Table Spaces. Containers. Directory Containers. Device Containers. File Containers. Extents. Pages. Long Field Data. Large Object Data. Planning and Design. Sizing the Processor, Disk and Memory. Table Space Design. Implementation. Creating a Database. Creating Buffer Pools. Creating Table Spaces. Creating Tables. Dropping Table Spaces. Dropping Buffer Pools. Dropping a Database. Creating Table Spaces Using the Control Center. Table Space Maintenance. Database Files. Listing Table Spaces. Listing Table Space Containers. Table Space States. System Catalog Information About Table Spaces. Adding Containers to DMS Table Spaces. Summary. Questions. Answers. Exercises. 10. Maintaining Data. Moving data. Delimited ASCII files. Non-Delimited ASCII Files. PC/IXF Files. Worksheet Format Files. Data Movement Utilities. The Export Utility. The IMPORT Utility. The Load Utility. The LOAD QUERY Command. The SET INTEGRITY Statement. The DB2MOVE Utility. The DB2LOOK Utility. Data Maintenance. Analyzing Data's Physical Organization. Table Reorganization. Generating Statistics. The Rebind Utility. Data Maintenance Process. Modelling a Production Environment. Summary. Questions. Answers. Exercises. 11. Database Recovery. Database Recovery Concepts. Unit of Work. Transaction. Types of Recovery. Recovery Strategies. Recoverable and Non-Recoverable Databases. Online and Offline Access. Use of Log Files. Log Buffers. Primary and Secondary Log Files. Types of Logging. Log File Usage. Version Recovery using Backup and Restore. Roll-Forward Recovery. Managing Log Files. Other Recovery Considerations. Summary. Questions. Answers. Exercises. 12. Monitoring and Tuning. Elements of Performance. Tuning Guidelines. Performance Improvement Process. How Much Can a System Be Tuned? A Less Formal Approach. Monitoring Methods in DB2 UDB. Obtaining Database Access Information. Explain Facilities. Overview of the SQL Compiler. Explain Tables. Gathering Explain Data. Examining EXPLAIN Data. Guidelines on Using EXPLAIN Output. Indexes Advisor Facility. Database Monitoring. Snapshot Monitoring. Event Monitoring. Visual Performance Monitors. DB2 Governor. Performance Issues. Configuring Database Resources. DB2 Sorting Methods. DB2 Server Resources. Query Parallelism. Intra-Partition and Inter-Partition Parallelism. Setting Up Intra-Partition Parallelism. Performance Tuning Scenario. Diagnostics and Problem Determination. Error Messages and SQL Codes. Tracing Problems in DB2 Universal Database. Summary. Questions. Answers. Exercises. IV. DEVELOPING APPLICATIONS. 13. Programming Overview. DB2 UDB Application Development Environment. Software Requirements. Application Development Considerations. Choosing a DB2 UDB Programming Interface. Embedded SQL. Call Level Interface and ODBC. Java Interfaces (JDBC and SQLJ). Native DB2 UDB APIs. Microsoft Data Objects (DAO, RDO, ADO). Other Interfaces and Tools. Choosing DB2 UDB Server-Side Features. DB2 UDB Application Overview. Using Schemas and Aliases. Schema. Alias. Summary. Questions. Answers. 14. Embedded SQL Programming. Embedded SQL Overview. Creating Packages. Binding Applications. Static Embedded SQL. Host Variables. Connecting to Databases. Error Handling—Using and Interpreting the SQLCA. Error Handling—Message Retrieval. Indicator Variables. Data Retrieval Methods. Using Cursors. Dynamic Embedded SQL. First Look at Dynamic SQL. Dynamic SQL Phases. Other Concepts. Types of Dynamic SQL Statements. SQLDA Data Structure. Summary. Questions. Answers. Exercises. 15. Other Programming Methods. Support for CLI and ODBC Programming. Embedded Dynamic versus Call Level Interface. ODBC versus CLI. Setting Up the CLI Environment. Coding a DB2 UDB CLI Application. Support For Java Programming. JDBC Programming. SQLJ Programming. Building, Distributing and Running Java Programs. Other Application Interfaces. Programming with ActiveX Data Objects. Advanced DB2 UDB Programming Features. Stored Procedures. User Defined Functions. Large Objects. Compound SQL. Summary. Questions. Answers. Exercises. V. APPENDICES. Appendix A: DB2 UDB V. Certification Test Objectives. DB2 UDB V6.1 Fundamentals. DB2 UDB V6.1 Database Administration. DB2 UDB V6.1 Application Development. Appendix B: Example DB2 UDB Source Code. Index. CD-ROM Installation.


Best Sellers


Product Details
  • ISBN-13: 9780130867551
  • Publisher: Pearson Education (US)
  • Publisher Imprint: IBM Press
  • Height: 235 mm
  • No of Pages: 1014
  • Weight: 1397 gr
  • ISBN-10: 0130867551
  • Publisher Date: 03 Dec 1999
  • Binding: SA
  • Language: English
  • Spine Width: 41 mm
  • Width: 178 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
DB2 Universal Database V6.1 for Unix, Windows and OS/2  Certification Guide
Pearson Education (US) -
DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA