---

DB2 Developers Guide (5th Edition)

ISBN: 0672326132
EAN: 2147483647

Year: 2004
Pages: 388

Authors: Craig S. Mullins

BUY ON AMAZON

• DB2 Developer s Guide
• Table of Contents
• Copyright
• Accolades for DB2 Developer s Guide:
• About the Author
• Acknowledgments
• We Want to Hear from You
• What s New in This Edition?
• Introduction
• How To Use This Book
• Part I: SQL TOOLS, TIPS, AND TRICKS
• Chapter 1. The Magic Words
• An Overview of SQL
• SQL Tools of the Trade
• Static SQL
• Dynamic SQL
• SQL Performance Factors
• Chapter 2. Data Manipulation Guidelines
• A Bag of Tricks
• SQL Access Guidelines
• Complex SQL Guidelines
• Common Table Expressions and Recursion
• Working with NULLs
• Date and Time Guidelines
• Data Modification Guidelines
• Endnotes
• Chapter 3. Using DB2 Functions
• Column Functions
• Scalar Functions
• The RAISE_ERROR Function
• MQSeries Built-in Functions
• XML Publishing Built-in Functions
• Built-in Function Guidelines
• Chapter 4. Using DB2 User-Defined Functions and Data Types
• What Is a User-Defined Function?
• Types of User-Defined Functions
• What Is a User-Defined Data Type?
• User-Defined Data Types and Strong Typing
• Chapter 5. Data Definition Guidelines
• An Overview of DB2 Database Objects
• DB2 Databases
• Creating and Using DB2 Table Spaces
• DB2 Storage and STOGROUPs
• Table Guidelines
• Normalization and Denormalization
• Assuring Data Integrity in DB2
• Views, Aliases, and Synonyms
• Index Guidelines
• Naming Conventions
• Miscellaneous DDL Guidelines
• Chapter 6. DB2 Indexes
• Creating Indexes
• Index Guidelines
• Chapter 7. Database Change Management and Schema Evolution
• Online Schema Changes
• Chapter 8. Using DB2 Triggers for Integrity
• What Is a Trigger?
• Trigger Guidelines
• Chapter 9. Large Objects and ObjectRelational Databases
• Defining the Term
• What Is a Large Object?
• LOB Guidelines
• DB2 Extenders
• Chapter 10. DB2 Security and Authorization
• Granting and Revoking Privileges
• Part II: DB2 APPLICATION DEVELOPMENT
• Chapter 11. Using DB2 in an Application Program
• Embedded SQL Basics
• Embedded SQL Guidelines
• Host Variables
• Programming with Cursors
• Embedded SELECT and Cursor Coding Guidelines
• Modifying Data with Embedded SQL
• Application Development Guidelines
• Batch Programming Guidelines
• Online Programming Guidelines
• General SQL Coding Guidelines
• Chapter 12. Dynamic SQL Programming
• Dynamic SQL Performance
• Dynamic SQL Guidelines
• Reasons You Should Know Dynamic SQL
• EXECUTE IMMEDIATE
• Non-SELECT Dynamic SQL
• Fixed-List SELECT
• Varying-List SELECT
• Chapter 13. Program Preparation
• Program Preparation Steps
• Running a DB2 Program
• Preparing a DB2 Program
• What Is a DBRM?
• What Is a Plan?
• What Is a Package?
• What Is a Collection?
• Versions
• Program Preparation Objects
• Program Preparation Guidelines
• DCLGEN Guidelines
• Precompiler Guidelines
• BIND Guidelines
• Linkage Editor Guidelines
• Chapter 14. Alternative DB2 Application Development Methods
• Developing Applications Using Only SQL
• Using ClientServer Programming Languages
• Using Fourth-Generation Languages
• Using CASE
• Using Report Writers
• Using ODBC (Call Level Interface)
• Using Java and DB2
• Using REXX and DB2
• Chapter 15. Using DB2 Stored Procedures
• What Is a Stored Procedure?
• Implementing DB2 Stored Procedures
• The Procedural DBA
• Procedural SQL
• DB2 Development Center
• Chapter 16. The Procedural DBA
• The Classic Role of the DBA
• The Role of the Procedural DBA
• Chapter 17. DB2 and the Internet
• The Internet Phenomenon
• Accessing DB2 Over the Internet
• Using XML and DB2
• Finding DB2 Information Using the Internet
• Part III: DB2 IN-DEPTH
• Chapter 18. The Doors to DB2
• TSO (Time-Sharing Option)
• CICS (Customer Information Control System)
• IMS (Information Management System)
• CAF (Call Attach Facility)
• RRSAF (Recoverable Resource Manager Services Attach Facility)
• Comparison of the Environments
• The Critical Mass
• Chapter 19. Data Sharing
• Data Sharing Benefits
• Data Sharing Requirements
• The DB2 Coupling Facility
• Data Sharing Naming Conventions
• Data Sharing Administration
• Data Sharing Application Development Guidelines
• Data Sharing Administration Guidelines
• Chapter 20. DB2 Behind the Scenes
• The Physical Storage of Data
• What Makes DB2 Tick
• Chapter 21. The Optimizer
• Physical Data Independence
• How the Optimizer Works
• Filter Factors
• Access Path Strategies
• Other Operations Performed by the Optimizer
• Access Path Strategy Compatibility
• Chapter 22. The Table-Based Infrastructure of DB2
• The DB2 Catalog
• The DB2 Directory
• Chapter 23. Locking DB2 Data
• How DB2 Manages Locking
• Locks Versus Latches
• Lock Duration
• Table Space Locks
• Table Locks
• Page Locks
• Row Locks
• Lock Suspensions, Timeouts, and Deadlocks
• Partition Independence
• Lock Avoidance
• Data Sharing Global Lock Management
• LOBs and Locking
• DB2 Locking Guidelines
• Other DB2 Components
• The Big Picture
• Part IV: DB2 PERFORMANCE MONITORING
• Chapter 24. Traditional DB2 Performance Monitoring
• DB2 Traces
• Trace Destinations
• Tracing Guidelines
• DB2 Performance Monitor (DB2 PM)
• Using DB2 PM
• Online DB2 Performance Monitors
• Viewing DB2 Console Messages
• Displaying the Status of DB2 Resources
• Monitoring zOS and OS390
• Chapter 25. Using EXPLAIN
• How EXPLAIN Works
• Access Paths and the PLAN_TABLE
• Cost Estimates and the DSN_STATEMNT_TABLE
• Function Resolution and the DSN_FUNCTION_TABLE
• EXPLAIN Guidelines
• Chapter 26. DB2 Object Monitoring Using the DB2 Catalog and RTS
• DB2 Catalog Queries
• Real Time Statistics
• Reviewing the Rules for an Effective Monitoring Strategy
• Part V: DB2 PERFORMANCE TUNING
• Chapter 27. Tuning DB2 s Environment
• Tuning the zOS and OS390 Environment
• Tuning the Teleprocessing Environment
• Chapter 28. Tuning DB2 s Components
• Tuning the DB2 Subsystem
• Tuning the Database Design
• Tuning the Application
• The Causes of DB2 Performance Problems
• Chapter 29. DB2 Resource Governing
• The Resource Limit Facility
• The QMF Governor
• Part VI: DB2 PERFORMANCE UTILITIES AND COMMANDS
• Chapter 30. An Introduction to DB2 Utilities
• Generating Utility JCL
• Monitoring DB2 Utilities
• Version 7 and the State of IBM DB2 Utilities
• Using LISTDEF and TEMPLATE
• Issuing SQL Statements in DB2 Utilities
• Chapter 31. Data Consistency Utilities
• The CHECK Utility
• The CHECK DATA Option
• The CHECK LOB Option
• The CHECK INDEX Option
• The REPAIR Utility
• The REPAIR DBD Option
• The REPAIR LOCATE Option
• The REPAIR SET Option
• REPAIR and Versions
• The REPORT Utility
• The DIAGNOSE Utility
• Chapter 32. Backup and Recovery Utilities
• The COPY Utility
• The COPYTOCOPY Utility
• The MERGECOPY Utility
• The QUIESCE Utility
• The RECOVER Utility
• The RECOVER Utility
• The REBUILD INDEX Utility
• The REPAIR Utility
• The REPORT RECOVERY Utility
• Backing Up and Restoring the System
• Chapter 33. Data Organization Utilities
• The LOAD Utility
• The UNLOAD Utility
• The REORG Utility
• Chapter 34. Catalog Manipulation Utilities
• The CATENFM Utility
• The CATMAINT Utility
• The DSNJCNVB Utility
• The MODIFY Utility
• The RUNSTATS Utility
• The STOSPACE Utility
• Chapter 35. Stand-alone Utilities and Sample Programs
• The Stand-alone Utilities
• DB2 Sample Programs
• Chapter 36. DB2 Commands
• DB2 Environment Commands
• Information-Gathering Commands
• Administrative Commands
• Environment Control Commands
• DSN Commands
• IMS Commands
• CICS Commands
• TSO Commands
• IRLM Commands
• Chapter 37. DB2 Utility and Command Guidelines
• Utility Guidelines
• The Pending States
• Chapter 38. DB2 Contingency Planning
• What Is a Disaster?
• DB2 Environmental Considerations
• DB2 Contingency Planning Guidelines
• Part VII: THE IDEAL DB2 ENVIRONMENT
• Chapter 39. Components of a Total DB2 Solution
• DB2 Tools
• DB2 Tools Vendors
• Chapter 40. Organizational Issues
• Education
• Standards and Procedures
• Operational Support
• Political Issues
• Environmental Support
• Tool Requirements
• Part VIII: DISTRIBUTED DB2
• Chapter 41. DRDA
• What Is DRDA?
• DRDA Functions
• DRDA Architectures and Standards
• The Five DRDA Levels
• Putting It All Together
• Distributed DB2
• Chapter 42. Distributed DB2
• Distributing Data Using DB2
• DB2 Support for the DRDA Levels
• Methods of Accessing Distributed Data
• System-Directed Versus Application-Directed
• Packages for Static SQL
• Two-Phase Commit
• Miscellaneous Distributed Topics
• Chapter 43. DB2 Connect
• An Overview of IBM DB2 Connect
• Chapter 44. Distribution Guidelines
• Distribution Behind the Scenes
• Block Fetch
• Dynamic Cursor Pre-Open
• Distributed Performance Problems
• Distributed Database Design Issues
• Distributed Data Placement
• Distributed Optimization
• Distributed Security Guidelines
• Miscellaneous Distributed Guidelines
• Chapter 45. Data Warehousing with DB2
• Defining the Basic Terms
• Designing a Data Warehouse
• Populating a Data Warehouse
• Accessing the Data Warehouse
• Managing the Data Warehouse
• The Big Picture
• DB2 Data Warehouse Center
• Materialized Query Tables
• General Data Warehouse Guidelines
• DB2-Specific Data Warehousing Guidelines
• Web 1. Special Consideration for DB2 Version 6
• Type 1 Indexes
• Shared Read Only Data
• RECOVER INDEX
• Host Variables Without Colons
• Dataset Passwords
• Stored Procedure Registration
• Synopsis
• Web 2. Short Summary of DB2 V4 Through V6 Changes
• DB2 Version 6 Features
• DB2 Version 5 Features
• DB2 Version 4 Features
• Web 3. Type 1 Indexes
• Basic Index Structure
• Part IX: APPENDIXES
• Appendix A. DB2 Sample Tables
• The Activity Table: DSN8810.ACT
• The Department Table: DSN8810.DEPT
• The Employee Table: DSN8810.EMP
• The Employee Photo Resume Table: DSN8810.EMP_PHOTO_RESUME
• The Employee Assignment Table: DSN8810.EMPPROJACT
• The Project Table: DSN8810.PROJ
• The Project Activity Table: DSN8810.PROJACT
• The Sample STOGROUP
• Sample Databases and Table Spaces
• Views on the Sample Tables
• Appendix B. DB2 Tools Vendors
• The Vendor List
• Appendix C. Valid DB2 Data Types
• Appendix D. DB2 Limits
• Appendix E. DB2 on Other Platforms
• The DB2 Family
• Packaging and Naming Issues
• Appendix F. DB2 Version 7 Overview
• E-Business Enhancements
• Application Development Enhancements
• Data Management Enhancements
• Business Intelligence Enhancements
• Additional V7 Information
• Appendix G. DB2 Version 8 Overview
• Architecture
• Database Administration
• Programming and Development
• Migration to DB2 V8
• Appendix H. Reorganizing the DB2 Catalog
• When Should the DB2 Catalog and Directory Be Reorganized?
• Index
• index_SYMBOL
• index_A
• index_B
• index_C
• index_D
• index_E
• index_F
• index_G
• index_H
• index_I
• index_J
• index_K
• index_L
• index_M
• index_N
• index_O
• index_P
• index_Q
• index_R
• index_S
• index_T
• index_U
• index_V
• index_W
• index_X
• index_Y