SEARCHDATABASE.COM | Database Administrator Tips October 30, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Performance Tuning White Paper - Quest Software http://searchDatabase.com/r/0,,7047,00.htm?whitepaper =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Optimizing database performance, part 2 - DB2: Converting a DB2 date to SQL Server - Oracle: Finding nulls in any table - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Enterprise integration - Ask the Experts: Your tough database questions answered - Featured Topic: The challenge of integration ___________________________________________________________________ ****************** Sponsored by Quest Software ******************** Do you check metrics such as IO rates, CPU usage, memory usage and network utilization when tuning your database for performance? Metrics collected from SQL*Net, background processes, the SGA and logs can unlock the secrets to better database performance, yet many of us focus on SQL tuning alone. Quest Software provides a free white paper that will help you learn a new tuning methodology. Download your white paper, "A Successful Performance Tuning Methodology," today! http://searchDatabase.com/r/0,,7047,00.htm?whitepaper ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: OPTIMIZING DATABASE PERFORMANCE, PART 2: DENORMALIZATION AND CLUSTERING Craig Mullins continues his series about techniques for optimizing the performance of any database. In part two, he discusses denormalization, clustering, page splitting, and interleaving data. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857336,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CONVERTING A DB2 DATE TO SQL SERVER | Douglas Seward SQL Server 7 crashes when trying to process a view of DB2 tables where some of the date fields are initialized with the value '0001-01-01'. Here's a work around... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857672,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FINDING NULLS IN ANY TABLE | Saritha Rani These SQL scripts quickly show the number of rows with NULLs in each column. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857662,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: OPTIMIZING DATABASE PERFORMANCE, PART 1: PARTITIONING AND INDEXING http://www.searchDatabase.com/tip/1,289483,sid13_gci850679,00.html In this first part of a new series, author Craig Mullins introduces the techniques for optimizing the performance of any database. GETTING INFO ABOUT LOCKED OBJECTS IN ORACLE | Ranjit Kumar http://www.searchDatabase.com/tip/1,289483,sid13_gci854780,00.html This short script takes the object name and gives the session ID and serial number for the session that has a lock. REPLICATING DATA FROM SQL SERVER 2000 TO ORACLE | Sravan Kasarla http://www.searchDatabase.com/tip/1,289483,sid13_gci854771,00.html This tip is useful for understanding the replication options between SQL Server 2000 and Oracle 8i databases. It will help DBAs to enable sharing of data in a heterogeneous environment, which is a common challenge in most IT departments. INSERTING CLOB DATA INTO DB2 | Sujit Mishra http://www.searchDatabase.com/tip/1,289483,sid13_gci854776,00.html These days, the CLOB data type is extensively used in many applications. However, our problem was inserting DB2 CLOB data from a Java application into a OS/390 database because the codepage settings are different for both client and server. This tip helps solve the problem of inserting the data into DB2 on OS/390. 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 DB2: Is a cluster index necessary? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498949_tax285651,00.html Oracle: Problem installing Oracle on Red Hat Linux http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498955_tax289342,00.html SQL: Paging through a result set without TOP or LIMIT http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498398_tax285649,00.html DB2: Illegal keyword in FETCH FIRST n ROW ONLY http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498948_tax285651,00.html Oracle: Determining instances for a data mart http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498952_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ENTERPRISE DATA INTEGRATION | SearchDatabase.com Webcast When: Oct 30, 2002 at 01:00 PM EST (18:00 GMT) Speakers: Stephen Hendrick & Steve McClure, IDC TODAY: Senior IDC analysts will discuss the key determinants of success for vendors and users of data integration products. >> CLICK here to pre-register: http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE CHALLENGE OF INTEGRATION | SearchDatabase.com Featured Topic Studies have shown that most modern corporations have from three to ten different DBMS products. Learn more about this complex and growing problem and how integrated systems can provide business value. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci858799,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:tips@;searchDatabase.com) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:tdichiara@;techtarget.com) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:scushman@;techtarget.com) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:eobrien@;techtarget.com) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:tclick@;techtarget.com) >> 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."
