Table of Contents
44 Tips In 66 Minutes
#1: Use RUNSTATS on the Catalog
#2: REORG the DB2 Catalog
#3: More Catalog REORG Scenarios
#4: Catalog REORG Gotchas
#5: Create Indexes on the Catalog
#6: Numeric vs. Character Datatype
#7: Put More Logic in the Database
#8: Implement Procedural DBA
#9: Stored Procedure Usage
#10-17: Common Sense SQL Rules
#18: Avoid Coding a Cursor
#19: Avoid Base Table Views
#20: View Usage Guidelines
#21: Avoid Sorting
#22: Inserting Data Into LONG VARCHAR Columns
#23: DATE/TIME vs. TIMESTAMP
#24: Day of the Week Calculation
#25: Avoid Arithmetic Expressions
#26: Use Multiple Bufferpools
#27: Use Global Temporary Tables
#28-32: Common Sense Naming Conventions
#33-35: Common Sense DBA Rules
#36: To Wait or To Boldly Go...
#37-39: Common Sense Security
#40: Type 2 Indexes Can Impact Storage Requirements
#41: Prepare for DB2 Version 6
#42: Migrate Away from Private Protocol Distribution
#43: Automate
#44: Think About The Future
Extra: Reorganizing the “Special” DB2 Catalog Table Spaces
PPT Slide
|