PH24369: NEW FUNCTION SUPPORT FOR LOAD UTILITY

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function support for LOAD FORCE cancel claimers
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of                                 *
  * LOAD utility                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * New FORCE keyword option for the LOAD                        *
  * utility                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR introduces a new keyword option, FORCE, to the LOAD
  utility.  IBM Knowledge Center is updated for these changes:
  V12: https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/
       ugref/src/tpc/db2z_loadsyntax.html
  Syntax diagram:
  >--LOAD--...
     |-FORCE--NONE-----|
  >--|-----------------|-----|--into-table-spec--|--
     |-FORCE--READERS--|
     |-FORCE--ALL------|
  DESCRIPTION: FORCE
  Specifies the action to be taken when the utility is draining
  the table space.
  When LOAD FORCE is canceling the threads, it performs an
  internal cancel similar to the cancel that the CANCEL THREAD
  command does.
  NONE
  Specifies that no action is taken when LOAD performs drain.
  The LOAD utility waits for the claimers to commit in its drain
  processing. The utility will timeout or retry when the drain
  fails, as determined by existing conditions.  This is the
  default behavior.
  READERS
  Specifies that read claimers are cancelled when LOAD is
  requesting a drain all on the last RETRY processing.
  ALL
  Specifies that both read and write claimers are cancelled when
  LOAD is requesting a drain all or drain writers on the last
  drain retry.
  Usage notes:
  - The FORCE option is not applicable for LOAD SHRLEVEL CHANGE
    execution and would be ignored when specified.
  - For LOAD SHRLEVEL NONE, there is no drain retry processing.
    If FORCE READERS or ALL is specified for LOAD SHRLEVEL NONE,
    the target blocking claimers will be cancelled during the
    one and only drain all performed at the start of the utility.
  

Problem conclusion

Temporary fix

Comments

• Code has been modified to deliver the aforementioned
  new function under the LOAD utility.
  

APAR Information

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

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

  UI70432

Modules/Macros

• DSNURWI  DSNULDRN DSNUGDDF DSNUGPRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI70432

     UP20/07/15 P F007

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.