To access these products/documents, you must
register and login to the customer area of the website.
- OSC Content V7,V8,V9 Table Definitions - Table contrasting the OSC entries for V7, V8, and V9.
- A presentation discussing how Access Paths are Selected in DB2. This presentation also provides insights into access path selection differences between versions 6, 7 and 8.
- Version to Version Access Path Comparison is a series of 17 test cases and instructions for implementing them on any of your subsystems. You are then positioned to compare your findings with ours.
Presentations
DB2 V9 Application Migration Based on V8 Experiences
IDUG 2008 Dallas Presentation: Using Spufi to Explore DB2 Hints
Manuals
DBRM Check 2.5 User's Guide (PDF)
Avoid Bind 6.3 User's Guide (PDF)
Express Hints 2.1 User's Guide (PDF)
Path Check 3.1 User's Guide (PDF)
DSNZPARM
Note: The following programs are 'as is' with no warranty stated or implied.
Hints Utility: Turn Hints On/Off
SPRMCTU: Catalog Update
SPRMXPL: Generate all explain tables
SPRMNHJ: Turn off Hybrid Join
SPRMSQC: Set mode/bypass 3390 cache
SPRMCDYN: Cache Dynamic SQL statements
SPRMVCFK: Allows VARCHAR data to be read from an index