DB2 Certification Guide for Common Servers
Home > Computing and Information Technology > Computer certification > DB2 Certification Guide for Common Servers
DB2 Certification Guide for Common Servers

DB2 Certification Guide for Common Servers

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

72741-2 Today, obtaining professional certification requires true expertise grounded in in-depth product knowledge and skills. Written for aspiring DB2 Database Administrators and Application Developers, this self-study guide covers the fundamentals of administering and developing applications for IBM's newest database technology, DB2 Common Server. Offering a complete guide to IBM's relational database servers, this self-paced book: *Is divided into job roles, allowing readers to focus their efforts to their specific career choices. *Includes exercises at the end of each chapter, providing hands-on experience with DB2. *Incorporates sample test questions that help readers verify exam readiness. *Features a companion CD-ROM with ready-to-run code. Whether you're preparing for certification, or are interested in gaining a better understanding of DB2, DB2 Certification Guide for Common Servers is designed to meet the needs of today's- as well as tomorrow's-database professionals.

Table of Contents:
1. Products and Components. DB2 Family. DB2 Components. DB2 Command Line Processor (CLP). DB2 Administrator's Toolkit. DB2 Products. DB2 Single-User. DB2 Server. Distributed Database Connection Services (DDCS). DB2 Software Developer's Kit (SDK). Documentation. Licensing. DB2 Client/Server Environment. Supported Communication Protocols. DB2 Resource Usage. DB2 Client/Server Scenarios. Summary. Questions. Answers. 2. Getting Started and Connected. Product Installation. AIX Considerations. OS/2 Considerations. Windows NT Considerations. Windows 95 Considerations. DB2 Client Installation. Installing the DB2 SDK. Installing the CAE. Installing the ODBC Driver. Setting Up the DB2 Environment. Creating an Instance. Starting the DB2 Instance. Stopping the DB2 Instance. Managing Instances. DB2 Interfaces. Using the Command Line Processor. Using the Database Director. Creating the Sample Database. Summary. Questions. Answers. Exercises. 3. Controlling Data Access. Security. Overview of Security. Authorization Levels. Security Considerations. DB2 Privileges (Data Control Language). Explicit and Implicit Authorizations. Establishing a DB2 Client/Server Connection. Configuring a DB2 Server. DB2 Directories. Configuring DB2 Clients. Cataloging a Database from a Client. Verifying the Connection. Binding Utilities. Instance Administration (ATTACH Command). Local Instance Administration. User Attach Scenario. Summary. Questions. Answers. Exercises. 4. Using SQL. Understanding Database Objects. Data Types. DB2-Supplied Data Types. User-Defined Data Types. NULL Values. Code Page Considerations. Selecting the Correct Data Type. DB2 Certification Database Design and Implementation. Problem Domain. Tables. Table Spaces. Schemas. Indexes. Packages. Log Files. Transactions. Locks. SQL Data Definition Language (DDL). Creating a DB2 Database. Table Space Types. Views. Indexes. Data Manipulation Language (DML). Data Retrieval (SELECT). Changing the Order of the Columns. Restricting Rows from a Table. Selecting Columns from Multiple Tables. DB2 Functions. Data Modification (INSERT/UPDATE/DELETE). Removing Data. View Classification. Advanced SQL. User-Defined Defaults. Check Constraints. Triggers. Summary. Questions. Answers. Exercises. 5. Database Concurrency. Concurrency Considerations. Concurrency Problems. Lost Update Problem. Lost Update Solutions. Uncommitted Read. Non-Repeatable Read. Phantom Read Problem. Phantom Read Solution. Isolation Level. Uncommitted Read. Cursor Stability. Read Stability. Repeatable Read. Choosing an Isolation Level. Locking. Lock Attributes. Lock Conversion. Lock Escalation. Lock Wait Behavior. Deadlock Behavior. Lock Table Statement. Summary. Questions. Answers. Exercises. 6. Data Placement. Containers. Table Spaces. Table Spaces and Containers. Extents. Table Space Types. System Managed Storage (SMS) Table Spaces. Characteristics of the Default Table Spaces. When to Use SMS Table Spaces. Database Managed Storage (DMS) Table Spaces. When to Use DMS Table Spaces. Planning a Table Space Environment. Creating Table Spaces. Performance Considerations. 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 SET CONSTRAINTS Statement. The IMPORT/EXPORT Utility. The EXPORT Utility. EXPORT Considerations. The IMPORT Utility. IMPORT Considerations. Data Maintenance. Analyzing Data's Physical Organization: REORGCHK. Table Reorganization: REORG. RUNSTATS. Using the RUNSTATS Utility. Identifying Updated Statistics. The REBIND Utility. Data Maintenance Process. Modeling a Production Environment. User Maintenance. Fenced and Not-Fenced Procedures and Functions. The LIST APPLICATIONS Command. The FORCE Command. Database Recovery. Unit of Work. Transaction. Use of Log Files. Types of Logging. Log File Usage. Backup and Restore. Performing a Table Space Level Backup or Restore. Summary of Backup/Restore Consideration. The Recovery History File. Graphical Management Tools. The Recovery Jobs Tool. The Database Director. Creating/Modifying DB2 Objects. Summary. Questions. Answers. Exercises. 8. Database Monitoring and Tuning. Obtaining Database Access Information. Explain Facility. Query Compilation. Gathering Explain Data. Using the Explain Report Tools. Examining EXPLAIN Data. Database Monitoring. Event monitoring. Visual Performance Monitors. Performance Issues. Configuring Database Resources. DB2 Sorting Methods. DB2 Server Resources. Problem Diagnosis. Performance Tuning Scenario. Summary. Questions. Answers. Exercises. Part A. Snapshot Monitoring. Part B. Event Monitoring. Part C. Sorting and Visual Explain. 9. DB2 Application Programming. DB2 Application Development Environment. Client/Server Platform. Connection Types. Choosing a DB2 Programming Method. Static Embedded SQL. Dynamic Embedded SQL. Call Level Interface (CLI). Native 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. Sample Program — REORGIT. 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 — Call Level Interface. Callable SQL Interfaces. ODBC vs. CLI. Embedded Dynamic vs. Call Level Interface. Setting Up a CLI Development Environment. Stored Procedures. User Defined Functions. COMPOUND SQL. Summary. Questions. Answers. Exercises. Part A. Dynamic Embedded SQL. Appendix A. Test Objectives — DB2 Fundamentals (500). Appendix B. Test Objectives — DB2 Database Administration (501). Appendix C. Test Objectives — DB2 Application Development (502). Appendix D. DB2 Tools and Utilities. Appendix E. DB2CERT Application Source Code. Index.


Best Sellers


Product Details
  • ISBN-13: 9780137274130
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Language: English
  • Spine Width: 22 mm
  • Width: 235 mm
  • ISBN-10: 0137274130
  • Publisher Date: 12 Dec 1996
  • Binding: SA
  • No of Pages: 608
  • Weight: 876 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
DB2 Certification Guide for Common Servers
Pearson Education (US) -
DB2 Certification Guide for Common Servers
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 Certification Guide for Common Servers

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!