Rebind Application Plan panel
Panel and field definitions
Figure 1 . Rebind Application Plan panel (1 of 2)
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2) Rebind Application Plan
Verify rebind parameters:
REBIND PLAN(
Plan name . . . . . FMN 2PLN1
) 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)
Figure 2 . Rebind Application Plan panel (2 of 2)
) 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
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.