PI26202: TIOT SATURATION AND MESSAGES SUCH AS THE INZI330E DYNAMIC ALLOCATION FAILED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Despite ONDEMAND_RESOURCE_ALLOCATION(YES) is specified via
  ULOPTNS, the allocation of all the image copies involved in the
  unload (COPYDDYN specified) is at the beginning of the
  processing. If the number of partition is big enough, this can
  lead to the TIOT saturation and messages such as the following
  to be issued:
  
    INZI330E DYNAMIC ALLOCATION FAILED. TEMPLATE=TABDATA
            DSN=DF30APPL.BJSP56.DABISPS.TPSAPSH.P00046.C
            RC=4, REASON=0x238
            SVC99 MESSAGES ARE REPORTED IN JESMSGL CARD
  
   13.34.50 JOB38031  IKJ56220I DATA SET
  DF30APPL.BJSP56.DABISPS.TPSAPSH.P00046.C NOT ALLOCATED, TOO MANY
  DATA SETS+
   13.34.50 JOB38031  IKJ56220I MAXIMUM NUMBER OF DATA SET
  ALLOCATIONS ALLOWED BY YOUR SESSION HAS BEEN REACHED, YOU SHOULD
  FREE
                               UNUSED DATA SETS
  
  PB12521 INZI330E MSGINZI330E INZI330 MSGINZI330
  

Local fix

• in order to avoid TIOT saturation, consider splitting up the
  unload command into several unload commands with an additional
  PART clause.
  
  For example, replace the following:
  
  TEMPLATE MYCOPY DSN my.dsn.prefix.P&PART..D2014250.T1401
  TEMPLATE MYDATA DSN my.dsn.prefix.&DB..&TS..P&PART..D
      DISP (NEW,CATLG,CATLG) DATACLAS(DCCOMP)
      UNIT(3390)  SPACE (1000,4300) CYL
  TEMPLATE MYLOAD DSN my.dsn.prefix.&DB..&TS..P&PART..S
      DISP (NEW,CATLG,CATLG)
      UNIT(3390)  SPACE (1,1) CYL
  UNLOAD TABLESPACE MYDB.MYTS
      DB2 NO
      QUIESCE NO  QUIESCECAT NO
      COPYDDN MYCOPY
      SELECT * FROM SYSA.APSH
      ORIGINOBID 0
      OUTDDN MYDATA
      LOADDDN MYLOAD
  
  by
  
  TEMPLATE MYCOPY DSN my.dsn.prefix.P&PART..D2014250.T1401
  TEMPLATE MYDATA DSN my.dsn.prefix.&DB..&TS..P&PART..D
      DISP (NEW,CATLG,CATLG) DATACLAS(DCCOMP)
      UNIT(3390)  SPACE (1000,4300) CYL
  TEMPLATE MYLOAD DSN my.dsn.prefix.&DB..&TS..P&PART..S
      DISP (NEW,CATLG,CATLG)
      UNIT(3390)  SPACE (1,1) CYL
  UNLOAD TABLESPACE MYDB.MYTS                 PART(1,100)
      DB2 NO
      QUIESCE NO  QUIESCECAT NO
      COPYDDN MYCOPY
      SELECT * FROM SYSA.APSH
      ORIGINOBID 0
      OUTDDN MYDATA
      LOADDDN MYLOAD
      DB2 NO
      QUIESCE NO  QUIESCECAT NO
      COPYDDN MYCOPY
      SELECT * FROM SYSA.APSH
      ORIGINOBID 0
      OUTDDN MYDATA
      LOADDDN MYLOAD
  UNLOAD TABLESPACE MYDB.MYTS                PART(101,200)
     DB2 NO
     QUIESCE NO  QUIESCECAT NO
     COPYDDN MYCOPY
     SELECT * FROM ME.MYTABLE
     ORIGINOBID 0
     OUTDDN MYDATA
     LOADDDN MYLOAD
  UNLOAD TABLESPACE MYDB.MYTS                PART(201,300)
     DB2 NO
     QUIESCE NO  QUIESCECAT NO
     COPYDDN MYCOPY
     SELECT * FROM ME.MYTABLE
     ORIGINOBID 0
     OUTDDN MYDATA
     LOADDDN MYLOAD
  UNLOAD TABLESPACE MYDB.MYTS                PART(301,435)
      DB2 NO
      QUIESCE NO  QUIESCECAT NO
      COPYDDN MYCOPY
      SELECT * FROM SYSA.APSH
      ORIGINOBID 0
      OUTDDN MYDATA
      LOADDDN MYLOAD
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Despite ONDEMAND_RESOURCE_ALLOCATION    *
  *                      (YES) is specified via ULOPTNS, the     *
  *                      allocation of all the image copies      *
  *                      involved in the unload                  *
  *                      (COPYDDYN specified) is at the          *
  *                      beginning of the processing. If the     *
  *                      number of partition is big enough,      *
  *                      this can lead to the TIOT saturation    *
  *                      and messages such as the following to   *
  *                      be issued:                              *
  *                       INZI330E DYNAMIC ALLOCATION FAILED.    *
  *                       TEMPLATE=TABDATA                       *
  *                       DSN=DF30APPL.BJSP56.DABISPS.TPSAPSH    *
  *                       .P00046.C                              *
  *                       RC=4, REASON=0x238                     *
  *                       SVC99 MESSAGES ARE REPORTED IN JESMSGL *
  *                       CARD                                   *
  *                      13.34.50 JOB38031  IKJ56220I DATA SET   *
  *                       DF30APPL.BJSP56.DABISPS.TPSAPSH        *
  *                       .P00046.C NOT ALLOCATED, TOO MANY      *
  *                       DATA SETS+                             *
  *                      13.34.50 JOB38031  IKJ56220I MAXIMUM    *
  *                       NUMBER OF DATA SET ALLOCATIONS         *
  *                       ALLOWED BY YOUR SESSION HAS BEEN       *
  *                       REACHED, YOU SHOULD FREE UNUSED DATA   *
  *                       SETS                                   *
  *                      PB12521                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzrunh, inzrun and inzpabf  modules were 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:

  UI23202

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI23202

     UP14/11/25 P F411

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.