PH71878: ADDED SUPPORT FOR ADVANCED FILTERS IN SQL FORMAT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR introduces support for SQL-format advanced object
  filters.
  A new value for the Object filters is now available on "Generate
  Database Activity Report (General)", "Generate Database Activity
  Report (Details)", "Process Archived Output" panels. When the
  Object filter is set to "S" (Advanced SQL Filter), the new
  "Advanced Filters (SQL)" panel will be shown for filter
  specification. On the "Advanced Filters (SQL)" the user can
  specify the "Where" statement and also open a new panel to
  define Include/Exclude columns for each object.
  
  
  
  The WHERE clause supports comparison operators (=, <>, <, <=,
  >=, >), IS NULL, LIKE, BETWEEN, IN, NOT, and the proprietary
  CHANGED / NOT CHANGED operators. Supported column types include
  SMALLINT, INTEGER, BIGINT, FLOAT, DECFLOAT, DECIMAL, CHAR,
  VARCHAR, GRAPHIC, VARGRAPHIC, BINARY, DATE, TIME, TIMESTAMP, and
  TIMESTZ. LOB, XML, and user-defined data types are not
  supported.
  The WHERE clause is parsed and evaluated internally by the Log
  Analysis Tool  it is not passed to Db2.
  
  
  
  Column-level filters are applied at the detail report level.
  At the general report level, only the table name filtering is
  applied, so general/summary reports may reflect a broader result
  set.
  
  
  
  The FILTERS DD will contain the following section when the
  SQL-filters are specified on the panel:
  //FILTERS  DD *
  
  
  GENERAL FILTERS...........
  
  
  SHOW UPDATES     =Y
  
  
  SHOW INSERTS     =Y
  
  
  SHOW DELETES     =Y
  
  
  SHOW ROLLBACKS   =N
  
  
  CATALOG DATA     =N
  
  
  SHOW STARTED UOWS=N
  
  
  SHOW UNCOMMITS   =N
  
  
  SHOW COMP RECS   =N
  
  
  DROPPED OBJECTS  =N
  
  
  OBJECT FILTERS-ADVANCED (SQL WHERE)...
  
  
  TABLE OWNER=TS6039
  
  
  TABLE NAME =TBPRD
  
  
  EXCLUDE COLUMNS:
  
  
  ROW_CODE
  
  
  WHERE:
  
  
  ROW_ID > 2 AND ROW_CITY IN ('DENVER','BOSTON');
  
  
  TABLE OWNER=TS6039
  
  
  TABLE NAME =TBDEMO
  
  
  EXCLUDE COLUMNS:
  
  
  WHERE:
  
  
  (ROW_ID > 1 and ROW_ID < 5) and (ROW_CITY = 'SAN FRANCISCO' OR
  ROW_CITY
  = 'LOS ANGELES');
  
  
  /*
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR introduces support for        *
  *                      SQL-format advanced object filters.     *
  *                                                              *
  *                      A new value for the Object filters is   *
  *                      now available on "Generate Database     *
  *                      Activity Report (General)", "Generate   *
  *                      Database Activity Report (Details)",    *
  *                      "Process Archived Output" panels. When  *
  *                      the Object filter is set to "S"         *
  *                      (Advanced SQL Filter), the new          *
  *                      "Advanced Filters (SQL)" panel will be  *
  *                      shown for filter specification. On the  *
  *                      "Advanced Filters (SQL)" the user can   *
  *                      specify the "Where" statement and also  *
  *                      open a new panel to define              *
  *                      Include/Exclude columns for each        *
  *                      object.                                 *
  *                                                              *
  *                      The WHERE clause supports comparison    *
  *                      operators (=, <>, <, <=, >=, >),        *
  *                      IS NULL, LIKE, BETWEEN, IN, NOT, and    *
  *                      the proprietary CHANGED / NOT CHANGED   *
  *                      operators. Supported column types       *
  *                      include SMALLINT, INTEGER, BIGINT,      *
  *                      FLOAT, DECFLOAT, DECIMAL, CHAR,         *
  *                      VARCHAR, GRAPHIC, VARGRAPHIC, BINARY,   *
  *                      DATE, TIME, TIMESTAMP, and TIMESTZ.     *
  *                      LOB, XML, and user-defined data types   *
  *                      are not supported.                      *
  *                                                              *
  *                      The WHERE clause is parsed and          *
  *                      evaluated internally by the Log         *
  *                      Analysis Tool - it is not passed to     *
  *                      Db2.                                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Added support for advanced filters in SQL format
  

Problem conclusion

• Apply the PTF
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO08681

Modules/Macros

• ALA#ERRM ALA#LCLF ALA#LDSN ALA#STOR ALA#WTO  ALA@FD28 ALA@FFN8
  ALA@FSP  ALAA37   ALAA82   ALAA84   ALAAA1   ALAAA11M ALAAA11S
  ALAAA16  ALAAA3   ALAADSLP ALAADSNP ALAAFWR  ALAAP2V  ALAAPICD
  ALAARC1  ALAARC2  ALAARCH  ALAARCPN ALAARDCU ALAARDDO ALAARDRT
  ALAARDUW ALAASQCM ALAAUDPN ALABSDR  ALABSQL  ALABSSQL ALACADMN
  ALACCFG  ALACCORD ALACDC   ALACFGRP ALACLDEL ALACLOAT ALACQT
  ALACTAU  ALACUOW6 ALACURR  ALAD1LP  ALADATA  ALADB2AC ALADB2S
  ALADB2SP ALADDM   ALADECP  ALADELER ALADIN   ALADLMPN ALADSA
  ALADSNM  ALADTL1  ALADTL2  ALADTL3  ALADTL4  ALADTL6  ALAERRIN
  ALAEXP   ALAFA    ALAFCFG  ALAFFV   ALAFLADV ALAFLOBI ALAFLOBN
  ALAFLSQL ALAFMAIN ALAFR1CX ALAFRC8  ALAFRCA  ALAFRCCM ALAFRCOL
  ALAFRCQS ALAFRDLP ALAFRDOB ALAFRDOS ALAFRDTL ALAFRETV ALAFRFLA
  ALAFRFLO ALAFRGNR ALAFRGUT ALAFRJSN ALAFRLAP ALAFRLCV ALAFRMFC
  ALAFRMSC ALAFRMTR ALAFRPGS ALAFRPIE ALAFRPMA ALAFRPMC ALAFRSL
  ALAFRSP  ALAFRTCV ALAFRTP1 ALAFRTSC ALAFRTVB ALAFRTVI ALAFRTVS
  ALAFRUT  ALAFRVLI ALAFRVLS ALAFTC   ALAGEN1  ALAGEND  ALAGFL2
  ALAGFLA  ALAGFLT  ALAGLOAD ALAGLSUM ALAGMT   ALAGNJCL ALAHDR
  ALAHDRPN ALAHRC   ALAHSM   ALAJSDEF ALAJSON  ALAJUUT  ALALAUD
  ALALB2   ALALB3   ALALCOPN ALALDCOM ALALDCR  ALALDDSN ALALDPN
  ALALDST  ALALEOPN ALALF1   ALALF1A  ALALF1B  ALALF2   ALALF3
  ALALF3W  ALALFCPN ALALIN   ALALOG   ALALOPT  ALALPD   ALAMAINT
  ALAMDTL  ALAMFLTR ALAMFOPN ALAMGR   ALAMLOB  ALAMLREP ALAMLSWR
  ALAMNTRP ALAMODEF ALAMODEM ALAMPNL  ALAMSGPN ALAOBD   ALAODPC
  ALAODPPN ALAPEXP  ALAPOPUP ALAQGLPN ALAQGRPN ALAQGSPN ALAQSPN
  ALAQSRT  ALAQTRP  ALARDPG2 ALARDR   ALAREC   ALAREC2  ALAREC3
  ALAREC3W ALARFRMT ALARM64  ALARRE   ALARROWD ALASETUP ALASETWN
  ALASFREX ALASQLCR ALASQLER ALASQLF  ALASRCTB ALATICS  ALATIME
  ALATRANS ALATSC   ALATV    ALATVRP  ALAUES   ALAUTIL  ALAUTL64
  ALAVBIO  ALAVLDEX ALAVLXPN ALAVRD   ALAVSTR  ALAWARN  ALAXUTIL
  ALAZH62A ALAZH95A ALAZT040 ALAZT231 ALAZTM00
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R360 PSY UO08681

     UP26/07/23 P F607  

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.