Hi.
I am looking to query our of the db2 internal system tables the unique identifier of a SQL statement as well as the unique identifier of the execution plan. I need to see those for an active query.
In Oracle - each sql statement has a hash_value which is a unique identifier (column hash_value in v$sql)
in addition, each execution plan has a unique identifier called plan_hash_value (column plan_hash_value in v$sql)
I am looking for the equivalent in DB2. is there anything like this (I read something about sql token but unable to find the right snapshot view or table function to find it)
please advice.
I am looking to query our of the db2 internal system tables the unique identifier of a SQL statement as well as the unique identifier of the execution plan. I need to see those for an active query.
In Oracle - each sql statement has a hash_value which is a unique identifier (column hash_value in v$sql)
in addition, each execution plan has a unique identifier called plan_hash_value (column plan_hash_value in v$sql)
I am looking for the equivalent in DB2. is there anything like this (I read something about sql token but unable to find the right snapshot view or table function to find it)
please advice.