dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

db2 disconnect all - db2-udb

This is a discussion on db2 disconnect all - db2-udb ; If i do "db2 disconnect all" after an application finishes, does it mean that any application that connects after this will find the buffer pool "cold"? Or the pages accessed by last application will be still in buffer pool? Apparently ...


Home > Database Forum > Other Databases > db2-udb > db2 disconnect all

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 03-04-2008, 02:24 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default db2 disconnect all

If i do "db2 disconnect all" after an application finishes, does it
mean that any application that connects after this will find the buffer
pool "cold"? Or the pages accessed by last application will be still in
buffer pool? Apparently when I do "db2 disconnect all" at the end, the
windows task manager shows that all bufferpool memory has been deallocated.

thanks
Reply With Quote
  #2  
Old 03-06-2008, 07:19 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: db2 disconnect all

Hello,



So I would say you answered your question by yourself - no memory
allocated - no pages in buffer pools...



greetz



Chris


Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 12:49 PM.