|
Problem IC62375
|
Status: Closed |
Trap on Alter Tablespace |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Issuing "ALTER TABLESPACE <name> MANAGED BY AUTOMATIC STORAGE"
on a table space with is already automatic-storage-enabled may
result in a panic on a subsequent ALTER TABLESPACE statement.
All processes associated with the instance will be terminated,
errors will be logged to db2diag.log, and a FODC_Trap
subdirectory will be created in the db2dump directory.
Sample steps to reproduce:
db2sampl
db2 -v "connect to sample"
db2 -v "alter tablespace IBMDB2SAMPLEREL managed by automatic
storage"
db2 -v "alter tablespace IBMDB2SAMPLEREL lower high water mark"
sleep 10
db2 -v "list tables"
SQL1224N The database manager is not able to accept new
requests, has
terminated all requests in progress, or has terminated the
specified request
because of an error or a forced interrupt. SQLSTATE=55032
No output may be expected on the console.
The db2diag.log will contain a message similar to:
2009-08-05-17.18.35.379272-240 E10400E482 LEVEL: Info
PID : 23098 TID : 47582189447488PROC :
db2sysc
INSTANCE: tomhart NODE : 000 DB : SAMPLE
APPHDL : 0-36 APPID: *LOCAL.DB2.090805211845
AUTHID : TOMHART
EDUID : 72 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services,
sqlbExtentMovementEntryPoint, probe:4829
DATA #1 : <preformatted>
Extent Movement started on table space 3
2009-08-05-17.18.35.474417-240 E10883E552 LEVEL:
Warning
PID : 23098 TID : 47582189447488PROC :
db2sysc
INSTANCE: tomhart NODE : 000 DB : SAMPLE
APPHDL : 0-36 APPID: *LOCAL.DB2.090805211845
AUTHID : TOMHART
EDUID : 72 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:15
MESSAGE : ADM1534W Table space "IBMDB2SAMPLEREL" could not be
reduced in size
because there are used pages at the end of the table
space.
2009-08-05-17.18.35.509087-240 I11436E558 LEVEL: Error
PID : 23098 TID : 47582189447488PROC :
db2sysc
INSTANCE: tomhart NODE : 000 DB : SAMPLE
APPHDL : 0-36 APPID: *LOCAL.DB2.090805211845
AUTHID : TOMHART
EDUID : 72 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x00002B469740FA32 : 0000
The call stack for the failing EDU will be similar to:
sqlbAlterPoolActContOps
sqlbAlterPoolAct
storMgrAction
sqldmpnd
sqlptppl
sqlpxcm1
sqlrrcom_dps
sqlrrcom
sqlbEMReduceContainers
sqlbLockAndMoveExtents
sqlbExtentMovementEntryPoint
sqleIndCoordProcessRequest
sqeAgent::RunEDU |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* Issuing "ALTER TABLESPACE <name> MANAGED BY AUTOMATIC *
* STORAGE" *
* on a table space with is already automatic-storage-enabled *
* may *
* result in a panic on a subsequent ALTER TABLESPACE *
* statement. *
* All processes associated with the instance will be *
* terminated, *
* errors will be logged to db2diag.log, and a FODC_Trap *
* *
* subdirectory will be created in the db2dump directory. *
* *
* Sample steps to reproduce: *
* *
* db2sampl *
* db2 -v "connect to sample" *
* db2 -v "alter tablespace IBMDB2SAMPLEREL managed by *
* automatic *
* storage" *
* db2 -v "alter tablespace IBMDB2SAMPLEREL lower high water *
* mark" *
* sleep 10 *
* db2 -v "list tables" *
* *
* SQL1224N The database manager is not able to accept new *
* *
* requests, has *
* terminated all requests in progress, or has terminated the *
* *
* specified request *
* because of an error or a forced interrupt. SQLSTATE=55032 *
* *
* No output may be expected on the console. *
* *
* The db2diag.log will contain a message similar to: *
* *
* 2009-08-05-17.18.35.379272-240 E10400E482 LEVEL: Info *
* PID : 23098 TID : 47582189447488 PROC : db2sysc *
* *
* INSTANCE: tomhart NODE : 000 *
* DB :SAMPLEAPPHDL : 0-36 *
* APPID: *LOCAL.DB2.090805211845 AUTHID : TOMHART *
* EDUID : 72 EDUNAME: db2agent (SAMPLE) *
* FUNCTION: DB2 UDB, buffer pool services, *
* sqlbExtentMovementEntryPoint, probe:4829 *
* DATA #1 : <preformatted> *
* Extent Movement started on table space 3 *
* *
* 2009-08-05-17.18.35.474417-240 E10883E552 *
* LEVEL: Warning *
* PID : 23098 TID : 47582189447488 PROC : db2sysc *
* INSTANCE: tomhart NODE : 000 *
* DB : SAMPLEAPPHDL : 0-36 *
* APPID: *LOCAL.DB2.090805211845 AUTHID : TOMHART *
* EDUID : 72 EDUNAME: db2agent (SAMPLE) *
* FUNCTION: DB2 UDB, buffer pool services, *
* sqlbAlterPool, probe:15 *
* MESSAGE : ADM1534W Table space *
* "IBMDB2SAMPLEREL" could not be reduced in size *
* because there are used *
* pages at the end of the table space. *
* *
* 2009-08-05-17.18.35.509087-240 I11436E558 *
* LEVEL: Error *
* PID : 23098 TID : 47582189447488 PROC : db2sysc *
* INSTANCE: tomhart NODE : 000 *
* DB : SAMPLEAPPHDL : 0-36 *
* APPID: *LOCAL.DB2.090805211845 AUTHID : TOMHART *
* EDUID : 72 EDUNAME: db2agent (SAMPLE) *
* FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, *
* probe:1 *
* MESSAGE : Error in agent servicing application with *
* coor_node: *
* DATA #1 : Hexdump, 2bytes *
* 0x00002B469740FA32 : 0000 *
* *
* The call stack for the failing EDU will be similar to: *
* sqlbAlterPoolActContOps *
* sqlbAlterPoolAct *
* storMgrAction *
* sqldmpnd *
* sqlptppl *
* sqlpxcm1 *
* sqlrrcom_dps *
* sqlrrcom *
* sqlbEMReduceContainers *
* sqlbLockAndMoveExtents *
* sqlbExtentMovementEntryPoint *
* sqleIndCoordProcessRequest *
* sqeAgent::RunEDU *
* *
* To avoid this issue, do not issue "ALTER TABLESPACE <name> *
* MANAGED BY *
* AUTOMATIC STORAGE" on an automatic storage table space. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 1. *
**************************************************************** |
| Local Fix: |
Do not issue "ALTER TABLESPACE <name> MANAGED BY AUTOMATIC
STORAGE" on an automatic storage table space. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.08.2009
24.12.2009
24.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
