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 IC73775 Status: Closed

SYSPROC.ADMIN_MOVE_TABLE MIGHT HANG IF YOU RUN IT MORE THAN ONCE
CONCURRENTLY

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
The procedure SYSPROC.ADMIN_MOVE_TABLE might hang if all the 
following conditions are true: 
- Multiple SYSPROC.ADMIN_MOVE_TABLE operations run concurrently. 
- The operation parameter of at least one concurrent run of 
SYSPROC.ADMIN_MOVE_TABLE is SWAP or CLEANUP. 
- The operation parameter of at least one other concurrent run 
of SYSPROC.ADMIN_MOVE_TABLE is INIT, SWAP or CLEANUP. 
 
This defect might cause the SAP tool DB6CONV to hang because 
DB6CONV runs SYSPROC.ADMIN_MOVE_TABLE more than once 
concurrently.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of DB2 for Linux, UNIX and Windows                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* The fix for APAR IC73734, which describes the same defect    * 
* for DB2 9.7, is in DB2 9.7 fixpak 4 and above.               * 
****************************************************************
Local Fix:
To prevent any possibility of the problem happening you can 
avoid running SYSPROC.ADMIN_MOVE_TABLE with the SWAP or CLEANUP 
operation at the same time as SYSPROC.ADMIN_MOVE_TABLE is 
running concurrently with the INIT, SWAP or CLEANUP operation.
Solution
module: dbappext. Permanent restriction
Workaround
To prevent any possibility of the problem happening you can 
avoid running SYSPROC.ADMIN_MOVE_TABLE with the SWAP or CLEANUP 
operation at the same time as SYSPROC.ADMIN_MOVE_TABLE is 
running concurrently with the INIT, SWAP or CLEANUP operation.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.01.2011
24.05.2011
24.05.2011
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)