View Single Post
  #5 (permalink)  
Old 01-02-09, 09:12
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,563
Quote:
Originally Posted by stolze
For example, if you have lots of table scans and a not-so-good BPHR...
What is BPHR?

Has anyone tested this atime settings and impact it has on DB2 performance on yours system? By the way, I have also find the same parameter on Windows, which is also not turned on by default. So it could also benefit on performance on DB2 on Windows.

But what is my point: What is IBM recommendation for setting atime when using DB2 on Linux? I can't find any article to recommend this settings for DB2, but I could find an IBM article for suggesting this settings for LAMP.
Regards

Last edited by grofaty; 01-02-09 at 09:16.
Reply With Quote