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...