Db2 Tools for z/OS

 View Only

Db2 Administration Tool: Tips for filtering columns on panels by Kate Wheat

By CALENE JANACEK posted Fri October 23, 2020 09:24 AM

  

In Db2 Admin Tool, one easy way to filter the data on table display panels is to use the SARG command (or SEARCH command). You can use this command to do advanced filtering so that only the rows you want to see are displayed. For example, you can filter columns with blank values or filter columns by using the NE (not equal) comparison operator.

Consider the case of filtering columns with blank values. Suppose that you are viewing table authorizations on the Table Authorizations (ADB2AT) panel, and you want to view only those table authorizations where the grantee type is an authorization ID (not an application package or plan or a role). For these authorizations, the GT (Grantee type) column is blank.  

To filter the panel so that only the rows with blank values in the GT column are displayed, take the following steps:

  1. On the command line, specify the SARG command, and press Enter:


  2. On the Search Fields (ADB2SARG) panel, specify the following values for GRANTEETYPE and press Enter:
    • In the SrchOper column, specify LT
    • In the Search Value column, specify . (a period)


  3. Press END (F3) to return to the previous panel.
    The rows are filtered to show only rows where GRANTEETYPE is blank:

On the Search Fields (ADB2SARG) panel, you can also specify other advanced filtering criteria, such as a Not Equal (NE) comparison. For example, if you wanted to see authorizations that were not public, you can specify the following values for GRANTEE:

  • In the SrchOper column, specify NE
  • In the Search Value column, specify PUBLIC

 

For more details on the SARG command the operators that you can use with this command, see Db2 Admin Tool Primary Commands.

 #db2tools, #db2admin

​​
#Db2Toolsforz/OS
0 comments
11 views

Permalink