Troubleshooting
Problem
Tivoli Storage Manager database backup fails with actlog message - "ANR4588E A database backup configuration might be incorrect". And with db2diag log message "Access not allowed. Tblspc Offline.".
Symptom
When the Tivoli Storage Manager Server attempts to perform an automatic database backup that is triggered by the DB2 archive log hitting 80% of capacity, or when a manual backup is attempted the following messages are being reported:
The activity log reports the following message:
- ANR4588E A database backup configuration might be incorrect.
Inspection of the db2diag log file shows this series of messages:
2015-09-22-09.07.30.890290-240 E891606A643 LEVEL: Error
PID : 9896092 TID : 40375 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-3171 APPID: *LOCAL.tsminst1.150922132754
AUTHID : TSMINST1 HOSTNAME: tsmserver1
EDUID : 40375 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1777
MESSAGE : ZRC=0x8002014E=-2147352242=SQLB_NOT_ALLOWED_OFFLINE
"Access not allowed. Tblspc Offline."
DATA #1 : String, 24 bytes
Pool could not be locked
DATA #2 : String, 7 bytes
REORG8K
2015-09-22-09.07.30.890972-240 E892250A603 LEVEL: Severe
PID : 9896092 TID : 40375 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-3171 APPID: *LOCAL.tsminst1.150922132754
AUTHID : TSMINST1 HOSTNAME: tsmserver1
EDUID : 40375 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1801
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2048
DATA #2 : Hexdump, 12 bytes
0x0A00030D2AF3DC98 : FFFF F800 0000 0006 0000 0006
2015-09-22-09.07.30.891429-240 E892854A964 LEVEL: Severe
PID : 9896092 TID : 40375 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-3171 APPID: *LOCAL.tsminst1.150922132754
AUTHID : TSMINST1 HOSTNAME: tsmserver1
EDUID : 40375 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, database utilities, sqlubBuildAppTbsp, probe:1801
MESSAGE : SQL2048N An error occurred while accessing object "".
Reason code: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 3
sqlerrmc: 6 6
sqlerrp : sqlubBui
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-09-22-09.07.31.171148-240 E893819A468 LEVEL: Severe
PID : 9896092 TID : 40375 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-3171 APPID: *LOCAL.tsminst1.150922132754
AUTHID : TSMINST1 HOSTNAME: tsmserver1
EDUID : 40375 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:1050
MESSAGE : Backup terminated.
Cause
The problem is caused by one or more tablespaces being in an offline state as reported by this message in the db2diag log:
"Access not allowed. Tblspc Offline."
Environment
All supported Tivoli Storage Manager Server environments.
Diagnosing The Problem
Use the following commands to find any offline tablespace(s):
db2start
db2 connect to TSMDB1
db2 list tablespaces show detail
An offline tablespace will be reported as follows:
- Tablespace ID = 6
Name = REORG8K
Type = System managed space
Contents = System Temporary data
State = 0x4000
- Detailed explanation:
- Offline
Resolving The Problem
Use the db2 list command to show what tablespace(s) are showing as offline. Check the tablespace contents to see if the tablespace is temporary data, or permanent data.
If the tablespace is permanent data try to bring it online:
- db2 "alter tablespace <tablespace name> switch online"
If the tablespace is temporary data, and it can not be brought online then try to drop the tablespace:
- db2 "drop tablespace REORG8K"
There is the possibility that when trying to drop a temporary tablespace the command fails with this message:
- SQL0283N System temporary table space "REORG16K" cannot be dropped
because it is the only system temporary table space with a "16K"
page size in the database. SQLSTATE=55026
When trying to bring the tablespace online this message is reported:
- db2 "alter tablespace REORG16K switch online"
SQL0293N Error accessing a table space container. SQLSTATE=57048
To drop this table space there must be another system temporary
tablespace with a "16K" page size. Technote 1694222 explains how to
create a new tablespace so that the offline tablespace can be dropped.
See the following link to document 1694222 for instructions:
Related Information
Was this topic helpful?
Document Information
More support for:
Tivoli Storage Manager
Software version:
All Supported Versions
Document number:
267431
Modified date:
17 June 2018
UID
swg21967723