Server restore hangs and the db2diag.log is not updated with any messages

Technote (troubleshooting)


Problem(Abstract)

During a Tivoli Storage manager 'dsmserv restore db,' the process never ends and db2diag.log stops logging any additional messages

Symptom

dsmserv restore db process hangs and the last messages during restore are:

ANR0498W Session xxx refused for xxx because restore DB is in progress.
ANR1365I Volume xxx closed (end reached).
ANR4912I Database full restore in progress and DB transaction log bytes
transferred 377,630,731.
ANR1364I Input volume xxx closed.
ANR0514I Session 94 closed volume xxx.
ANR0403I Session 94 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
ANR0406I Session 99 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664)
ANR0403I Session 99 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
ANR0498W Session 102 refused for xxx because restore DB is in progress. ANR8468I LTO volume xxx dismounted from drive xx (/dev/IBMtape1)
in library LIB.

All db pages were restored, db backup tape was dismounted, but dsmserv restore process never ends and no additional messages are logged

On linux, we can see dsmserv restore and db2sysc processes are still running, but there is no resources used (no memory/cpu or disk used for these processes)

On db2diag.log last message is :

2012-03-16-18.16.38.869350-180 I40608764E509 LEVEL: Warning PID : 4861 TID : 139830252005120PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-123 APPID: *LOCAL.tsminst1.120316211630
AUTHID : TSMINST1
EDUID : 52 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8181
MESSAGE : The rollforward recovery phase completed with a return code of
-2063466452

and after hours, no additional message is logged

Cause

Return code -2063466452 indicates No available buffer pool pages (SQLB_BPFULL)

Environment

Tivoli Storage Manager server 6.x on Linux

Diagnosing the problem

Check the DB2 configuration the value for DB2_OVERRIDE_BPF usign the db2set command

Resolving the problem

Increase DB2 parameter DB2_OVERRIDE_BPF


Run below steps to increase bufferpool size :

1. Kill dsmserv restore, if soft kill doesn't work, use kill -9

2. Set the value : db2set DB2_OVERRIDE_BPF=4098,500

3. Terminate db2 with : db2 "terminate"
If db2 terminate doesn't work, then use db2 force or db2 force application all

4. Restart the dsmserv restore db process

After that, try the restore db again


Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager Extended Edition
Server

Software version:

6.1.2

Operating system(s):

Linux, Linux/x86

Software edition:

All Editions

Reference #:

1588432

Modified date:

2012-10-04

Translate my page

Machine Translation

Content navigation