Hi,

we are reported that while querying, there are too many open connections to the Db2 system tables. we are asked to optimize the connections to the system tables while running the queries.

Found that few temporary tables like SQTTABLES, SQTCOLUMNS are being created while executing query.

Can some one help me to find out the "connections to system tables" ?
and how to optimize them?

Thanks,
Anant