「Rebind Application Plan (アプリケーション・プランの再バインド)」パネル
パネルとフィールドの定義
Process Options Utilities Help ────────────────────────────────────────────────────────────────────────────── FM/Db2 (DFG2) Rebind Application Plan Verify rebind parameters: REBIND PLAN( Plan name . . . . . FMN2PLN1 ) OWNER( Plan owner . . . . SHRIKES + ) QUALIFIER( Qualifier . . . . . SHRIKES + (qualifier for unqualified SQL) ) ENABLE( (use ? to get current values from the catalog) Enable connects . . ) DISABLE( (use ? to get current values from the catalog) Disable connects . ) (use ? to get current values from the catalog) En/disable names . ) PKLIST( (use ? to get current values from the catalog) Package lists . . . + ) NOPKLIST( (use ? to get current values from the catalog) No package list . . (Yes or No to remove current package list) ) DEFER(PREPARE)/NODEFER(PREPARE) Defer prepare . . . (Yes or No) ) CACHE( Cache size . . . . 3072 (Cache size in bytes for authorization IDs) ) CURRENTDATA( Inhibit blocking . (Yes or No) ) CURRENT SERVER( Server name . . . . (blank=local, else first location) DEGREE( Parallelism . . . . 1 (1 or ANY) ) DISCONNECT( Disconnect . . . . E (Explicit, Automatic or Conditional) ) DYNAMICRULES( Dynamic rules . . . (Run or Bind) ) ENCODING( Encoding scheme . . (ASCII, EBCDIC, UNICODE, ccsid) ) EXPLAIN( Explain plan . . . N (Yes or No to explain access path)
) FLAG(
Bind messages . . . (Info, Warning, Error, Completion)
) IMMEDWRITE(
Group BP updates . N (No or Yes)
) ISOLATION(
Isolation level . . (CS, RR, RS, or UR)
) KEEPDYNAMIC(
Keep dynamic SQL . N (Yes or No)
) REOPT(VARS)/NOREOPT(VARS)
Re-opt at exec . . N (None, Always, Once, aUto)
) OPTHINT(
Access path hint . +
) PATH(
UDT/UDF/STP path . +
) PATHDEFAULT
Default path . . . (Yes or No)
) RELEASE(
Release at . . . . C (Commit or Deallocate, Commit preferred)
) ROUNDING( (Ceiling, Down, Floor,
DFP Rounding . . . HalfDown, HalfEven, HalfUp, Up)
) SQLRULES(
Connect2 rules . . D (Db2 or STD)
) VALIDATE(
Validation time . . B (Run or Bind, Bind preferred)
) CONCURRENTACCESSRESOLUTION(
Access Resolution . (Waitforoutcome or Usecurrentlycommitted)
) PROGAUTH(
Progauth checking . (Disable or Enable)
)
Command ===>
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
親パネル
子パネル
なし。