Home |
Contact |
Email
Business Risk Mitigation Solutions
About
Solutions
Overview
Express Hints
Access Path Compare
Services
Trials
Support
Contact Us
Links
Downloads
OSC Content V7,V8,V9 Table Definitions
Table contrasting the OSC entries for V7, V8, and V9.
Access Path Comparisons
Access Path Comparison Presentation
Access Path Version to Version Comparison Instructions
17 Access Path Comparison Test Cases
Presentations
IDUG 2009 Denver Presentation: Bind and Rebind Analysis
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 Manual (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
Subsystems' Parameters Analysis
Describe 3.0 (R4)
IBM System z9 photo Courtesy of International Business Machines Corporation. Unauthorized use not permitted.
Copyright © 2001-2011 HLS Technologies Inc.