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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM32921

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-16

  • Closed date

    2011-06-06

  • Last modified date

    2011-07-05

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM32921

Modified date:

2011-07-05

Translate my page

Machine Translation

Content navigation