PI89240: RUN QUERY SUPPORT OF DB2 CROSS-LOADER FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add ability for loading tables through the DB2 cross-loader when
  executing the RUN QUERY with TABLE keyword command.
  
  Note to QMF 12.1 NLF users:
  
  This APAR adds new messages to the QMF 12.1 English product.
  Each NLF must apply an additional PTF to add the new messages.
  
  If you do not see your NLF on this list, please contact QMF
  Level 2 to request an APAR for your language.
  
  French – PI90426
  German - PI90427
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V12.1 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds new function to QMF for  *
  *                      TSO and CICS 12.1. After applying this  *
  *                      PTF, QMF can now optionally use the DB2 *
  *                      for z/OS cross-loader when saving data  *
  *                      through the TABLE keyword on the RUN    *
  *                      QUERY command. Note that the DB2 for    *
  *                      z/OS cross-loader is an extra cost      *
  *                      feature available in the DB2 for z/OS   *
  *                      Utilities Suite. The cross-loader must  *
  *                      be installed and configured in order    *
  *                      for the QMF function to be enabled.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Using the new function can reduce storage requirements.
  for QMF batch or interactive sessions when using RUN QUERY with
  the TABLE keyword. Users may also see improved performance when
  using the DB2 cross-loader to load data to their tables created
  through QMF procedures and commands.
  

Problem conclusion

Temporary fix

Comments

• After meeting the prerequesites of installing and configuring
  the DB2 for z/OS cross-loader from the DB2 for z/OS Utilities
  Suite, including the DB2 stored procedure SYSPROC.DSNUTILU,
  QMF must be enabled for the new function.
  
  Three new global variables, DSQEC_SAV_LOADER,
  DSQEC_SAV_LOGCTL and DSQEC_SAV_LOGTABLE are provided for
  this purpose.
  
  DSQEC_SAV_LOADER (length of 1):
  
  Allows the DB2 LOAD utility (Cross Loader feature) to be
  used when using the RUN QUERY with TABLE keyword.
  
  0 = Run Query with TABLE keyword will not use the DB2 LOAD
  utility (Cross Loader feature) to save the data. (Default)
  
  1 = Run Query with TABLE keyword will use the DB2 LOAD
  utility (Cross Loader feature) to save the data.
  
  DSQEC_SAV_LOGCTL (length of 2):
  
  The DB2 Load Utility Cross Loader feature returns errors
  in a result set. DSQEC_SAV_LOGCTL controls the amount of
  output returned from the Cross Loader that is saved by QMF.
  
  -1 - QMF will not save any results.
  
  0 - QMF will save all results.
  
  1-16 - QMF will save results with a return code greater
  than what you entered or higher or higher.
  
  Example 1: You set DSQEC_SAV_LOGCTL to 4, the LOADER
  returns a RC of 8. The result set will be saved.
  
  Example 2: You set DSQEC_SAV_LOGCTL to 8, the LOADER
  
  returns a RC of 4. The result set will not be saved.
  
  DSQEC_SAV_LOGTABLE
  
  The name of the table to which QMF saves result sets
  returned from the Cross Loader.
  
  Q.ERROR_LOG is the default name and should be created
  when QMF is installed. This is the QMF message error log.
  
  The name can be a one or two part name in the form of:
  USERID.TABLENAME
  
  If left blank the result set will not be saved.
  
  If the user enters a name other than Q.ERROR_LOG the
  table must exist. QMF will not create the table. No save
  will be done. An entry will be made in the QMF trace
  indicating the result set was not saved. It is also
  recommended that the error log be in a different table
  space than the one the data is being saved it otherwise
  QMF may not be able to have the result set if the utility
  is terminated.
  
  Example:
  
  SET GLOBAL (DSQEC_SAV_LOADER = 1                             )
  RUN QUERY MYQUERY (TABLE=MYTABLE                             )
  
  The above example would create a TABLE called MYTABLE
  from the results of running query MYQUERY. The contents
  of MYTABLE are loaded by the DB2 for z/OS cross-loader
  using the DB2 stored procedure SYSPROC.DSNUTILU. If the
  table does not exist, it will be created in the database
  and table space defined in the users Q.PROFILES.SPACE
  parameter. The Q.PROFILES.SPACE value may be overridden
  by using the SPACE keyword on the RUN QUERY command.
  
  The QMF 12 publications have been updated with this
  information as well as much more detail.
  

APAR Information

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

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

  UI51745

Modules/Macros

•    DSQCDBUG DSQCELTT DSQCGVSI DSQCRSNC DSQCSETS
  DSQDCALL DSQDCPAR DSQDGVVI DSQDRUN  DSQDRUNS DSQDSET  DSQDSHOS
  DSQIISQ2 DSQIIUEL DSQPNLE  HSQCC10J
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC10 PSY UI51745

     UP17/11/11 P F711

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.