|
Problem IC68981
|
Status: Closed |
SHEAPTHRES_SHR RECOMMENDATION IS MISSING FROM THE OUTPUT WHEN RUNNING THE CONFIGURATION ADVISOR |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
The problem is first fixed in DB2 Version 9.5 Fix Pack 6 and all
subsequent Fix Packs. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.06.2010
30.06.2010
30.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5,
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
