SEARCHDATABASE.COM | Database Administrator Tips April 2, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free Avaya white paper on business continuity http://searchnetworking.techtarget.com/whitepaperPage/0,293857,sid7_gci883603,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Working with triggers - SQL Server: ZIP files with a stored procedure - Oracle: Our experts on Windows problems - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: DBMS ROI and TCO ___________________________________________________________________ ********************* Sponsored by: Avaya ************************* Free Avaya white paper: "How the Seattle Times newspaper ensures business continuity." Understand the benefits from IP Telephony Without Reinventing Your Network. Avaya helped the Seattle Times newspaper migrate to IP for the cost of a PBX upgrade -- and the paper saved $180,000 in the first year. Find out how, sign up for the free Avaya white paper now: http://searchnetworking.techtarget.com/whitepaperPage/0,293857,sid7_gci883603,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: WORKING WITH TRIGGERS | Susan Lawson A trigger in DB2 is a set of actions that will be executed when a defined event occurs. Here is a brief introduction. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci891630,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ZIP FILES WITH A STORED PROCEDURE | Matt Harper A SQL Server stored procedure that zips files from a source and destination directory you pass when calling the procedure. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci884575,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERTS: ORACLE ON WINDOWS Running Oracle on Windows is a common enterprise setup, and predictably, database administrators run into common problems with it. To clear up the confusion, SearchDatabase.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland offer their advice for overcoming some frequent Windows frustrations. >> CLICK for the full tip... http://www.searchDatabase.com/originalContent/0,289142,sid13_gci887118,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: SIMPLE ORACLE OBJECTS | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci888174,00.html Version 8i introduced simple objects in Oracle and so made the Oracle database a true object-oriented environment. This article presents short scripts that demonstrate how to build, use and maintain Oracle simple objects. ASK THE EXPERTS: ORACLE BACKUP AND RECOVERY http://www.searchDatabase.com/originalContent/0,289142,sid13_gci885453,00.html Designing and maintaining a solid backup and recovery process is the most important task a DBA can do. SearchDatabase.com's resident Oracle experts have answered many user-submitted questions over the last year about the best ways to backup and recover mission-crtical data. Here is a compilation of some recent Oracle backup and recovery advice from gurus Brian Peasland and Karen Morton. IS YOUR SQL OPTIMIZED? | David Quigley http://www.searchDatabase.com/tip/1,289483,sid13_gci870113,00.html This is a useful tip to help DBAs figure out if certain DB2 SQL has been optimized. It gives information in text and graphic form that shows how it's accessing tables and indexes. It also shows all the objects used in the plan and information about those objects such as tablesize, number of records, and more. FINDING THE NTH MAXIMAL VALUE | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci880140,00.html This extension to the MAX T-SQL function gets a tablename, column and integer (N) as parameters and finds the Nth largest value of a column in a specific table. DETERMINE USED AND FREE SPACE IN A TABLESPACE | S. Sunitha http://www.searchDatabase.com/tip/1,289483,sid13_gci887383,00.html This small Oracle script can be executed as a script file from the SQL*Plus prompt and reports the total size, used space, free space and percentage of used and free space in all the tablespaces in a database. Very useful for DBAs! Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts DB2: Determining number of rows affected by query through code http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523292_tax285651,00.html Oracle: Transferring data from four tables to another four tables http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523150_tax285650,00.html SQL: Detecting a numeric value in a character column http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid524164_tax285649,00.html DB2: Problem calling SP from trigger: Error code -408 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523119_tax285651,00.html Oracle: Dropping old source files after database move http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523154_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DBMS ROI AND TCO | SearchDatabase.com Featured Topic As the economy goes down, the importance of return on investment and total cost of ownership goes up. Learn more with our DBMS reviews and analyses inside. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci891004,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."