PM97785: MINSTOR IS SET AS DEFAULT YES INSTEAD OF NO IN (SAP) MEMBER DSNTIDXB

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • MINSTOR is set as default YES instead of NO in (SAP) member
    DSNTIDXB
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All customers who run SAP on DB2 10 for z/OS *
    *                 and DB2 11 for z/OS are affected by this     *
    *                 change.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides new and updated      *
    *                      configuration settings for customers    *
    *                      who run SAP on DB2 10 for z/OS and DB2  *
    *                      11 for z/OS.                            *
    ****************************************************************
    * RECOMMENDATION: Apply the fixing PTF for this APAR.          *
    ****************************************************************
    DSNTIDXB is a DB2 installation CLIST input member that contains
    configuration settings specifically for installing and migrating
    DB2 for z/OS for use with SAP.
    
    SAP has recently revised certain recommended settings as
    follows:
    
    SUMMARY
    =======
                            |===== DB2 10 =====||===== DB2 11 =====|
    DSNTIDXB                |Previous  New     ||Previous  New     |
    entry name              |setting   setting ||setting   setting |
    ------------------------|--------  --------||--------  --------|
    CACHE_DEP_TRACK_STOR_LIM|2         10      ||2         10      |
    IRLMWAIT                |600       (same)  ||600       300     |
    MAXCONQW                |OFF       (same)  ||OFF       5       |
    MINSTOR                 |YES       NO      ||YES       NO      |
    RRF                     |DISABLE   (same)  ||DISABLE   ENABLE  |
    URCHKTH                 |1         2       ||1         2       |
    WFSTGUSE_AGENT_THRESHOLD|n/a       n/a     ||0         50      |
    
    
    DETAILS
    =======
    
    DSNTIDXB entry name       Description
    ------------------------  --------------------------------------
    CACHE_DEP_TRACK_STOR_LIM  GB of storage allocated by DB2 for
                              hashing entries in the dynamic
                              statement cache
    
                                 Change:
                                   DB2 10: 2 -> 10
                                   DB2 11: 2 -> 10
    
    IRLMWAIT                  Corresponds to DB2 subsystem parameter
                              IRLMRWT: Max time in seconds that DB2
                              will wait for a locked resource
    
                                 Change:
                                   DB2 10: No change
                                   DB2 11: 600 -> 300
    
    MAXCONQW                  Max time for a connection to wait for
                              a DBAT
    
                                 Change:
                                   DB2 10: No change
                                   DB2 11: OFF -> 5
    
    MINSTOR                   Whether DB2 is to manage threads to
                              reduce storage
    
                                 Change:
                                   DB2 10: YES -> NO
                                   DB2 11: YES -> NO
    
    RRF                       Whether to use Reordered Row Format
                              by default
    
                                 Change:
                                   DB2 10: No change
                                   DB2 11: DISABLE -> ENABLE
    
    URCHKTH                   UR checkpoint warning threshold
    
                                 Change:
                                   DB2 10: 1 -> 2
                                   DB2 11: 1 -> 2
    
    
    WFSTGUSE_AGENT_THRESHOLD  Max percentage of space in the work
                              file database that can be consumed by
                              a single agent before a warning
    
                                 Change:
                                   DB2 10: n/a
                                   DB2 11: 0 -> 50
    
    Refer to SAP Note 1476146 for more information about recommended
    DB2 10 for z/OS configuration settings for SAP customers.
    
    Refer to SAP Note 1863848 for more information about recommended
    DB2 11 for z/OS configuration settings for SAP customers.
    

Problem conclusion

  • This APAR provides updated recommendations for configuring and
    operating DB2 10 and DB2 11 for use with SAP.  All SAP customers
    who have already installed or migrated to DB2 10 or DB2 11
    should follow guidance provided in the ++HOLD actions section.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97785

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-25

  • Closed date

    2013-10-25

  • Last modified date

    2013-12-02

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

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

    UI11690 UI11691

Modules/Macros

  • DSNTIDXB
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI11690

       UP13/11/12 P F311

  • RB10 PSY UI11691

       UP13/11/12 P F311

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 #:

PM97785

Modified date:

2013-12-02

Translate my page

Machine Translation

Content navigation