PI13474: ABENDS0C1 IN LOGICAL UNLOAD WITH COALESCE SCALAR FUNCTION AND USER FORMAT IS REQUESTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload fails with ABENDS0C1 when both following conditions
  are satifsaied:
  - the logical unload (SELECT) involves the COALESCE scalar
  function
  - the USER format is requested
  
  PB12245
  

Local fix

• consider replacing the FORMAT USER specification with an
  equivalent INTO or REFORMAT clause.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload fails with ABENDS0C1 after    *
  *                      having issue the following messages:    *
  *                      LSCX041 **** ERROR ****                 *
  *                        ABEND occurred in line 11735 of       *
  *                       @@283544(INODEH) ,offset 000470        *
  *                        Extended name: inznodehCallAsm        *
  *                          Program terminated by operating     *
  *                       system. ABEND code = S0C1              *
  *                           A non-C or system routine was      *
  *                       running at the time of ABEND           *
  *                      Calling trace:                          *
  *                          Function        Line    Offset      *
  *                          Context                             *
  *                      @@283544(INODEH)  == "inznodehCallAsm"  *
  *                                         11735    000470      *
  *                      @@283524(INODEH)  ==                    *
  *                       "_inznodeEvalOprCst"                   *
  *                                         11547    00010A      *
  *                      @@283524(INODEH)  ==                    *
  *                      "_inznodeEvalOprCst"                    *
  *                                         11581    0001E4      *
  *                      @@282493(INODEH)  == "inznodehOptimize" *
  *                                          7548    000172      *
  *                      @@281814(INODEH)  ==                    *
  *                       "inznodehCheckExpression"              *
  *                                           344    0000C4      *
  *                      @@133269(INODE)   ==                    *
  *                       "inznodeCheckExpression"               *
  *                                          2051    000098      *
  *                      @@658765(ICTRLH)  ==                    *
  *                       "_inzctrlhCheckTypes"                  *
  *                                         19148    000C72      *
  *                      @@657242(ICTRLH)  ==                    *
  *                      "_inzctrlhCheckEcsCommonPost"           *
  *                                          8546    0002F4      *
  *                      @@657307(ICTRLH)  ==                    *
  *                      "_inzctrlhFormatSelect"                 *
  *                                         10181    00197C      *
  *                      @@656442(ICTRLH)  == "_inzctrlhSelect"  *
  *                                          2090    0018BA      *
  *                      @@656429(ICTRLH)  == "inzctrlhHPU"      *
  *                                          1400    001D04      *
  *                      @@401641(ICTRL)   ==                    *
  *                       "inzcontrolControl"                    *
  *                                           265    000174      *
  *                          MAIN(IMAIN)      988    00164E      *
  *                      This occurs when both following         *
  *                       conditions are satisfaied:             *
  *                      - the logical unload (SELECT) involves  *
  *                       the COALESCE scalar function           *
  *                      - the USER format is requested          *
  *                      pb 12245                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  the inznodeh  module was changed.
  

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:

  UI17674

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UI17674

     UP14/05/09 P F405

• R420 PSY UI17675

     UP14/05/09 P F405

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.