PH45061: UNEXPECTED DSQ14118 WHEN USING MAX PF8 ON REPORT WITH LOB DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running a query against a table with LOB data.
  DSQEC_LOB_COLMAX is set to the default 32767 and DSQEC_LOB_RETRV
   is set to the default of 1. When the user runs the query, sees
  the first page of the report types in MAX on the command line
  and presses PF8, he unexpectedly gets DSQ14118 'LOB column
  length exceeds the maximum set by DSQEC_LOB_COLMAX'.  The error
  condition is unexpected at this point. The user is using a
  default form with the M (meta data) edit code.  If the user
  simply presses PF8 (Forward) he is able to successfully scroll
  through the report. Specifically MAX PF8 causes the unexpected
  problem.
  

Local fix

• DSQEC_LOB_COLMAX can be set to 0 when running with
  DSQEC_LOB_RETRV=1 and using MAX PF8.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: USERS AFFECTED: All QMF for TSO/CICS V12.1   *
  *                 users using LOB data.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: User was running a SQL query against a  *
  *                      table containing LOB data.              *
  *                      User had the defaults set with global   *
  *                      variable DSQEC_LOB_RETRV                *
  *                      set to 1. DSQEC_LOB_RETRV set to a      *
  *                      value of 1 means that LOB               *
  *                      locators are used and the actual LOB    *
  *                      data is not fetched.                    *
  *                      The user was using the default          *
  *                      QMF formwhich sets the edit             *
  *                      code of the LOB columns to 'M' for      *
  *                      meta data. When running                 *
  *                      the query and typing in the MAX PF8     *
  *                      (or BOTTOM) command, the                *
  *                      user unexpectedly received DSQ14118     *
  *                      'LOB column length exceeds              *
  *                      the maximum set by DSQEC_LOB_COLMAX.'   *
  *                      When the user ran the                   *
  *                      query and pressed PF8 (Forward)         *
  *                      multiple times, the user                *
  *                      was able to successfully go to the      *
  *                      bottom of the report.                   *
  *                                                              *
  *                      When using the 'M' edit code on LOB     *
  *                      data columns,                           *
  *                      QMF should not be fetching the LOB      *
  *                      dat also DSQEC_LOB_COLMAX               *
  *                      settings should not be referenced.      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

• QMF module DSQFQDRM was incorrectly trying to display LOB
  data when running the BOTTOM and PF8 (FORWARD MAX) commands.
  This was happening with DSQEC_LOB_RETRV set to 1 and the
  LOB edit code set to 'M'. The module has been fixed.
  

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:

  UI80152

Modules/Macros

• DSQFQDRM
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC10 PSY UI80152

     UP22/04/20 P F204

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.