Set Optimizer Hint panel
Panel and field definitions
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) Set Optimizer Hint
Insert a hint for the optimizer into HFM USER.PLAN_TABLE.
Columns Considered by the Optimizer:
Query number . . . 1
Query block number 1
Application plan . (blank for packages)
DBRM/package . . . MGRMAIN
Collection . . . . HFM 2PLN1 (blank for plans)
Version . . . . .
Access method . . 0 (0, 1, 2, 3, or 4)
Access type . . . (I, I1, N, R, M, MX, MI, MU)
Table owner . . . SYSIBM
Table name . . . . SYSTABLES
Correlation name .
Table number . . . 1
Index owner . . .
Index name . . . . (required for access type I, I1, or N)
Sort new table . . N
Sort composite . . N
Prefetch . . . . . S (' ', S, or L)
Parallelism . . . ? (?, I, C, or X)
Access degree . . ? (? lets Db2 decide)
Join degree . . . ? (? lets Db2 decide)
Hint ID . . . . . (required hint ID)
Comment . . . . .
Command ===>
F1=Help F2=Split F3=Exit F4=CRetriev F7=Backward F8=Forward
F9=Swap F10=Actions F12=Cancel
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.