PH15724: QMFT-14341 NLF APAR

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR will update QMF for TSO and CICS NLF installation jobs
  to create universal table spaces (UTS) for NLF sample tables.
  Jobs updated are DSQ1nIVS and DSQ1nIVQ. Also updated will be the
  sample QMF SYSTEM profile row, which will be updated to
  encourage the use of universal table spaces for SAVE DATA. The
  default Q.PROFILES.SPACE row will be changed from
  'DSQDBDEF.DSQTSDEF'  to 'DATABASE "DSQDBDEF"'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V12.1 NLF users.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users installing a QMF for TSO and CICS *
  *                      NLF into a Db2 for z/OS V12.1 server    *
  *                      running at FL504 or higher that         *
  *                      contains no previous level of QMF may   *
  *                      receive the following errors:           *
  *                                                              *
  *                      When running job DSQ1nCCS to install    *
  *                      QMF NLF command synonym table, users    *
  *                      will get an SQL code -646 (SQLCODE646). *
  *                      The job attempts to put the NLF command *
  *                      synonym table, Q.COMMAND_SYNONYM_n in   *
  *                      the base English command synonym table  *
  *                      space DSQDBCTL.DSQTSSYN. The job will   *
  *                      fail with a RC8. When running job       *
  *                      DSQ1nIVS to install QMF sample tables,  *
  *                      users will get an SQL code -646         *
  *                      (SQLCODE646) when creating the NLF      *
  *                      equivolent of Q.STAFF. The job will     *
  *                      fail with a RC8. When running the QMF   *
  *                      IVP procedure DSQ1nIVP, users will      *
  *                      receive DSQ16646 'Table space DSQTSDEF  *
  *                      already contains a table.'. This will   *
  *                      happen when executing the SAVE DATA.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR enhances QMF NLF installation into a Db2 for z/OS
  server that contains no prior release of QMF to conform
  to universal table space (UTS) requirements of one table per
  table space. Users installing into a Db2 for z/OS V12.1
  FL504 or higher server, or even those just wishing to
  start migration of their QMF usage to UTS, should install
  this PTF.
  
  The following changes have been made:
  -Installation job DSQ1nUPO, will create sample NLF Q.PROFILES
  rows with a SPACE setting of 'DATABASE "DSQDBDEF"'. This
  is a change from the long standing default of
  DSQDBDEF.DSQTSDEF. When executing the SAVE DATA command
  using the new default SPACE setting (DATABASE "DSQDBDEF")
  will allow Db2 to create implicit table spaces in the
  DSQDBDEF database. Users are free to modify this as needed.
  -Installation jobs DSQ1nCCS which creates the NLF
  command synonym table, is updated to create an explicit
  NLF table space for the NLF command synonym table.
  -Installation jobs DSQ1nIVS and DSQ1nIVQ, which create NLF
  sample tables, are updated to create explicit table spaces
  for each sample table.
  -Installation job DSQ1nDSJ is updated to drop all sample
  table table spaces rather than the tables themselves.
  
  Note that if QMF was already installed into a Db2 for z/OS
  V12.1 FL504 or higher server and users are receiving DSQ16646
  (SQL code -646 SQLCODE646) errors during SAVE DATA, you
  should review your users Q.PROFILES.SPACE setting to allow
  implicit table space usage. See the following technote
  for more information:
  
  https://www-01.ibm.com/support/docview.wss?uid=ibm10870260
  

Problem conclusion

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:

  UI65407 UI65408 UI65409 UI65412 UI65413 UI65410 UI65411 UI65415
  UI65414 UI65416 UI65417 UI65418 UI65419

Modules/Macros

•    DSQ1CCCS DSQ1CDSG DSQ1CIPO DSQ1CIVQ DSQ1CIVS
  DSQ1CSTD DSQ1CSTQ DSQ1CSTS DSQ1CSTT DSQ1CSYC DSQ1CSYS DSQ1DCCS
  DSQ1DDSG DSQ1DIPO DSQ1DIVQ DSQ1DIVS DSQ1DSTD DSQ1DSTQ DSQ1DSTS
  DSQ1DSTT DSQ1DSYC DSQ1DSYS DSQ1FCCS DSQ1FDSG DSQ1FIPO DSQ1FIVQ
  DSQ1FIVS DSQ1FSTD DSQ1FSTQ DSQ1FSTS DSQ1FSTT DSQ1FSYC DSQ1FSYS
  DSQ1HCCS DSQ1HDSG DSQ1HIPO DSQ1HIVQ DSQ1HIVS DSQ1HSTD DSQ1HSTQ
  DSQ1HSTS DSQ1HSTT DSQ1HSYC DSQ1HSYS DSQ1ICCS DSQ1IDSG DSQ1IIPO
  DSQ1IIVQ DSQ1IIVS DSQ1ISTD DSQ1ISTQ DSQ1ISTS DSQ1ISTT DSQ1ISYC
  DSQ1ISYS DSQ1KCCS DSQ1KDSG DSQ1KIPO DSQ1KIVQ DSQ1KIVS DSQ1KSTD
  DSQ1KSTQ DSQ1KSTS DSQ1KSTT DSQ1KSYC DSQ1KSYS DSQ1PCCS DSQ1PDSG
  DSQ1PIPO DSQ1PIVQ DSQ1PIVS DSQ1PSTD DSQ1PSTQ DSQ1PSTS DSQ1PSTT
  DSQ1PSYC DSQ1PSYS DSQ1QCCS DSQ1QDSG DSQ1QIPO DSQ1QIVQ DSQ1QIVS
  DSQ1QSTD DSQ1QSTQ DSQ1QSTS DSQ1QSTT DSQ1QSYC DSQ1QSYS DSQ1SCCS
  DSQ1SDSG DSQ1SIPO DSQ1SIVQ DSQ1SIVS DSQ1SSTD DSQ1SSTQ DSQ1SSTS
  DSQ1SSTT DSQ1SSYC DSQ1SSYS DSQ1UCCS DSQ1UDSG DSQ1UIPO DSQ1UIVQ
  DSQ1UIVS DSQ1USTD DSQ1USTQ DSQ1USTS DSQ1USTT DSQ1USYC DSQ1USYS
  DSQ1VCCS DSQ1VDSG DSQ1VIPO DSQ1VIVQ DSQ1VIVS DSQ1VSTD DSQ1VSTQ
  DSQ1VSTS DSQ1VSTT DSQ1VSYC DSQ1VSYS DSQ1YCCS DSQ1YDSG DSQ1YIPO
  DSQ1YIVQ DSQ1YIVS DSQ1YSTD DSQ1YSTQ DSQ1YSTS DSQ1YSTT DSQ1YSYC
  DSQ1YSYS DSQ1ZCCS DSQ1ZDSG DSQ1ZIPO DSQ1ZIVQ DSQ1ZIVS DSQ1ZSTD
  DSQ1ZSTQ DSQ1ZSTS DSQ1ZSTT DSQ1ZSYC DSQ1ZSYS
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC5A PSY UI65407

     UP19/09/24 P F909

• RC5B PSY UI65408

     UP19/09/24 P F909

• RC5C PSY UI65409

     UP19/09/24 P F909

• RC5D PSY UI65410

     UP19/09/24 P F909

• RC5E PSY UI65411

     UP19/09/24 P F909

• RC5F PSY UI65412

     UP19/09/24 P F909

• RC5G PSY UI65413

     UP19/09/24 P F909

• RC51 PSY UI65414

     UP19/09/24 P F909

• RC55 PSY UI65415

     UP19/09/24 P F909

• RC56 PSY UI65416

     UP19/09/24 P F909

• RC57 PSY UI65417

     UP19/09/24 P F909

• RC58 PSY UI65418

     UP19/09/24 P F909

• RC59 PSY UI65419

     UP19/09/24 P F909

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.