SAP Knowledge Base Article - Preview

2660844 - DB6: DSQL0291N error during DB13 reorg job

Symptom

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 

Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.