DBA Tips: DB2 design principles and more...

[SearchDatabase.com]

Title: DBA Tips

September 01, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     IN THIS ISSUE:   >  DB2 database design and principles of peak performance   >  SQL Server: Data restriction using CHECK constraints   >  The DB2 UDB memory model   >  Why every performance tool stinks   >  Share your DBMS experience with fellow geeks   >  DBMS security SPONSORED BY:  SearchDatabase.com Product and Vendor Guide Simplify the process of finding specific database products and solutions. SearchDatabase.com's Product and Vendor Guide allows you to search listings alphabetically, and by industry or across such topics as database tuning, data warehousing and more. Visit our easy-to-use guide now! DB2 database design and principles of peak performance [Fred Whitlark] Many design decisions made early during the development process can have a significant influence on the performance of your DB2 applications and databases. This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments. MORE INFO: > Hundreds more DB2 tips and scripts SQL Server: Data restriction using CHECK constraints [Barrie Sosinsky] You can use one or more CHECK constraints to limit the data that can be entered into your tables or column. Here's a quick primer on the subject. The DB2 UDB memory model [Sylvia Qi & Michael Dang] Learn how DB2 UDB for Linux, UNIX and Windows uses memory, how that memory use varies by platform, and how it affects your applications. Why every performance tool stinks [Craig Shallahamer] Craig Shallahamer, who makes a living planning and optimizing Oracle-based systems, thinks every DBMS performance tool stinks, including his own. Here's why. ASK THE EXPERT:  Share your DBMS experience with fellow geeks ITKnowledge Exchange is our new feature that allows Oracle, DB2, SQL Server, Sybase and MySQL pros to directly help one another solve pressing technical and strategic issues. Try it out! FEATURED TOPIC:  DBMS security The need for data security may be obvious, but the path getting there certainly isn't. The collection of technical tips, expert advice, webcasts and analysis below will help you lock down your Oracle, DB2, or SQL Server DBMS. Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?track=NL-94 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494