PI58413: MULTIPLE FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This PTF will include the fixes for QMF 11.1 APARs:
  PI54680, PI57078, PI57392 and PI58178.
  
  PI54680:
   CONVERT COMMAND ABEND S0C4 AT OFFSET X'382' IN MODULE
   DSQGPRTT
  
   PROBLEM DESCRIPTION:
   ABENDS0C4 in DSQGPRTT when user tries to DISPLAY or
   CONVERT a QMF Prompted Query query that references
   one or more temporal tables that do not exist.
  
  PI57078:
  
   DSQ20114 RUNNING QMF BATCH JOBS, UNEXPECTED 4 BYTES
   X'004F0000' AT BEGINNING OF EVERY LINE IN EXPORTED PROC
  
   ERROR DESCRIPTION:
   MESSAGE NUMBER: DSQ20114
   MESSAGE TEXT: ! is not a command.
    &C1:  !
  
   Exporting a QMF proc to a pre-allocated dataset
   with DCB RECFM=FBA, 4 bytes x'004F0000' are
   inserted in front of every line.
  
    Another exported PROC shows the following 5 bytes,
    x'40004F0000' at the beginning of every line.
  
    other keywords: DSQ20114 MSGDSQ20114
  
  PI57392:
   FIX BUG RECORDING QMF TRACE - DSQFQDRM
  
   prevent ASRA ABEND in QMF trace running in CICS region
  
  PI58178:
  
   SQLCODE -311 RECEIVED WHEN RUNNING PROC IN
   NON-ENGLISH ENVIRONMENT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.2 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes multiple problems.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR fixes four problems that were
  previously fixed in QMF 11.1.
  
  Problem 1 (APAR PI54680):
  Users DISPLAYing or CONVERTing prompted
  queries referencing multiple DB2
  temporal tables can experience an
  ABEND0C4 in DSQGPRTT. If a PQ query
  references multiple DB2 temporal
  tables, and the last table referenced
  exists but any one of the earlier
  referenced tables does not exist, QMF
  incorrectly builds a linked list of
  those tables. The pointer to the last
  table in the linked list is 00000000.
  This will result in an ABENDS0C4 during
  the processing of the query.
  
  Problem 2 (APAR PI57078):
  QMF objects exported to a pre-existing
  FBA data set contain records with
  prefix areas for variably blocked data.
  Records for objects exported to any
  type of pre-existing data set other
  than those with F or FB RECFMs were
  formatted as if they were being written
  to variably blocked data sets, with
  extra bytes of length information added
  to the start of every record.
  
  Problem 3 (APAR PI58178):
  A non-English installation of QMF can
  receive SQLCODE -311 if users run a
  PROC that calls a QUERY that performs
  an INSERT or other nonretrieval
  statement.  If the global variable
  DSQEC_NLFCMD_LANG is set to 1, the RUN
  command is stored as "RUN" in a QMF
  control block, rather than the national
  language translation for the RUN
  command. QMF code compared the value
  for RUN in the control block with the
  translated version of RUN. If they did
  not match, QMF took an unintended code
  path with uninitialized variabes that
  led to the SQLCODE -311.
  
  Problem 4 (APAR PI58437):
  A new global variable,
  DSQEC_TRACE_MODULE, has been
  introduced to allow users to indicate
  which module or modules (up to 6
  modules) should be traced. The usage of
  this new global variable is to be
  directed by QMF Support.
  

Problem conclusion

• QMF 11.2 has been updated to fix the problems described above.
  

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:

  UI36296

Modules/Macros

•    DSQCBST  DSQCDBG1 DSQCGVSI DSQCSETS DSQDQPIO
  DSQFQDRM DSQGPRIL DSQIESQL
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB20 PSY UI36296

     UP16/03/18 P F603

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.