home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC68981 Status: Geschlossen

SHEAPTHRES_SHR RECOMMENDATION IS MISSING FROM THE OUTPUT WHEN RUNNING THE
CONFIGURATION ADVISOR

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
The database configuration parameter, SHEAPTHRES_SHR, can be 
automatically configured by the Configuration Advisor via the 
AUTOCONFIGURE command. However, the recommendation for 
SHEAPTHRES_SHR is not shown in the output of the AUTOCONFIGURE 
command. In the case where AUTOCONFIGURE command is called with 
the APPLY option, the update on SHEAPTHRES_SHR to the 
recommended value actually takes place. 
 
Here's a sample output from running AUTOCONFIGURE on the CLP: 
 
 Description                                   Parameter 
Current Value       Recommended Value 
 --------------------------------------------------------------- 
---------------------------------- 
 Default application heap (4KB)             (APPLHEAPSZ) = 256 
              256 
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 300 
              300 
 Changed pages threshold                (CHNGPGS_THRESH) = 80 
              80 
 Database heap (4KB)                            (DBHEAP) = 3070 
              3070 
 Degree of parallelism                      (DFT_DEGREE) = 1 
              1 
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32 
              32 
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = 
AUTOMATIC           AUTOMATIC 
 Default query optimization class         (DFT_QUERYOPT) = 5 
              5 
 Max storage for lock list (4KB)              (LOCKLIST) = 
AUTOMATIC           AUTOMATIC 
 Log buffer size (4KB)                        (LOGBUFSZ) = 99 
              99 
 Log file size (4KB)                         (LOGFILSIZ) = 1024 
              1024 
 Number of primary log files                (LOGPRIMARY) = 11 
              11 
 Number of secondary log files               (LOGSECOND) = 4 
              4 
 Max number of active applications            (MAXAPPLS) = 
AUTOMATIC           AUTOMATIC 
 Percent. of lock lists per application       (MAXLOCKS) = 
AUTOMATIC           AUTOMATIC 
 Group commit count                          (MINCOMMIT) = 1 
              1 
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = 7 
              1 
 Number of I/O servers                   (NUM_IOSERVERS) = 3 
              5 
 Package cache size (4KB)                   (PCKCACHESZ) = 
AUTOMATIC           AUTOMATIC 
 Percent log file reclaimed before soft chckpt (SOFTMAX) = 440 
              440 
 Sort list heap (4KB)                         (SORTHEAP) = 
AUTOMATIC           AUTOMATIC 
 SQL statement heap (4KB)                     (STMTHEAP) = 4096 
              4096 
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = 4384 
              4384 
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 
203301              203301 
 Self tuning memory                    (SELF_TUNING_MEM) = ON 
              ON 
     Automatic runstats                  (AUTO_RUNSTATS) = ON 
              ON 
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000 
              AUTOMATIC 
 
If you don't see the last line shown above, then you are hitting 
this APAR.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Version 9.5 Fix Pack 5 servers on Linux, Unix, and   * 
* Windows platforms issuing the AUTOCONFIGURE command.         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The AUTOCONFIGURE command is only expecting "n" DB CFG       * 
* parameters, but the actual number of parameters is "n+1".    * 
* SHEAPTHRES_SHR is the last parameter in the structure, thus, * 
* it's missed from the output.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 5 or see "Local Fix".    * 
****************************************************************
Local-Fix:
It's advised to always leave SHEAPTHRES_SHR set to its default 
which is AUTOMATIC.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
The problem is first fixed in DB2 Version 9.5 Fix Pack 6 and all 
subsequent Fix Packs.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.06.2010
30.06.2010
30.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP5,
9.5.FP6
Problem behoben lt. FixList in der Version