SEARCHDATABASE.COM | Database Administrator Tips August 14, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Get a Free Database Health Check http://searchDatabase.com/r/0,,4956,00.htm?freehealthcheck =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Get status information for trace flags - DB2: DB2 system parameters (ZPARMs) - Oracle: Guaranteeing a single row SELECT - Oracle: Oracle DBA certification - Oracle: Don Burleson answers your Oracle availability questions - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free Webcast: Database Aministration 101 - Featured Topic: Ask the database experts - Send us your SQL Server tips, win a prize! ___________________________________________________________________ ****************** Sponsored by Quest Software ******************** Are your end-users feverish about database response time? Increase performance and availability with a FREE health check from the database-tuning gurus at Quest Software! With Quest's renowned real-time and historical diagnostics - plus Quest's industry-leading resolution tools - Quest's FREE health check is good for what ails your database. Click here to register today! http://searchDatabase.com/r/0,,4956,00.htm?freehealthcheck ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: GET STATUS INFORMATION FOR TRACE FLAGS | Taruna Paaladugu The command DBCC TRACESTATUS can be used to get the status information for a particular trace flag currently turned on. Here's how to use it. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837819,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 SYSTEM PARAMETERS (ZPARMS) | Alan Smith You can easily get a listing of your DB2 subsystems' DSNZPARM and DSNHDECP modules by using the IBM-supplied stored procedure DSNWZP. Here's the command to use. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci838021,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GUARANTEEING A SINGLE ROW SELECT | Kanan Mamedli Here is how to guarantee that an Oracle SELECT statement is a single row SELECT. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835734,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE DBA CERTIFICATION | Ed Haskins The Oracle certification program continues to be the most popular among all database vendors. Here's an introduction to the 9i DBA track by Ed Haskins, President of OraKnowledge, Inc. >> CLICK for part I: Introduction http://www.searchDatabase.com/originalContent/0,289142,sid13_gci843944,00.html >> CLICK for part II: FAQ http://www.searchDatabase.com/originalContent/0,289142,sid13_gci843932,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DON BURLESON ANSWERS YOUR ORACLE AVAILABILITY QUESTIONS | Don Burleson On July 23, 2002, Don Burleson of BEI Oracle Consulting gave an excellent Webcast on SearchDatabase titled Using Oracle9i RAC and TAF for continuous availability. Here are answers to audience questions that Don didn't have time to address. >> CLICK for the full article... http://www.searchDatabase.com/originalContent/0,289142,sid13_gci841007,00.html >> CLICK to listen to Don's Webcast... http://searchdatabase.techtarget.com/webcastsTranscriptSecurity/1,289693,sid13_gci833977,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= INDEX MAINTENANCE | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci841586,00.html An excellent introduction to maintaining indexes in SQL Server: why it's important and the three methods to do it. Baya then provides a stored procedure to automate your index maintenance. HOW TO MANIPULATE DATES IN UDB | Annette DeMicco http://www.searchDatabase.com/tip/1,289483,sid13_gci840250,00.html A collection of simple examples of how to manipulate dates in DB2 UDB; the same applies to timestamps and time. FINDING AND DELETING DUPLICATE ROWS FROM A TABLE | Harish Kapgate http://www.searchDatabase.com/tip/1,289483,sid13_gci831496,00.html This quick Oracle tip will show you how to find duplicate rows in a table and then delete them. GET CURRENT SQL FROM ORACLE SGA | Syed Ali http://www.searchDatabase.com/tip/1,289483,sid13_gci842564,00.html This short statement can be used to retrieve the current SQL of a special SID (user) from SGA. ORACLE 9I MERGE STATEMENT EXPLAINED | Srinivas Chittimalla http://www.searchDatabase.com/tip/1,289483,sid13_gci842567,00.html MERGE is a new feature available in Oracle 9i and is mainly useful in data warehousing applications where data is either inserted or updated at regular intervals. Here is how to use it. 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 SonicBlue MP3 Player: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz843445_cts843442,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: FREE WEBCAST | Database Aministration 101 Who : Craig Mullins When: Aug 16, 2002 at 1:00 PM EDT (17:00 GMT) One of the world's top database experts examines each of the components that comprise the discipline of database administration. Whether you're a newbie or guru-level database administrator, analyst, architect or application engineer, this Webcast will provide the critical strategies and solutions you need to deliver quality administration across today's challenging multi-DBMS environments. >> Pre-register now http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html >> Order Craig Mullins' new book, "Database Administration" http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=0201741296&partner_id=77 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE DATABASE EXPERTS | SearchDatabase Featured Topic Our panel of industry leaders and super geeks has answered over 1,200 of your tough Oracle, SQL Server, DB2, data warehousing, relational model and SQL questions. Browse this useful knowledgebase or submit your own question! >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci843571,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER TIPS NEEDED | SearchDatabase Tip of the Month Contest Attention SQL Server DBAs and developers! Share your knowledge, help your peers -- submit a time-saving SQL Server tech tip or script. The highest-rated tip in August will win a SONICblue Rio 600 MP3 Player, worth $115! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz843445_cts843442,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. 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 2002, 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."
