2660844 - DB6: SQL0291N error during reorg or temp tablespace recreation

Symptom 1

Reorg job scheduled via t-code DB13 fails with SQL0291N error.

dev_w*:

C *** ERROR in DB6Open[/bas/749_REL/src/dbs/db6/dbdb6.c, 3749] CON = 1 (BEGIN)
C &+ dsql_db6_open( SQLExecute ): 
[IBM][CLI Driver][DB2/AIX64] SQL0291N State transition not allowed on table space.
C &+ SQLSTATE=55039 row=1
C &+ CALL ADMIN_CMD(?) /*reorg*/

db2diag.log:

2018-05-28-10.51.01.001704+480 I17028547A592 LEVEL: Severe
PID : 12345678  TID : 12345   PROC : db2sysc 0
INSTANCE: db2ABC  NODE : 000  DB : ABC
APPHDL : 0-12345  APPID: 10.23.26.11.45556.180528025101
AUTHID : DB2ABC  HOSTNAME: <host_name>
EDUID : 12345   EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStateGetCheck, probe:633
DATA #1 : String, 22 bytes
Current pool state is:
DATA #2 : Pool State, PD_TYPE_SQLB_POOL_STATE, 4 bytes
0x00000800
- SQLB_BACKUP_IN_PROGRESS  

Symptom 2

SQL0291N error happens when you try to recreate temporary tablespace following KBA 2520447.

SAP on IBM Db2 for Linux, UNIX, and Windows

SQL0291N, reorg, online backup, temporary tablespace, recreate , KBA , BC-DB-DB6-DBA , Database Administration , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem