SEARCHDATABASE.COM | Database Administrator Tips November 13, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Lumigent Entegra for Data Access Accountability http://searchDatabase.com/r/0,,7452,00.htm?lumigent =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Finding the connection port in DB2 - SQL Server: Use the Microsoft English Query tool - Oracle: Space check before data LOAD - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: OracleWorld 2002 ___________________________________________________________________ ************** Sponsored by Lumigent Technologies **************** Announcing Lumigent(R) Entegra(TM) - meet your data privacy and security requirements with a complete audit of database activity. Know "who's doing what to which data when". Entegra provides an audit trail of changes to data and to database structure and permissions, including data views (i.e. who viewed data). Entegra monitors and alerts on database activity for a complete record of data access, and data and database changes. FREE whitepaper - "Data Access Accountability": http://searchDatabase.com/r/0,,7452,00.htm?lumigent ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: FINDING THE CONNECTION PORT IN DB2 | Ranjit Kumar This short tip tells you how to find the client connection port for multiple DB2 instances. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857650,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPACE CHECK BEFORE DATA LOAD | Sudhakar Parsi Here's a script to check table space before loading millions of records, which is especially useful in data warehousing situations. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821247,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USE THE MICROSOFT ENGLISH QUERY TOOL | Barrie Sosinsky If you are a developer, no doubt you have learned to think in SQL, and perhaps to employ a tool to help you compose the more complex SQL statements that arise. Your clients, however, don't think in SQL. For this Microsoft has introduced their Microsoft English Query tool. Here's a quick introduction. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci859891,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: OPTIMIZING DATABASE PERFORMANCE, PART 3: COMPRESSION & PAGE SIZE http://www.searchDatabase.com/tip/1,289483,sid13_gci861319,00.html Craig Mullins concludes his series about the techniques for optimizing the performance of any database. In part 3, he discusses techniques such as fill factor management, compression, file placement, page/block size, and more. EXTRACTING COMPLETE DDL FROM DB2 6 DATABASES | Sudhakar Parsi http://www.searchDatabase.com/tip/1,289483,sid13_gci857622,00.html You may often need to get DDL statements for various DB2 database objects in order to recreate them on another server. For example, while setting up test systems, DBAs usually try to create a copy of the production database on test servers. Here's how to do it on DB2 v6. UPGRADING FROM SQL SERVER 7.0 TO 2000 | Rhys Kerrigan http://www.searchDatabase.com/tip/1,289483,sid13_gci861379,00.html Here's how to address the following error while upgrading to SQL Server 2000: "The Ordinal 105 could not be located in the dll Opens60.dll" HOT BACKUP AND RECOVERY WITH PERL | Frank Pantaleo http://www.searchDatabase.com/tip/1,289483,sid13_gci857677,00.html This extensive script is useful for DBAs who want to use Perl for doing hot backups. 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: Why WHERE cannot be used after GROUP BY http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501484_tax285649,00.html Database design: Design for sales database http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501498_tax285649,00.html SQL Server: Passing an array to a stored procedure http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501463_tax285648,00.html Data warehousing: Merging customer lists http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501502_tax288372,00.html Oracle: Pinning and caching http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501071_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLEWORLD 2002 | SearchDatabase.com Featured Topic Travel budget cut? San Francisco too far away? Just plain forgot? If you aren't going to OracleWorld this week, we have the latest news, exclusive analysis, expert advice, and product announcements from the show inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci862113,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."