| LOCATION |
VARCHAR(128)
NOT NULL
|
Always contains blanks. |
S |
| COLLID |
VARCHAR(128)
NOT NULL
|
The name of the package collection. |
G |
| NAME |
VARCHAR(128)
NOT NULL
|
The name of the package. |
G |
| CONTOKEN |
CHAR(8)
NOT NULL
FOR BIT DATA
|
Consistency token for the package. |
S |
| VERSION |
VARCHAR(122) NOT NULL |
Version identifier for the package. |
G |
| OWNER |
VARCHAR(128)
NOT NULL
|
Authorization ID of the package owner. |
G |
| CREATOR |
VARCHAR(128)
NOT NULL
|
Authorization ID of the owner of the creator of
the package version. |
G |
| TIMESTAMP |
TIMESTAMP
NOT NULL
|
Timestamp indicating when the package was created. |
G |
| BINDTIME |
TIMESTAMP
NOT NULL
|
Timestamp indicating when the package was last
bound. |
G |
| RELBOUND |
CHAR(1)
NOT NULL
|
The Db2 release
when the package was bound or rebound. |
G |
| TYPE |
CHAR(1)
NOT NULL
|
Type of package. Identifies how the package is
created:
- F
- A CREATE FUNCTION or ALTER FUNCTION statement, or a BIND PACKAGE DEPLOY command created the
package, and this package is a non-inline SQL scalar function package.
- N
- A CREATE PROCEDURE or ALTER PROCEDURE statement, or a BIND PACKAGE
DEPLOY command created the package, and this package is a native SQL
routine package.
- blank
- A BIND PACKAGE command created the package.
|
G |
| COPYID |
INTEGER
NOT NULL
|
Internal use only. The value is zero. |
I |
| QUERYACCELERATION |
CHAR(1)
NOT NULL
|
Indicates the query acceleration behavior that
is specified for the static SQL queries in the package. This behavior
can also apply to dynamic queries in the package if the package does
not issue an explicit SET for the CURRENT QUERY ACCELERATION special
register. The QUERYACCELERATION bind option does not have a default
value.
- N
- NONE. No static SQL query in the package
is bound for acceleration or will be accelerated when the package
runs. NONE is not a default value.
- E
- ENABLE. A static SQL query is bound for acceleration
if it satisfies the acceleration criteria, including the cost and
heuristics criteria. The query is routed to an accelerator when the
application runs.
If a static query does not satisfy the acceleration
criteria, the query is bound for execution in Db2.
- F
- ENABLEWITHFAILBACK. Same behavior as ENABLE,
except if an error occurs on the first OPEN of the accelerated static
query when the application runs. In this case, instead of failing
the query and returning a negative SQL code to the application, Db2 performs a temporary statement-level incremental
bind of the query and runs the query in Db2.
- L
- ELIGIBLE. A static SQL query is bound for
acceleration if the query meets the basic acceleration criteria, regardless
of the cost or heuristics criteria. The query is routed to the accelerator
when the application runs.
- A
- ALL. All static SQL queries in the application are to be bound for acceleration and routed to the accelerator when the application runs. If Db2 determines that a static query cannot be bound to run on the accelerator and the query references a user base table or view, Db2 fails
the BIND or REBIND PACKAGE operation with an error message for that
query.
|
G |
| GETACCELARCHIVE |
CHAR(1)
NOT NULL
|
Indicates whether a static SQL query should retrieve
archived data from the accelerator instead of active data from the
accelerator. This behavior can also apply to dynamic queries in the
package if the package does not issue an explicit SET for the CURRENT
GET_ACCEL_ARCHIVE special register. The GETACCELARCHIVE bind option
does not have a default value.
- N
- NO. No static SQL query is bound to retrieve
archived data from the accelerator. If the static query also is not
bound for acceleration, the query is bound to run in Db2.
If the static query is bound for acceleration
because the QUERYACCELERATION bind option is specified, when the application
is run the query is routed to the accelerator. However, the query
retrieves only active data on the accelerator. Archived data is not
retrieved.
- Y
- YES. If the static query is bound for acceleration,
the query retrieves archived data on the accelerator when the application
runs if the following criteria is met:
- The QUERYACCELERATION bind option is also specified.
- The static SQL query references an accelerated table that has
partitioned data archived on an accelerator.
If the static query cannot be bound for acceleration, Db2 fails the BIND or REBIND PACKAGE
operation with an error message for that query.
|
G |
| ACCELERATOR |
VARCHAR(128) NOT NULL |
Indicates the preferred target accelerator or accelerators to be used for queries
accelerated from this Db2 package:
- accelerator-name
- An unqualified name that identifies an accelerator. An accelerator name can consist of 1–8
uppercase characters or numbers. The name must be unique within the Db2 subsystem or data sharing group. This name can
be a physical accelerator name or a logical name (alias) that maps to a physical accelerator name or
a group of physical accelerator names.
- blank
-
If the ACCELERATOR bind option not specified, this is the default value, which indicates that no
preferred target accelerator will be used and Db2 will determine the target accelerator.
|
G |
| ACCELERATION_WAITFORDATA |
DECIMAL(5,1) NOT NULL |
Indicates the maximum amount of time, if any, that the accelerator will delay a
query while the accelerator waits for the replication of committed Db2 data changes that occurred prior to Db2 running the query.
- nnnn.m
- If the ACCELERATIONWAITFORDATA bind option is specified, this value indicates the maximum
decimal number of seconds that the accelerator will delay the query when needed.
- -1.0
-
If the ACCELERATIONWAITFORDATA bind option is not specified, this is the default value of this
catalog column. Db2 considers this as the
default value of 0.0. No accelerator delay is requested, and static queries accelerated from this
Db2 package will not be delayed.
|
G |