Set Optimizer Hint panel

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                 Set Optimizer Hint

    Insert a hint for the optimizer into FMNUSER.PLAN_TABLE.

 Columns Considered by the Optimizer:
    Query number . . . 1          
    Query block number 1     
    Application plan .                    (blank for packages)
    DBRM/package . . . MGRMAIN 
    Collection . . . . FMN2PLN1           (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