PM37660: ENABLEMENT FOR PM36177 (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

  • Enablement for PM36177 (time out factor for DDL and DCL)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides enablement for APAR  *
    *                      PM36177 which is an enhancement to      *
    *                      allow users more control on wait time   *
    *                      for a resource during DDL statement     *
    *                      processing.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This enhancement allows a user more control on the wait time for
    a resource during the processing of a DDL statement before a
    time out is encountered.
    
    A new parameter DDLTOX in DSN6SPRM is introduced as a separate
    time out factor for DDL and DCL (GRANT, REVOKE, and LOCK)
    statements. DDLTOX can be used to influence how long, in number
    or resource values, that a request for SQL data definition will
    wait for a resource. The actual time out value will be the
    product of DDLTOX and the standard IRLM time out value that is
    in effect as specified by DSN6SPRM.IRLMRWT.
    
    Valid settings for DDLTOX are 1 to 254. The default is 1,
    meaning that the standard IRLM time out value is used.
    
    DDLTOX is online changeable. In data sharing, it has member
    scope.
    

Problem conclusion

Temporary fix

Comments

  • This is the V10 change for APAR PM32921.
    
    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.
    
    ++HOLD Type MTS
    **Action for PM37660
    PM37660 is an APAR that includes enhancements to support an
    IRLM timeout factor for DDL statement processing thta will be
    enabled once this APAR is applied.
    A pre-conditioning APAR PM36177 was delivered. In a data sharing
    groups, this pre-conditioning APAR should be applied to all
    members before applying this enabling APAR to any member. The
    code change is enabled once this enabling APAR is applied.
    
    ++HOLD Type Action
    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

    PM37660

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-04-22

  • Closed date

    2011-06-22

  • Last modified date

    2011-08-01

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

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

    UK69030

Modules/Macros

  •    DSN@XAZP DSNDQWPZ DSNDSPRM DSNTIDXA DSNTIDXB
    DSNTIJUZ DSNTINST DSNTXAZH DSNTXAZP DSNWZIFA DSN6SPRM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK69030

       UP11/07/08 P F107

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:

A10

Reference #:

PM37660

Modified date:

2011-08-01

Translate my page

Machine Translation

Content navigation