Rebind Trigger Package panel
The Rebind Trigger Package panel specifies options for rebinding a trigger package.
The following figure shows those options.
DSNEBP19 REBIND TRIGGER PACKAGE SSID: DSN
COMMAND ===>_
1 Rebind all trigger packages ===> (* to rebind all packages)
or
Enter trigger package name(s) to be rebound:
2 LOCATION NAME ............. ===> (Defaults to local)
3 COLLECTION-ID (SCHEMA NAME) ===> > (Required)
4 PACKAGE-ID (TRIGGER NAME).. ===> > (Required)
Enter options as desired ...... ===>
5 ISOLATION LEVEL ........... ===> SAME (SAME, RR, RS, CS, UR, or NC)
6 RESOURCE RELEASE TIME ..... ===> SAME (SAME, DEALLOCATE, or COMMIT)
7 EXPLAIN PATH SELECTION .... ===> SAME (SAME, NO, or YES)
8 DATA CURRENCY ............. ===> SAME (SAME, NO, or YES)
9 IMMEDIATE WRITE OPTION .... ===> SAME (SAME, NO, YES)
10 PLAN MANAGEMENT ........... ===> DEFAULT (DEFAULT, BASIC, EXTENDED, OFF)
11 ACCESS PATH REUSE ......... ===> DEFAULT (DEFAULT, ERROR, NONE, or WARN)
12 ACCESS PATH COMPARISON .... ===> DEFAULT (DEFAULT, ERROR, NONE, or WARN)
13 ACCESS PATH RETAIN DUPS ... ===> DEFAULT (DEFAULT, NO, or YES)
14 SYSTEM_TIME SENSITIVE ..... ===> SAME (SAME, NO, or YES)
15 BUSINESS_TIME SENSITIVE ... ===> SAME (SAME, NO, or YES)
16 ARCHIVE SENSITIVE ......... ===> SAME (SAME, NO, or YES)
17 APPLICATION COMPATIBILITY . ===> SAME (SAME, DB2 function level
V10R1, V11R1)
This panel lets you choose options for rebinding a trigger package.
- 1 Rebind all trigger packages
- Lets you rebind all packages on the local DBMS. To do so, place an asterisk (*) in this field; otherwise, leave it blank.
- 2 LOCATION NAME
- Lets you specify where to bind the trigger package. If you specify a location name, you should use of 1–16 characters, and you must have defined it in the catalog table SYSIBM.LOCATIONS.
- 3 COLLECTION-ID (SCHEMA NAME)
- Lets you specify the collection of the trigger package to rebind. You must specify a collection ID of 1–128 characters, or an asterisk (*) to rebind all collections in the local Db2 system. You cannot use the asterisk to rebind a remote collection. This field is scrollable.
- 4 PACKAGE-ID
- Lets you specify the name of the trigger package to rebind. You must specify a package ID from 1 to 128 characters, or an asterisk (*) to rebind all trigger packages in the specified collections in the local Db2 system. You cannot use the asterisk to rebind a remote trigger package. This field is scrollable.
- 5 ISOLATION LEVEL
- Lets you specify how far to isolate your application from the effects of other running applications. The default is the value used for the old trigger package.
- 6 RESOURCE RELEASE TIME
- Lets you specify COMMIT or DEALLOCATE to tell when to release locks on resources. The default is that used for the old trigger package.
- 7 EXPLAIN PATH SELECTION
- Lets you specify YES or NO for whether to obtain EXPLAIN information
about how SQL statements in the package execute. The default is the
value used for the old trigger package.
The bind process inserts information into the table owner.PLAN_TABLE, where owner is the authorization ID of the plan or package owner. If you defined owner.DSN_STATEMNT_TABLE, Db2 also inserts information about the cost of statement execution into that table. If you specify YES in this field and BIND in the VALIDATION TIME field, and if you do not correctly define PLAN_TABLE, the bind fails.
- 8 DATA CURRENCY
- Lets you specify YES or NO for whether you need data currency
for ambiguous cursors opened at remote locations. The default is the
value used for the old trigger package.
Data is current if the data within the host structure is identical to the data within the base table. Data is always current for local processing.
- 9 IMMEDIATE WRITE OPTION
- Specifies when Db2 writes
the changes for updated group buffer pool-dependent pages. This field
applies only to a data sharing environment. The values that you can
specify are:
- SAME
- Choose the value of IMMEDIATE WRITE that you specified when you bound the trigger package. SAME is the default.
- NO
- Write the changes at or before phase 1 of the commit process.
If the transaction is rolled back later, write the additional changes
that are caused by the rollback at the end of the abort process.
PH1 is equivalent to NO.
- YES
- Write the changes immediately after group buffer pool-dependent pages are updated.
- 10 PLAN MANAGEMENT
- Specifies the PLANMGMT option to use for rebinding the trigger. DEFAULT means to take the default setting for this option when rebinding for the old trigger package.
- 11 ACCESS PATH REUSE
- Specifies the APREUSE option to use for rebinding the trigger. DEFAULT means to take the default setting for this option when rebinding for the old trigger package.
- 12 ACCESS PATH COMPARISON
- Specifies the APCOMPARE option to use for rebinding the trigger. DEFAULT means to take the default setting for this option when rebinding for the old trigger package.
- 13 ACCESS PATH RETAIN DUPS
- Specifies the APRETAINDUP option to use for rebinding the trigger. DEFAULT means to take the default setting for this option when rebinding for the old trigger package.
- 14 SYSTEM_TIME SENSITIVE
- Specifies the SYSTIMESENSITIVE option to use for rebinding the trigger. SAME means to take the previous setting for this option when rebinding the old trigger package.
- 15 BUSINESS_TIME SENSITIVE
- Specifies the BUSTIMESENSITIVE option to use for rebinding the trigger. SAME means to take the previous setting for this option when rebinding the old trigger package.
- 16 ARCHIVE SENSITIVE
- Specifies the ARCHIVESENSITIVE option to use for rebinding the trigger. SAME means to take the previous setting for this option when rebinding the old trigger package.
- 17 APPLICATION COMPATIBILITY
- Specifies the APPLCOMPAT option to use for rebinding the trigger. SAME means to take the previous setting for this option when rebinding the old trigger package.