QUERYID bind option

The QUERYID option frees entries in the SYSIBM.SYSQUERY table, and the SYSIBM.SYSQUERYPLAN table or the SYSIBM.SYSQUERYOPTS table.

QUERYID

( number ) ( ALL )

On: FREE QUERY

number

Frees an entry in the SYSIBM.SYSQUERY table that has the same QUERYID value, and the corresponding entries in the SYSIBM.SYSQUERYPLAN table or the SYSIBM.SYSQUERYOPTS table.

ALL

Frees all the entries from the SYSIBM.SYSQUERY table and the corresponding entries from the SYSIBM.SYSQUERYPLAN table or the SYSIBM.SYSQUERYOPTS table.