Rebind Package panel
Panel and field definitions Figure 1 . Rebind Package panel (1 of 2)
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) Rebind Package
More: +
Verify rebind parameters:
REBIND PACKAGE(
Location . . . . .
Collection . . . . DSNUTIL +
Package . . . . . . DSNUGSQL + (
Version . . . . . . +
)) OWNER(
Package Owner . . . ARROWSB +
) QUALIFIER(
Qualifier . . . . . ARROWSB +
) 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 . +
PLANMGMT(
Plan management . . (Off, Basic, Extended or blank)
) APREUSE(
Reuse access paths N (None, Error or Warn)
) APREUSESOURCE(
Package copy . . . (Current, Previous or Original)
) APCOMPARE(
Comp access paths . (None, Error or Warn)
) APRETAINDUP(
Retain old copies . Y (Yes or No)
) GETACCELARCHIVE(
Archived Accel data (No or Yes)
) QUERYACCELERATION( (None, All, Enable,
Acceleration option enableWithfailback, eliGible)
) CONCENTRATESTMT(
Concentrate stmt. . N (No or Yes)
) CURRENTDATA(
Inhibit blocking . N (Yes or No)
) DBPROTOCOL(
3 part protocol . . D (DRDA)
) DEFER(PREPARE) / DEFER(INHERITFROMPLAN) / NODEFER(PREPARE)
Defer prepare . . . (Yes, Inherit or No)
DEGREE(
Parallelism . . . . 1 (1 or ANY)
) DESCSTAT(
Describe SQL area . Y (No or Yes)
) DYNAMICRULES(
Dynamic rules . . . (Run, Bind, Define, Invoke)
) ENCODING(
Encoding scheme . . EBCDIC (ASCII, EBCDIC, UNICODE, ccsid)
Figure 2 . Rebind Package panel (2 of 2)
) EXPLAIN(
Explain plan . . . N (Yes, No or Only)
) FLAG(
Bind messages . . . (Info, Warning, Error, Completion)
) IMMEDWRITE(
Group BP updates . N (Inheritfromplan, No or Yes)
) ISOLATION(
Isolation level . . (CS, RR, RS, or UR)
) KEEPDYNAMIC(
Keep dynamic SQL . N (No or Yes)
) 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, Deallocate, Inheritfromplan)
) SWITCH(
Package version N (Previous, Original)
) VALIDATE(
Validation time . . B (Run or Bind, Bind preferred)
) EXTENDEDINDICATOR(
Extended Indicators (No or Yes)
) CONCURRENTACCESSRESOLUTION(
Access Resolution . (Waitforoutcome or Usecurrentlycommitted)
) BUSTIMESENSITIVE(
Business Time Sens. Y (Yes or No)
) SYSTIMESENSITIVE(
System Time Sens. . Y (Yes or No)
) ARCHIVESENSITIVE(
Archive Sensitivity Y (Yes or No)
) APPLCOMPAT(
Appl. Compatibility V12R1 (V10R1 or V11R1)
)
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.