IBM Support

Extend STRDBMON to support FTRUSER against group profiles

News


Abstract

The STRDBMON command has been enhanced to recognize GROUP profile names on the FTRUSER(name) command parameter.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Database Engineer (DBE) Enhancements > Extend STRDBMON to support FTRUSER against group profiles

When determining whether the current user’s SQL should be captured in the SQL Performance Monitor (aka Database Monitor) output, we determine whether the user is a member of the group.
Wildcard group profile names are allowed.
For example, if the customer specifies FTRUSER(ADMIN*) and both ADMINGRP and ADMINGRP2 are group profiles, any SQL executed by users in either group will be captured.
System i Navigator’s SQL Performance Monitor interface for “User” can be used to specify the group profile.

[{"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":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11169668