PH67431: ABENDS0C1 IN NATIVE MODE WITH MULTIPLE UNLOAD TABLESPACE STATEMENTS IN A SINGLE STEP AND LOCAL DATE/TIME FORMAT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When specifying multiple UNLOAD TABLESPACE statements in a
  single step with a DB2 subsystem configured with a LOCAL
  DATE/TIME format, selecting DATE/TIME columns of the same type
  in separate statements leads to the process terminating with an
  S0C1 ABEND.
  
  This occurs if all the following conditions are fulfilled:
  
  - The DB2 subsystem in use is configured with a LOCAL DATE
  and/or TIME format
  
  - More than one UNLOAD TABLESPACE involves a logical unload that
  includes a SELECT containing a locally formatted DATE and/or
  TIME column of the same type
  
  
  - The logical unloads involved are being processed in native
  mode
  

Local fix

• Consider performing the unloads involved in a single UNLOAD
  TABLESPACE command
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When specifying multiple UNLOAD         *
  *                      TABLESPACE statements in a single step  *
  *                      with a DB2 subsystem configured with a  *
  *                      LOCAL DATE/TIME format, selecting       *
  *                      DATE/TIME columns of the same type in   *
  *                      separate statements leads to the        *
  *                      process terminating with an S0C1 ABEND. *
  *                                                              *
  *                      This occurs if all the following        *
  *                      conditions are fulfilled:               *
  *                                                              *
  *                        -  The DB2 subsystem in use is        *
  *                        configured with a LOCAL DATE and/or   *
  *                        TIME format                           *
  *                                                              *
  *                       -  More than one UNLOAD TABLESPACE     *
  *                       involves a logical unload that         *
  *                       includes a SELECT containing a         *
  *                       locally formatted DATE and/or TIME     *
  *                       column of the same type                *
  *                                                              *
  *                        -  The logical unloads involved are   *
  *                        being processed in native mode        *
  *                                                              *
  *                                                              *
  *                                                              *
  *                      Local fix: Consider performing the      *
  *                      unloads involved in a single UNLOAD     *
  *                      TABLESPACE command                      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ABENDS0C1 in native mode with multiple UNLOAD TABLESPACE
  statements in a single step and LOCAL DATE/TIME format
  

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:

  UO04514

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO04514

     UP25/08/23 P F508

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.