SEARCHDATABASE.COM | Database Administrator Tips August 21, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Space Management for DB2 - FREE TRIAL http://searchDatabase.com/r/0,,5086,00.htm?BMCSoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Using Java stored procedures: AIM from Oracle - Oracle: Find tablespaces in backup mode - Oracle: Database link without SQL*NET string - SQL Server: Retrieving the row for the Nth largest column - DB2: Extract data from DB2 on MVS from within DB2 UDB on AIX - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free Webcast: Craig Mullins on database administration - Ask the Experts: Your tough database questions answered - Featured Topic: Database administration 101 - Send us your SQL Server tips, win a prize! ___________________________________________________________________ ****************** Sponsored by BMC Software ******************** Effectively improve database performance... and go home a hero. With the intelligent space management capabilities of Space Expert for DB2 UDB from BMC Software, identifying and reorganizing your most active objects is done easily and automatically. Save the day and ensure the availability of your mission-critical data with the most intelligent space management solution available! Click here to download a FREE 30-day trial of Space Expert for DB2 UDB: http://searchDatabase.com/r/0,,5086,00.htm?BMCSoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: USING JAVA STORED PROCEDURES: AOL INSTANT MESSAGING FROM ORACLE By Bradley D. Brown. Have you been wondering how you might use Java stored procedures instead of Oracle's native PL/SQL stored procedures? This article discusses the pros and cons of Java stored procedures, guidelines on how to build them, database vs. app server Java, performance considerations, troubleshooting, and rollout/security aspects. The final section of this paper includes a Java stored procedure example that allows you to send instant messages from the database. Very cool! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845712,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND TABLESPACES IN BACKUP MODE | Kavita Mital Often in Oracle, backups fail if one or more of the tablespaces is already in backup mode. The following script can be used to determine if any of the tablespaces are in backup mode and then you can use the 'alter tablespace end backup' command to bring those tablespaces out of backup mode. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845236,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE LINK WITHOUT SQL*NET STRING | Syed Ali You can create an Oracle database link without having a SQL*NET string in your tnsnames.ora file. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845230,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RETRIEVING THE ROW FOR THE NTH LARGEST PARAMETRIC COLUMN IN A PARAMETRIC TABLE | Eli Leiba This code returns the row corresponding to the Nth largest value for a given column name in a given table. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci832440,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= EXTRACT DATA FROM DB2 ON MVS FROM WITHIN DB2 UDB | Rich Graff Use this script to extract data from DB2 on MVS from within DB2 UDB on AIX. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845207,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GET STATUS INFORMATION FOR TRACE FLAGS | Taruna Paaladugu http://www.searchDatabase.com/tip/1,289483,sid13_gci837819,00.html The SQL Server 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. DB2 SYSTEM PARAMETERS (ZPARMS) | Alan Smith http://www.searchDatabase.com/tip/1,289483,sid13_gci838021,00.html 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. GUARANTEEING A SINGLE ROW SELECT | Kanan Mamedli http://www.searchDatabase.com/tip/1,289483,sid13_gci835734,00.html Here is how to guarantee that an Oracle SELECT is a single row SELECT. 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 here for the introduction: http://www.searchDatabase.com/originalContent/0,289142,sid13_gci843944,00.html DON BURLESON ANSWERS YOUR ORACLE AVAILABILITY QUESTIONS | Don Burleson http://www.searchDatabase.com/originalContent/0,289142,sid13_gci841007,00.html 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. 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 On August 16, Craig Mullins, one of the world's top database experts, presented a Webcast in which he examined 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 provided a great overview of the strategies and solutions you need to deliver quality administration across today's challenging multi-DBMS environments. >> Click here for the archived version: http://searchdatabase.techtarget.com/webcastsTranscriptSecurity/1,289693,sid13_gci839036,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 EXPERT | This week's tough database questions answered SQL Server: Finding the difference between two dates http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid486338_tax285648,00.html Oracle: Finding the tables associated with a view http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid486356_tax289342,00.html DB2: Where is the operational form of a view definition? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid485091_tax285651,00.html Database/relational fundamentals: Does the number of tables in a relational database affect performance? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid485112_tax292527,00.html SQL: Creating record set of time intervals by subtracting timestamp from the previous one http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid484910_tax289340,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE ADMINISTRATION 101 | SearchDatabase Featured Topic What does the modern enterprise DBA do? In today's challenging multi-DBMS environments, the answer is "just about everything." Here is a collection of tutorials and expert advice about the most important job duties of a DBA... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci845011,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."
