News
Abstract
The ACTIVE_QUERY_INFO table function returns information about active SQL Query Engine (SQE) queries. An active query is either open or pseudo-closed.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.ACTIVE_QUERY_INFO
For complete detail, visit this IBM Documentation page: ACTIVE_QUERY_INFO
Enhanced with IBM i 7.5 SF99950 Level 7 & IBM i 7.4 SF99704 Level 28:
- Add filter and result column for the job's user
Some examples of how to use ACTIVE_QUERY_INFO include:
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
27 April 2024
UID
ibm16486899