SEARCHDATABASE.COM | Database Administrator Tips February 12, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free database white papers http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Export all the tables in a given schema - SQL Server: Implementing full text search with T-SQL - Oracle: Retrieving the OS/network username for audit trail - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Impossible data warehouse situations - Ask the experts: Your database questions answered - Featured Topic: Normalization ___________________________________________________________________ ***************** Free database white papers ********************** Download the key papers you need today to make better-informed decisions. Targeted categories include: Data analysis and Business Intelligence; Data Security, Data Storage, Database Web Integration, and more. Click here to access the free SearchDatabase.com white papers section: http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: EXPORT ALL THE TABLES IN A GIVEN SCHEMA | Venkat Arikatla This ksh script for DB2 UDB 7.2 will log into the database, find all the tables in the given schema, and dynamically create the export script and run it. The DATADIR will contain the latest .ixf and .txt files. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci875402,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FULL TEXT SEARCH WITH T-SQL STORED PROCEDURES | Eli Leiba Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager. Nonetheless, it can be useful in certain situations. Here are the steps to implement FTS in T-SQL. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci880154,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RETRIEVING OS/NETWORK USERNAMES FOR AUDIT TRAIL | K. Chennakeshav An audit trail is often required to know who created a record and who updated it. A "SELECT NVL(user, SYS.login_user) FROM DUAL" query shows the database login account. The function below is helpful when the database login is not the same as the network/OS login, which may occur in applications that make JDBC/ODBC calls to the Oracle database. This function returns the network/OS login account username. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci874723,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FIND OUT WHAT DYNAMIC SQL IS RUNNING | David Quigley http://www.searchDatabase.com/tip/1,289483,sid13_gci870147,00.html Have you wondered what SQL is being executed against your database as well as its frequency? Here's a quick command that will retrieve that info for you. AUTOMATE DOCUMENTATION TASKS | Garet Griffin http://www.searchDatabase.com/tip/1,289483,sid13_gci878331,00.html Documentation is sorely lacking in many commercial development projects today. By automating some of the documentation tasks for your databases, you are doing yourself a big favor. Here are several simple documentation routines that can be stored in SQL Server's MODEL database and therefore propagated to all new databases. DETERMINING THE HIT RATIO OF ORACLE DATABASES | Peter Choi http://www.searchDatabase.com/tip/1,289483,sid13_gci878332,00.html The hit ratio determines if Oracle is performing more physical reads to retrieve the data. A general rule of thumb for OLTP systems is that if the hit ratio falls below 70%-80%, the DBA should investigate the cause. Here's a quick script that will calculate the hit ratio. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IMPOSSIBLE DATA WAREHOUSE SITUATIONS | SearchDatabase.com Webcast TITLE: Impossible data warehouse situations SPEAKERS: Chuck Kelley and Sid Adelman Get advice from experts who know how to plan and implement data warehouses. You'll hear about the solutions to common crises that companies face when building complex data warehouses. Listen as these experts discuss their personal experiences about the reality of data warehousing not covered in basic texts. Log on to this expert webcast now: http://searchdatabase.com/r/0,,10092,00.htm =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts Oracle: X$KGLOB not visible http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid516202_tax289341,00.html Oracle: Updating FoxPro fields with Oracle data http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid516194_tax289342,00.html Oracle: Importing a SQL Server table into Oracle http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid514018_tax285650,00.html DB2: Consolidating multiple DBMSs onto a mainframe DB2 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid515726_tax285651,00.html DB2: Is EXISTS syntax valid? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid515727_tax285651,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NORMALIZATION | SearchDatabase.com Featured Topic Optimal normalization is the key to good database design. And good design is the key to optimal database performance, efficiency, and integrity. The tips and expert advice inside will help you master this important skill. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci879196,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,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 ::::::::::::::::::::: 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."
