Function Resolution Activity

This section shows the layout of a function resolutions block and its field descriptions.

SQL Activity Function Resolutions Workload Block

The following figure shows the layout of the function resolutions block.

      --- FUNCTION RESOLUTION(S) -----------------------------------------------------------------------------------------------

      QUERYNO  : 1383       PLANNAME : DSNTEP61  COLLECTION_ID : DSNTEP61

      APPLNAME : xxxxxxxx   PROGNAME : xxxxxxxx  CONSIS_TOKEN  : xxxxxxxxxxxxxxxx

      BIND_TIME: 01/30/10 03:28:55.21  VERSION : xxxxxxxx10xxxxxxxx20xxxxxxxx30xxxxxxxx40xxxxxxxx50xxxxxxxxxxxx64

      CURRENT_PATH : ........10........20........30........40........50........60........70........80........90.......100

                     .......110.......120.......130.......140.......150.......160.......170.......180.......190.......200

                     .......210.......220.......230.......240...........254

      .....................................................................................................................

      FUNCT_SCHEMA : xxxxxxxx  FUNCT_NAME : xxxxxxxxxxxxxxxxxx  SPECIFIC_NAME : xxxxxxxxxxxxxxxxxx  FUNCT_TYPE : xxxxx

      VIEW_CREATOR : NAME-111  VIEW_NAME  : xxxxxxxxxxxxxxxxxx  QUERY_BLOCKNO : 53

      FUNCT_TEXT   : ........10........20........30........40........50........60........70........80........90.......100

                     .......110.......120.......130.......140.......150.......160.......170.......180.......190.......200

                     .......210.......220.......230.......240...........254

Field description

Here is a description of the field labels shown in the function resolutions block:
QUERYNO
The query number.
PLANNAME
The plan name.
COLLECTION_ID
The collection ID.
APPLNAME
The name of the application.
PROGNAME
The program name.
CONSIS_TOKEN
The consistency token.
BIND_TIME
The time stamp of the bind time.
VERSION
The version ID.
CURRENT_PATH
The current path.
FUNCT_SCHEMA
A short SQL identifier, either ordinary or delimited, following the concept of qualified names consistent with the ANSI/ISO SQL92 standard.
FUNCT_NAME
The name of a function without a qualifier.
SPECIFIC_NAME
Identifies the particular function. The specific name must identify a specific function name in the explicitly or implicitly specified schema.
FUNCT_TYPE
The classification of the function:
SCALAR
Scalar UDF
TABLE
Table UDF
VIEW_CREATOR
The name of the view creator if the function is referenced in a view definition.
VIEW_NAME
The name of the view if the function is referenced in a view definition.
QUERY_BLOCKNO
A number that identifies the query block number being explained.
FUNCT_TEXT
Contains the text of the function reference, function name, and parameters. It can be up to 254 characters long.