DB2 Developers Guide (5th Edition)
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 388
Pages: 388
Authors: Craig S. Mullins
- 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
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 388
Pages: 388
Authors: Craig S. Mullins