PH67990: INACCESSIBLE DATASET OUTPUT BY DB2 HPU WHEN USING ZIIP PROCESSORS WITH BSAM ON CERTAIN RECORD FORMATS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An attempt to access the dataset containing the data unloaded by
  a successful run of a Db2 HPU step fails reporting an "I/O
  error" or an "Invalid block size" issue.
  
  This occurs if all of the following conditions are fulfilled:
  - the BSAM access method is used for the output datasets (as
    indicated by the INZU666I message output by Db2 HPU)
  - the use of zIIP processors is enabled (as indicated by the
    INZI210I message output by HPU)
  - the VUM029/DFSIGDCB parameter in the PARMLIB is set to NO
  - the dataset containing the unloaded data is handled through a
    ddname (specified by the OUTDDN or UNLDDN option) that
    allocates a dataset with one of the following record formats
    (RECFM):
     - FBM
     - FBA
     - DBS
     - DBA
     - FBSA
     - FBSM
     - FBTA
     - FBTM
  

Local fix

• This issue can be resolved using one of the three following
  methods:
  - Specify SEQ_IO_METHOD INPUT(BSAM), OUTPUT(QSAM) in the GLOBAL
    options block
  - Disable zIIP processing by specifying the ZIIP OFF option
  - Allocate the dataset without specifying the RECFM attribute or
    specifying any suitable one that does not trigger the issue
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: An attempt to access the dataset        *
  *                      containing the data unloaded by a       *
  *                      successful run of a Db2 HPU step fails  *
  *                      reporting an "I/O error" or an "Invalid *
  *                      block size" issue.                      *
  *                                                              *
  *                      This occurs if all of the following     *
  *                      conditions are fulfilled:               *
  *                      - the BSAM access method is used for    *
  *                        the output datasets (as indicated by  *
  *                        the INZU666I message output by Db2    *
  *                        HPU)                                  *
  *                      - the use of zIIP processors is enabled *
  *                        (as indicated by the INZI210I message *
  *                         output by HPU)                       *
  *                      - the VUM029/DFSIGDCB parameter in the  *
  *                        PARMLIB is set to NO                  *
  *                      - the dataset containing the unloaded   *
  *                        data is handled through a ddname      *
  *                        (specified by the OUTDDN or UNLDDN    *
  *                        option) that allocates a dataset with *
  *                        one of the following record formats   *
  *                        (RECFM):                              *
  *                         - FBM                                *
  *                         - FBA                                *
  *                         - DBS                                *
  *                         - DBA                                *
  *                         - FBSA                               *
  *                         - FBSM                               *
  *                         - FBTA                               *
  *                         - FBTM                               *
  *                                                              *
  *                      - Local fix : This issue can be         *
  *                        resolved using one of the three       *
  *                        following methods:                    *
  *                         - Specify SEQ_IO_METHOD INPUT(BSAM), *
  *                           OUTPUT(QSAM) in the GLOBAL options *
  *                           block                              *
  *                         - Disable zIIP processing by         *
  *                           specifying the ZIIP OFF option     *
  *                         - Allocate the dataset without       *
  *                           specifying the RECFM attribute or  *
  *                           specifying any suitable one that   *
  *                           does not trigger the issue         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Inaccessible dataset output by Db2 HPU when using zIIP
  processors with BSAM on certain record formats
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UO05248

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO05248

     UP25/10/18 P F510

• R610 PSY UO05249

     UP25/10/18 P F510

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.