SEARCHDATABASE.COM | Database Administrator Tips November 27, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
The 2002 Year-End SearchDatabase.com Survey http://www.insightexpress.com/s/kle50020.asp =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Identify redundant indexes - SQL Server: Use a query to document your database - Oracle: Accessing non-Oracle databases with JDBC - Oracle: Keeping Optimizer statistics up to date - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Stored procedure development ___________________________________________________________________ *********** Take the SearchDatabase.com Year End Survey *********** Please take a moment to complete our year-end survey. Our goal is to learn which database-related projects you plan to tackle in the 2003, so we can provide information to help you do your job easily and efficiently. We are accepting a limited number of responses, so please complete the form today: http://www.insightexpress.com/s/kle50020.asp ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: IDENTIFY REDUNDANT INDEXES | Sreedhar Bobbadi Indexes are created to enhance performance, but often they are created with the same attributes, resulting in redundant indexes. Over a period of time the number of such indexes can grow, increasing the size of the DB2 catalog. The following SQL can help you to indentify all such indexes. It has been tested on DB2 UDB OS/390 version 7.0. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci859891,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USE A QUERY TO DOCUMENT YOUR DATABASE | Parthasarathy Mandayam Did you know that you can use a query to document your SQL Server database? This simple query on the system tables will do just that. You can easily cut and paste the results into a Word document and improve the look and feel. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci839384,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ACCESSING NON-ORACLE DATABASES WITH JDBC | Vishal Shah The author needed to access data in a Progress database from within an Oracle stored procedure. To do so, he utilized Oracle's Java Stored Procedure functionality to make this possible. Here are the steps that can work with any DBMS. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci865321,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= KEEPING OPTIMIZER STATISTICS UP TO DATE | David Gibbs This Oracle script can be scheduled to run regularly to monitor table usage and keep statistics on schema objects current. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci865222,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: CONVERT BLOB TO CLOB | Prashant Dahalkar http://www.searchDatabase.com/tip/1,289483,sid13_gci860034,00.html Here is a small Java program for DB2 7.1 that converts the datatype of a column from BLOB to CLOB. DANGEROUS ANSI OPTIONS | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci864562,00.html ANSI options make SQL Server compatible with the SQL 92 ANSI standard -- these options force Transact-SQL to behave much like ANSI SQL. Here are a few tips about ANSI options and how to avoid common pitfalls. SCRIPT TO DETERMINE OS PID FOR TIMED-OUT SESSIONS | Murali Sankar http://www.searchDatabase.com/tip/1,289483,sid13_gci857430,00.html Do you have trouble finding timed-out sessions and killing them? This Oracle 8 script will help you find out the Unix process ID (PID) for the timed-out sessions. You can use this PID to kill the session from the operating system. 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 MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL: Conditionally summing fields http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid504189_tax285649,00.html Oracle: Using the EXP command while database is running http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid504145_tax285650,00.html DB2: Seeing access path info without rebinding the package http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid503815_tax285651,00.html SQL Server: Sending a message to currently connected user http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501425_tax285648,00.html Oracle: Rule of thumb for bitmap indexes http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid504122_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= STORED PROCEDURE DEVELOPMENT | SearchDatabase.com Featured Topic Stored procedures increase the performance, flexibility, and security of your DBMS. Here is a selection of our best tips and expert advice about coding effective Oracle, SQL Server, and DB2 stored procedures and triggers. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci809177,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************************ 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."
