How to check DB2 SYSADM or SYSCTRL authorization for a user with AUTH_LIST_AUTHORITIES_FOR_AUTHID

Question: How can I determine if a user has SYSADM or SYSCTRL authorization? I've read the DB2 - A Security Primer , but couldn't locate any commands Answer: Use the AUTH_LIST_AUTHORITIES_FOR_AUTHID table function. The function has replaced the get authorizations command. The function returns authorities granted to an ID directly or indirectly Syntax example using AUTH_LIST_AUTHORITIES_FOR_AUTHID Return authorities granted to user JACK , either explicitly or via a role or group SELECT AUTHORITY, D_USER, D_GROUP, D_PUBLIC, ROLE_USER, ROLE_GROUP, ROLE_PUBLIC, D_ROLE FROM TABLE (SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID ('JACK', 'U') ) AS T ORDER BY AUTHORITY Read More on DB2 security DB2 – Audit Failed... Read more →

How To get the column definitions of the DB2 Monitor table functions

Question: How can I get the column definitions of the DB2 Monitor (MON) table function? Answer: You can describe the Monitor function tables output by prefixing describe output before the SELECT statement . It will return the column definition. For example, --return column details of MON_GET_BUFFERPOOL db2 "describe output SELECT * FROM TABLE(MON_GET_BUFFERPOOL('',-2))" ---return column details of waits and processing times for a connection db2 “describe output select r.metric_name, r.parent_metric_name, r.total_time_value as time, r.count, c.member from table(mon_get_connection_details(125,-2)) as c, table(mon_format_xml_times_by_row(c.details)) as r order by total_time_value desc Read More Reorg table DB2 DB2 table reorg and table truncate DB2 Used Space... Read more →