PH57218: ABENDS0C4 WHEN UNLOADING UNSUPPORTED VIEW USING DB2 UNLOAD UTILITY COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABENDS0c4 occurs with the following The LE trace back is:
  _inctrliCheckCcsidEcs
               +0000039A  464
   inzctrliEcs +00000082  1694
   _inzctrlhFormatSelect
               +00001E5E  12267
   _inzctrlhSelect
               +00001256  2446
   inzctrlhHPU +00001CCA  1717
  inzcontrolControl
               +00000124  299
   _inzmainThreadForRun
               +000002C4  732
  This occurs when all the following conditions are fulfilled :
  - the unload uses the Db2 UNLOAD utility syntax, thus runs the
  INZUTILC load module
  - the unload is a logical unload involving an unsupported view
  

Local fix

• none but consider using a Db2 HPU native syntax unload instead.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABENDS0c4 occurs with the            *
  *                      following The LE trace back is:         *
  *                       _inctrliCheckCcsidEcs                  *
  *                                   +0000039A  464             *
  *                       inzctrliEcs +00000082  1694            *
  *                       _inzctrlhFormatSelect                  *
  *                                   +00001E5E  12267           *
  *                       _inzctrlhSelect                        *
  *                                   +00001256  2446            *
  *                       inzctrlhHPU +00001CCA  1717            *
  *                       inzcontrolControl                      *
  *                                   +00000124  299             *
  *                       _inzmainThreadForRun                   *
  *                                   +000002C4  732             *
  *                                                              *
  *                      This occurs when all the following      *
  *                      conditions are fulfilled :              *
  *                      - the unload uses the Db2 UNLOAD        *
  *                        utility syntax, thus runs the         *
  *                        INZUTILC load module                  *
  *                      - the unload is a logical unload        *
  *                        involving an unsupported view         *
  *                                                              *
  *                      Local fix: none but consider using a    *
  *                      Db2 HPU native syntax unload instead.   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ABENDS0c4 when unloading unsupported view using Db2 UNLOAD
  utility command
  

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:

Modules/Macros

• INZ$$CCQ INZ$$PRM INZMQRY  INZPARM  INZTDSC  INZTOOLS INZTVAR
  INZUTIB1 INZUTIB2 INZUTILC INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI94047

     UP23/11/07 P F311

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.