DBA Tips: DB2 logging strategies, and more...

[SearchDatabase.com]

Title: DBA Tips

October 27, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     IN THIS ISSUE:   >  DB2 logging strategies   >  Getting an environment variable value using T-SQL   >  Make your iSeries database easy to read   >  SQL Server: Identifying external or internal table fragmentation   >  Oracle: Queries to retrieve table metadata 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 logging strategies [Roger Sanders] Two very different logging strategies, known as circular logging and archival logging, are available in DB2. But according to this short article, a hybrid method called infinite active logging might work best. MORE INFO: > Hundreds more DB2 tips and scripts Getting an environment variable value using T-SQL [Eli Leiba] This article describes how to get an operating system environment variable value in a T-SQL script programmatically. Make your iSeries database easy to read [Search400.com] This article takes a quick look at making your iSeries database easier for users to read. By creating simple data marts and using SQL views, you can make your production data understandable for user reporting. SQL Server: Identifying external or internal table fragmentation [Eli Leiba] This article describes how to identify tables that are fragmented internally (ie, fragmentation inside data pages) or externally (ie, extents are fragmented). Oracle: Queries to retrieve table metadata [Glenn Wiens] This utility provides a quick view of tables, including their relationships (parent and children tables/columns), indexes and grants. ASK THE EXPERTS:  MySQL: Performance of MERGE tables What is the optimal size of MERGE tables, and how will it affect performance of selects and inserts? FEATURED TOPIC:  Ask the SQL expert Our expert Rudy Limeback has been in the database field for 25 years and he knows his SQL. Browse his 350+ answers to your tough SQL questions. 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