home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC87827 Status: Closed

MISLEADING DIAGNOSTIC MESSAGE INDICATING A BUFFER POOL IS AUTOMATIC WHEN IT
IS NOT

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
When the user attempts to create a buffer pool, a message is 
printed in the DB2 diagnostic log. This message always indicates 
that the buffer pool to be created is "automatic" even when it 
is not. Example: 
 
$ db2 create bufferpool bp1 size 1000 
DB20000I  The SQL command completed successfully. 
 
db2diag.log 
=========== 
2012-02-09-13.41.22.764786-300 I1921E470          LEVEL: Info 
PID    : 3506                TID  : 46912988244288PROC : db2sysc 
INSTANCE: db2inst1              NODE : 000          DB  : SAMPLE 
APPHDL  : 0-23                APPID: 
*LOCAL.db2inst1.120209184100 
AUTHID  : DB2INST1 
EDUID  : 29                  EDUNAME: db2agent (SAMPLE) 
FUNCTION: DB2 UDB, buffer pool services, 
sqlbCreateBufferPoolAct, probe:98 
MESSAGE : Creating bufferpool "BP1" Size: "1000"  <automatic> 
 
The last line contains the word "<automatic>", which is wrong.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 for Linux, UNIX, and Windows version 10.1 Fix * 
* Pack 1                                                       * 
****************************************************************
Local Fix:
Solution
Problem first fixed in DB2 for Linux, UNIX, and Windows version 
10.1 Fix Pack 1
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.11.2012
05.11.2012
05.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)