PI42495: DECREASE THE AMOUNT OF TIME A PARTITION OF THE UNLOAD TABLE SPACE IS UNAVAILABLE TO OTHER PROGRAMS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When either the LOCK YES (native syntax) or the SHRLEVEL
  REFERENCE (Unload Plus or Fast Unload syntax) is specified for
  an unload processed in native mode, the unload utility uselessly
  keeps the partitions of the unloaded table space locked till the
  end of the unload. This prevent other programs or utilities to
  access the partitions of the table space for update during the
  whole unload processing because of S-lock. This behavior should
  be changed to decrease the amount of time a partition of the
  unload table space is unavailable to other programs.
  Other keywords
  PB12776 Z544 share reference
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When either the LOCK YES (native        *
  *                      syntax) or the SHRLEVEL REFERENCE       *
  *                      (Unload Plus or Fast Unload syntax) is  *
  *                      specified for an unload processed in    *
  *                      native mode, the unload utility         *
  *                      uselessly keeps the partitions of the   *
  *                      unloaded table space locked till the    *
  *                      end of the unload. This prevent other   *
  *                      programs or utilities to access the     *
  *                      partitions of the table space for       *
  *                      update during the whole unload          *
  *                      processing because of S-lock. This      *
  *                      behavior should be changed to decrease  *
  *                      the amonunt of time a partition of the  *
  *                      unload table space is unavailable to    *
  *                      other programs.                         *
  *                      pb 12776                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The ix3tools, oddlcmd, oddldb2, oddl, mcall, odb2cmd, udballoc,
  udbcrrts, udbldef, inzatom, inzmsgs, inzpab, inzpabf, inzplib,
  inzrun, inztoken, inzxpli, inzmain, inzpab, inzrunh, osysmvs,
  inztvar, inztdsc, infoutie, inztcprm and infutile modules were
  changed.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    INZTVAR
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI28952

     UP15/07/03 P F507

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.