EnableB2 stored in Backups?

[jdpjamesp]

Just a quick clarification query really.
At the weekend I popped the Schema Area into the alternate buffer pool using
Proutil icmasliv -C EnableB2 "Schema Area"
My question is, if we were to revert to backups (taken since this change) would I have to execute this command again?

 

[cj_brandt]

no. you can use the proutil <dbname> -C viewb2 command on the new db to verify.

 

[jdpjamesp]

Thanks cj.

 

[TomBascom]

If you have B2 enabled be sure to use -Bp 100 on your probkup. That prevents accidental filling of the B2 buffers and the consequent undesired enabling of the LRU mechanism.

It's actually a good idea in any event -- you don't want a backup flushing either buffer pool.

 

[jdpjamesp]

Thanks Tom - good advice as always.

 

[jdpjamesp]

I'm assuming -Bp limits were increased in later versions? 11.2.1 has a max setting of 64. Still a useful setting though.

 

[TheMadDBA]

-Bpmax lets you change the max value for -Bp per connection, the default is 64.

http://knowledgebase.progress.com/articles/Article/P27888

 

[Rob Fitzpatrick]

If you have B2 enabled be sure to use -Bp 100 on your probkup.

Tom, are you referring to the mid-10.2B bug where probkup online enabled the B2 LRU mechanism even if the ABP wasn't full?

Edit: this was bug PSC00234422 and it was fixed in 10.2B05.

 

[TomBascom]

Yes.