DSN_PGRANGE_TABLE
The page range table, DSN_PGRANGE_TABLE, contains information about qualified partitions for all page range scans in a query.
![Begin program-specific programming interface information.](../cmn/../art/pspi_opn.gif)
![Start of change](KC_ROOT/images/ddita/delta.gif)
![End of change](KC_ROOT/images/ddita/deltaend.gif)
Qualifiers
- 'SYSIBM'
One instance of this table can be created with the SYSIBM qualifier. DB2 and SQL optimization tools might use the table and the data that it contains. The table is created when you run job DSNTIJSG when you install or migrate DB2.
- 'user-ID'
- You can create additional instances of EXPLAIN tables that are qualified by user ID. These tables are populated with statement cost information when you issue the EXPLAIN statement or bind. They are also populated when you specify EXPLAIN(YES) or EXPLAIN(ONLY) in a BIND or REBIND command. SQL optimization tools might also create EXPLAIN tables that are qualified by a user ID. You can find the SQL statement for creating an instance of these tables in member DSNTESC of the SDSNSAMP library.
Sample CREATE TABLE statement
You can find a sample CREATE TABLE statement for each EXPLAIN table in member DSNTESC of the prefix.SDSNSAMP library.
Column descriptions
The following table describes the columns of DSN_PGRANGE_TABLE.
Column name | Data type | Description |
---|---|---|
QUERYNO | INTEGER NOT NULL | A number that identifies the statement
that is being explained. The origin of the value depends on the context of the row:
When the values of QUERYNO are based on the statement number in the source program, values that exceed 32767 are reported as 0. However, in certain rare cases, the value is not guaranteed to be unique.
|
QBLOCKNO | SMALLINT NOT NULL | A number that identifies each query block within a query. The value of the numbers are not in any particular order, nor are they necessarily consecutive. |
TABNO | SMALLINT NOT NULL | The table number, a number which uniquely identifies the corresponding table reference within a query. |
RANGE | SMALLINT NOT NULL | The sequence number of the current page range. |
FIRSTPART | SMALLINT NOT NULL | The starting partition in the current page range. |
LASTPART | SMALLINT NOT NULL | The ending partition in the current page range. |
NUMPARTS | SMALLINT NOT NULL | The number of partitions in the current page range. |
EXPLAIN_TIME | TIMESTAMP NOT NULL | The
time when the EXPLAIN information was captured:
|
GROUP_MEMBER | VARCHAR(24) NOT NULL | The member name of the DB2 that executed EXPLAIN. The column is blank if the DB2 subsystem was not in a data sharing environment when EXPLAIN was executed. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![End program-specific programming interface information.](../cmn/../art/pspi_cls.gif)