DSNB520I READY TO EXPLICITLY DELETE BUFFER POOL bpname
Explanation
This message is issued before draining an active buffer pool in response to an ALTER BUFFERPOOL command, which specified VPSIZE=0 against an active buffer pool.
System action
After this message is issued, DB2® quiesces all current activities against this buffer pool. DB2 locks the table space exclusively and performs physical close for all open table spaces or index spaces that reference this pool. DB2 also prevents subsequent database access that references this pool. SQL applications get an SQLCODE -904 (resource not available) with reason code 00C200E0 to indicate that the requested buffer pool size is not initialized. After the requested buffer pool is deleted, message DSNB521I is issued.