IBM Support

STRQMQRY command - instrumented for Client Special Registers

News


Abstract

STRQMQRY command - instrumented for Client Special Registers

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Database Engineer (DBE) Enhancements > STRQMQRY command - instrumented for Client Special Registers

Similar to RUNSQLSTM, STRSQL and other database commands, the Start Query Management Query (STRQMQRY) command has been instrumented to utilize default values for the Client Special Registers.
Use these registers to identify workloads, track usage, and more.
 
Client Special Register values:
  • CURRENT CLIENT_APPLNAME - "START QUERY MANAGEMENT QUERY
  • CURRENT CLIENT_PROGRAMID - "STRQMQRY
  • CURRENT CLIENT_USERID - <actual user ID that called the command>
  • CURRENT CLIENT_WRKSTNNAME - <database name>
  • CURRENT CLIENT_ACCTNG - <Accounting code of the command user>
These values surface within SQL Performance monitors, SQL Details for Jobs, Visual Explain and elsewhere within the OnDemand Performance Center.
The Start Database Monitor (STRDBMON) command pre-filters can be used to target STRQMQRY command usage.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11168768