Home | Contact | Email
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.