During a Tivoli Storage manager 'dsmserv restore db,' the process never ends and db2diag.log stops logging any additional messages
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
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-220.127.116.119350-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
and after hours, no additional message is logged
Return code -2063466452 indicates No available buffer pool pages (SQLB_BPFULL)
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