PM52858: UNLOAD ENDS SUCCESSFULLY (COMPLETION CODE LESS THAN 8 AND OUTPUT DATA IS CORRECT) BUT LSCX110 NOTE AND LSCX500 WARNING ISSUED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload end successfully (completion code less than 8 and
  output data is correct) but issues messages such as:
  
  LSCX110 **** NOTE ****
          Generated in   MEMCPY called from line   7882 of
         @@258036(OQRYV8) , offset 001BA8
            Extended name: oqryv8ReadSystables
          Arguments to memcpy overlap (length = 4294944907).
           Results are unpredictable.
  LSCX500 **** WARNING **** ERRNO = ENFOUND
          Generated in   MEMCPY called from line   7882 of
           @@258036(OQRYV8) , offset 001BA8
            Extended name: oqryv8ReadSystables
          File not opened, ddname SYSTERM  not defined.
  Interrupted while: Opening file "//ddn:*" (stderr)
                     Printing runtime message 110
  
  It can occur when the DB2 subsystem is in V1010 CM mode and the
  SYSDABASE table space has not been converted to new V10 table
  spaces.
  
  PB11332
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU 4.1 only: An unload ends with       *
  *                      ABENDS0C4 or end successfully           *
  *                      (compeletion code less than 8 and       *
  *                      output data is correct) but issues      *
  *                      messages such as:                       *
  *                      LSCX110 **** NOTE ****                  *
  *                             Generated in   MEMCPY called     *
  *                       from line   7882 of                    *
  *                            @@258036(OQRYV8) , offset 001BA8  *
  *                               Extended name:                 *
  *                       oqryv8ReadSystables                    *
  *                             Arguments to memcpy overlap      *
  *                       (length = 4294944907).                 *
  *                              Results are unpredictable.      *
  *                      LSCX500 **** WARNING **** ERRNO =       *
  *                       ENFOUND                                *
  *                             Generated in   MEMCPY called     *
  *                       from line   7882 of                    *
  *                              @@258036(OQRYV8) , offset       *
  *                       001BA8                                 *
  *                               Extended name:                 *
  *                       oqryv8ReadSystables                    *
  *                             File not opened, ddname SYSTERM  *
  *                        not defined.                          *
  *                      Interrupted while: Opening file         *
  *                      "//ddn:*" (stderr)                      *
  *                      Printing runtime message 110            *
  *                      It can occur when the DB2 subsystem is  *
  *                      in V1010 CM mode and the SYSDABASE      *
  *                      table space has not been converted to   *
  *                      new V10 table spaces.                   *
  *                      PB11332                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  odb2x2  and inzqryv8  and inzqryv9 were changed to take the new
  catalog column into account from DB2 V1010 CM level.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZQRYV8
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK77137

     UP12/03/22 P F203

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.