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

Obtain the fix for this APAR.

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