PM32921: ADD NEW SUBSYSTEM PARAMETER (ZPARM) AS TIME OUT FACTOR FOR DDL AND DCL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• During the processing of a DDL statement, DB2 uses the standard
  IRLM time out value for obtaining locks.  This limits user
  flexibility on controlling how long DDL statements will wait for
  a resource before timing out.
  .
  To allow user more control on the wait time for a resource
  during the processing of a DDL statement before a time out is
  encountered, we would like to introduce a separate time out
  factor for DDL and DCL (GRANT, REVOKE, and LOCK) statements.
  New subsystem parameter (ZPARM) will be added in order to
  influence the timeout value.
  .
  The actual time out value will be the product of new parameter
  and the standard IRLM time out value that is in effect as
  specified by IRLMRWT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 9 for z/OS                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: User receives SQLCODE -904 RC00E70010   *
  *                      on ALTER TABLE ROTATE PARTITION FIRST   *
  *                      TO LAST                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  User receives SQLCODE904 RC00E70010 on ALTER TABLE ROTATE
  PARTITION FIRST TO LAST due to an insufficient IRLM timeout
  value.
  

Problem conclusion

Temporary fix

Comments

• This fix is an enhancement to allow a user more control on the
  wait time for a resource during the processing of a DDL
  statement before a timeout is encountered.
  
  This PTF adds a new DB2 subsystem parameter in DSN6SPRM named
  DDLTOX that allows you to specify how long, in number of
  resource values, that a request for SQL data definition will
  wait for a resource.  The actual time out value is the product
  of this value and the standard IRLM time out value specified for
  DSN6SPRM.IRLMRWT.  The DDLTOX setting is an integer that can
  range from 1 to 254.  The default setting of 1 means that only
  the IRLM time out value should be used.
  
  Additional Keywords:
  SQLCREATE
  SQLDROP
  SQLALTER
  SQLCODE904
  
  ++HOLD Action for PM32921
  
  If you have already installed or migrated to this version of DB2
  you need to take the following actions after applying this PTF:
  
  (1) Update customized copies of DB2 installation CLIST members
  (2) Update your customized copy of job DSNTIJUZ
  (3) Update private copies of the DSNTIDxx CLIST input member
  
  Detailed guidance for these actions follows:
  
  ----------------------------------------------------------------
  (1) Update customized copies of DB2 installation CLIST members
  ----------------------------------------------------------------
  ==> This action is required for all customers
  
      This PTF modifies CLIST member DSNTINST in the SDSNCLST
      target library only. You need to redo any record format
      changes and reapply any tailoring you have done to your
      copies of this CLIST. You may also want to move it to the
      prefix.NEW.SDSNCLST data set, where the CLISTs processed by
      job DSNTIJVC reside.
  
  ----------------------------------------------------------------
  (2) Update your customized copy of job DSNTIJUZ
  ----------------------------------------------------------------
  ==> This action is required for all customers
  
      This PTF modifies DB2 installation job DSNTIJUZ in the
      SDSNSAMP target library. After applying this PTF, you
      need to update your customized copy of this job as follows:
  
      * Add the keyword parameter DDLTOX=<n>, where <n> is an
        integer ranging from 1 to 254, to the invocation of the
        DSN6SPRM macro.  Make sure to add a continuation character
        in column 72 if needed. If you omit adding DDLTOX here,
        the value will be set to the default of NO when you
        assemble the DSNZPxxx module.
  
      * Run the first two steps of the DSNTIJUZ job you modified.
  
      * After the job completes, you must either use the -SET
        SYSPARM command or stop and restart DB2 for the change to
         take effect.
  
   ---------------------------------------------------------------
   (3) Update private copies of the DSNTIDxx CLIST input member
   ---------------------------------------------------------------
   ==> This action is required for all customers
  
        This PTF adds an entry for DDLTOX
        to the CLIST default input members,
        DSNTIDXA and DSNTIDXB, in the SDSNSAMP target library. You
        need to add these entries to all private copies of your
        CLIST output DSNTIDxx member.  In each such copy, add the
        following lines:
  
   DDLTOX   NUM   M  1           254           <n>
  
        Change <n> to the value you specified for
        DDLTOX in step (2), above.
  

APAR Information

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

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

  UK68474

Modules/Macros

• DSN@XAZP DSNDQWPZ DSNDSPRM DSNTIDXA DSNTIJUZ
  DSNTINST DSNTXAZH DSNTXAZP DSNWZIF9 DSNXI14  DSN6SPRM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK68474

     UP11/06/21 P F106

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.