If a user issues
DB2 ALTER TABLESPACE REDUCE <size>
and specifies a size that exceeds the tablespace's available
pages, but below the tablespace's total pages, then the
following
db2diag.log messages might appear (note that the command might
return without error):
2011-07-28-12.43.56.787512-240 E779929E520 LEVEL: Info
PID : 21379 TID : 47684874398016PROC :
db2sysc
INSTANCE: dbinstance NODE : 000 DB :
TESTDB
APPHDL : 0-51 APPID: *LOCAL.DB2.110728164356
AUTHID : USER
EDUID : 98 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, buffer pool services, sqlb_locate_extent,
probe:232
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
DATA #1 : <preformatted>
2011-07-28-12.43.56.787512-240 E779929E520 LEVEL: Info
PID : 21379 TID : 47684874398016PROC :
db2sysc
INSTANCE: dbinstance NODE : 000 DB :
TESTDB
APPHDL : 0-51 APPID: *LOCAL.DB2.110728164356
AUTHID : USER
EDUID : 98 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, buffer pool services,
sqlbBuildContOpListForReduce, probe:10
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
2011-07-28-12.43.56.787512-240 E779929E520 LEVEL: Info
PID : 21379 TID : 47684874398016PROC :
db2sysc
INSTANCE: dbinstance NODE : 000 DB :
TESTDB
APPHDL : 0-51 APPID: *LOCAL.DB2.110728164356
AUTHID : USER
EDUID : 98 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:70
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
2011-07-28-12.43.56.787512-240 E779929E520 LEVEL: Info
PID : 21379 TID : 47684874398016PROC :
db2sysc
INSTANCE: dbinstance NODE : 000 DB :
TESTDB
APPHDL : 0-51 APPID: *LOCAL.DB2.110728164356
AUTHID : USER
EDUID : 98 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, buffer pool services, sqlbEMReduceContainers,
probe:3608
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
DATA #1 : String, 14 bytes
Error occurred
2011-07-28-12.43.56.787512-240 E779929E520 LEVEL: Info
PID : 21379 TID : 47684874398016PROC :
db2sysc
INSTANCE: dbinstance NODE : 000 DB :
TESTDB
APPHDL : 0-51 APPID: *LOCAL.DB2.110728164356
AUTHID : USER
EDUID : 98 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAndMoveExtents,
probe:4439
MESSAGE : ADM6008I Extents within table space "DMS" (ID "3")
have been moved.
Reason code = "0".
Total pages and available pages are state info about a
tablespace and they can have different meanings throughout the
life of a tablespace. The simplest scenario for this problem to
occur would be a customer issuing ALTER to reduce the tablespace
to 0 size, which is a very unlikely scenario. However, it is
also possible that the tablespace currently is in some state
that causes the totalpages to be way bigger than the available,
and customer only take notice of the total pages parameter and
issue a reduce based on that, causing the problem to occur. |
