PH03148: IEC143I 213-30 IF TWO SELECT STATEMENTS SHARE THE SAME OUTPUT PDS... INCLUDED IN PTF UI58908

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PB53894
  PB53950
  PB54032
  IEC143I 213-30 if two select statements share the same output
  PDS
  
  An allocation error occurs for one of the output data sets of a
  multiple SELECT unload command.
  The following error messages are issued:
  IEC143I 213-30,IFG0194D,HPUZ475R,REPRO,UL02,0AC7,INF006,  294
  LABO.HPUZ0475.OUTDATA(UL02)
  
  
  This occurs if at least two SELECT statements fullfil the
  following conditions:
  - their output data sets (défined through OUTDDN) are members of
  the same PDS data set.
  - the tables belong to the same tablespace or the parallelism is
  activated either for lds read in native mode, eitherfor SQL
  unload in SQL mode
  

Local fix

• Separate the SELECT statements that share the same output PDS
  into separate UNLOAD commands
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An allocation error occurs for one of   *
  *                      the output data sets of a multiple      *
  *                      SELECT unload command.                  *
  *                      The following error messages are        *
  *                      issued:                                 *
  *                      IEC143I 213-30,IFG0194D,HPUZ475R,REPRO  *
  *                      ,UL02,0AC7,INF006,  294                 *
  *                      LABO.HPUZ0475.OUTDATA(UL02)             *
  *                      ...                                     *
  *                      SYSTEM COMPLETION CODE=213  REASON      *
  *                       CODE=00000030                          *
  *                       TIME=14.18.54  SEQ=52030  CPU=0000     *
  *                        ASID=0065                             *
  *                       PSW AT TIME OF ERROR  075C1000         *
  *                         80DDF36E  ILC 2  INTC 0D             *
  *                         NO ACTIVE MODULE FOUND               *
  *                         NAME=UNKNOWN                         *
  *                         DATA AT PSW  00DDF368 - 4100302C     *
  *                        0A0D010D  A7E5014B                    *
  *                         AR/GR 0: 008C1CF0/00000000_00DDF678  *
  *                         1: 00000000/00000000_A4213000        *
  *                         2: 00000000/00000048_0000B9C0        *
  *                         3: 00000000/00000000_00DDF64C        *
  *                         4: 00000000/00000000_008BD410        *
  *                         5: 00000000/00000000_008BD7A4        *
  *                         6: 20C7CA00/00000000_008BD74C        *
  *                         7: E9D3D6C7/00000000_008BD7A4        *
  *                         8: 00000000/00000000_008BD76C        *
  *                         9: 00000000/00000048_008BAEC0        *
  *                         A: 00000000/00000048_80DE1A0A        *
  *                         B: 00000000/00000000_00DE25CA        *
  *                         C: 00000000/00000000_80DE2826        *
  *                         D: 00000000/00000000_7F517CE8        *
  *                         E: 00000000/00000000_80DDEBCC        *
  *                         F: 00000000/00000000_00000030        *
  *                       END OF SYMPTOM DUMP                    *
  *                      This occurs if at least two SELECT      *
  *                      statements fullfil the following        *
  *                      conditions:                             *
  *                      -their output data sets (d fined        *
  *                       through OUTDDN) are members of the     *
  *                       same PDS data set.                     *
  *                      -the tables belong to the same          *
  *                       tablespace or the parallelism is       *
  *                       activated either for lds read in       *
  *                       native mode, either for SQL            *
  *                       unload in SQL mode                     *
  *                      Example: The following unload faces     *
  *                       this issue.                            *
  *                       //UL01     DD DSN=LABO.HPUZ0475        *
  *                        .OUTDATA(UL01),DISP=SHR               *
  *                       //UL02     DD DSN=LABO.HPUZ0475        *
  *                        .OUTDATA(UL02),DISP=SHR               *
  *                       //SYSIN    DD *                        *
  *                        UNLOAD TABLESPACE                     *
  *                        DB2 NO                                *
  *                         SELECT * FROM MZLFRD.TBDZBAFRD00601  *
  *                        OUTDDN UL01                           *
  *                        SELECT * FROM MZLFRD.TBDZBAFRD00601   *
  *                        OUTDDN UL02                           *
  *                        ;                                     *
  *                      pb54032                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The oddn 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:

  UI58959

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI58959

     UP18/11/02 P F811

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.