Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tuning DB2: Where Your Data Is and Why it Matters

Learn how and where your data is stored and how to manage it for better performance.


advertisement
atabase performance is one of those things that goes unnoticed, until it starts flagging. There are three broad areas relevant to database performance:
  • System resources (essentially, the hardware)
  • Data structures and the way they are allocated to system resources
  • Data operations requested by the applications and they way they are allocated to system resources
DB2 uses a default configuration, aimed to allow a simple, reliable, scalable database to be built with minimal effort on minimal hardware. Achieving the best performance means taking more responsibility for certain background information—information DB2 uses in allocating resources to its work.This article presents an overview of key factors in how DB2 uses disk and memory to place and retrieve data. The information is pertinent to DB2 v5 or later.

An underperforming database can be tricky to troubleshoot, particularly for inexperienced DBAs. You want to optimize the performance of your DB2 database, but aren't sure how to begin.

Learn how and where your data is stored and how to manage it for better performance.



Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap