PH17912: ADD PARAMETERS TO FILTER THE SELECTED DATA TO A SPECIFIC DB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Add parameters to filter the selected data to a specific DB2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 Query Monitor for z/OS 3.3.0         *
  *                 users of component                           *
  *                 - CQM Data Offload and Batch Reporting       *
  *                 - TCz                                        *
  *                 - Documentation - Public use                 *
  *                 - CQM Data Collector                         *
  *                 - Help and Messaging                         *
  *                 - SQL Text                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Introduce a new parameter in OFFLOAD *
  *                      that permits filtering to a specific    *
  *                      Db2 subsystem.                          *
  *                                                              *
  *                      2. Long SQL texts are truncated or can  *
  *                      cause abends while viewing in           *
  *                      exceptions and operational summaries.   *
  *                                                              *
  *                      3. Invalid record address in interval   *
  *                      datasets.                               *
  *                                                              *
  *                      4. Data loss or message CQM2604E if     *
  *                      OFFLOAD started during splitting        *
  *                      interval.                               *
  *                                                              *
  *                      5. Default PRIQTY and SECQTY should be  *
  *                      changed to -1 to allow Db2 to set the   *
  *                      suitable values when creating new       *
  *                      OFFLOAD tablespaces.                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  1. A new parameter is introduced in OFFLOAD to enable the
  selection of data.
  2. SQL texts longer than 2MB are truncated or produce abends
  while viewing in exceptions and operational summaries panels
  due to writing records in datasets in incorrect order.
  3. Records longer than 2MB are written in parts in datasets but
  addresses of the parts were set incorrectly.
  4. If OFFLOAD was started during interval switch, there can be
  data loss or message CQM2604E LOGIC ERROR VSAM VSAMRC = x'08
  'VSAMRS = x'0400', because interval statistics is accumulated,
  calculated and recorded in file only at the moment of finishing
  interval switch.
  Also attempts to OFFLOAD current (active) interval caused only
  partial offloading of data due to the same reason as interval
  switch problem.
  5. Default PRIQTY and SECQTY were changed to -1 to allow Db2
  to set the suitable values for OFFLOAD new tablespace creation.
  

Problem conclusion

• 1. New FILTER_DB2_SUBSYSTEM parameter has been added to OFFLOAD
  process. See documentation about its usage.
  
  2. Algorithm for saving data into interval files was changed to
  calculate record length correctly.
  
  3. Algorithm for controlling sequence of record segments while
  writing data to interval files was fixed.
  
  4. OFFLOAD logic has been changed to wait until interval switch
  is finished. Customer is informed about such wait via new
  message:
  CQM1047I WAITING FOR THE COMPLETION OF THE PROCESS OF
  INTERVALS SWITCHING FOR THE CQM SUBSYSTEM xxxx
  
  An attempt to offload the active interval will fail now, OFFLOAD
  terminates with RC = 4, interval files are not offloaded, and a
  new error message is displayed:
  CQM1048E CURRENT INTERVAL FILES ARE INCOMPLETE AND CANNOT BE
  OFFLOADED
  
  5. Default PRIQTY and SECQTY are set to -1 to allow Db2 to set
  suitable values.
  
  
  
  
  Search Keywords:
  (PH17912)
  OFFLOAD CQM2604E ABEND 0C4 INTERVAL SWITCH FILTER_DB2_SUBSYSTEM
  CQM8026E CQM1048E CQM1047I CQM2627E CQM2628E
  PRIQTY SECQTY
  

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:

  UI71402

Modules/Macros

• CQM#IVSM CQM#PARM CQM#SWTX CQM$$PRM CQM@LDB2 CQM@LIDA CQM@WDB2
  CQMDDL   CQMDDLST CQMMEXCX CQMTTXTX CQMXDLST
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI71402

     UP20/09/09 P F009

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.