SEARCHDATABASE.COM | Database Administrator Tips January 8, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free database whitepapers http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Reorg and runstats in a ksh script - SQL Server: SQL Server backup and restore, part 1: The basics - Oracle: Truncate tables using PL/SQL - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Craig Mullins: DB2 guru ___________________________________________________________________ ****************** Free database whitepapers ********************** 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: REORG AND RUNSTATS IN A KSH SCRIPT | Venkat Arikatla You can reorg and runstats for DB2 with this single ksh script. Install it as a crontab to run every day during off-peak hours. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci869564,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER BACKUP AND RESTORE, PART 1 | Greg Robidoux One of the most important aspects for a SQL Server environment is ensuring that reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. The first part of this two-part article analyzes the various options available for your backup and recovery process with SQL Server 2000. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci872342,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TRUNCATE TABLES USING PL/SQL | Kevin Shidler This script truncates data from tables using PL/SQL for Oracle8i. It first disables all foreign key constraints that would cause the "ORA-02266" error, truncates the tables, and then re-enables all the foreign keys. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci842566,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FAST ACCESS TO DB2 ON THE ISERIES WITH PHP | Alex Corretge i Bergua http://www.searchDatabase.com/tip/1,289483,sid13_gci868255,00.html The author had a dream: Access DB2 on the iSeries with an Web-based application written in PHP. He used the simple steps in this tip to make that dream a reality. WORD WRAPPING WITH T-SQL | Andrew Novick http://www.searchDatabase.com/tip/1,289483,sid13_gci869491,00.html There are times when there isn't a suitable front-end that can perform a word wrapping task and so it has to be done by SQL Server itself. Here is a UDF, called udf_TxtN_Wrap, that wraps a nvarchar string at a given line length. REFRESH VALUE OF A GLOBAL VARIABLE ONLY AFTER COMMIT | Murali Krishna http://www.searchDatabase.com/tip/1,289483,sid13_gci854788,00.html Through any front-end applications it's easy to control the value of any variable via re-initialization at any point. But what happens if you want to reinitialize the value at the SQL prompt or at the database level? Here's how to do it in Oracle. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts DB2: RECOVER versus LOAD utilities http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508544_tax285651,00.html Oracle: Steps to copy an 8i database to another PC http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508949_tax289342,00.html SQL Server: Executing Oracle stored porcedures in SQL Server http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid509320_tax285648,00.html Database design: Avoiding overhead of insert/delete with indexes http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508676_tax285653,00.html Oracle: VARCHAR2 versus VARCHAR http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508992_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CRAIG MULLINS: DB2 GURU | SearchDatabase.com Featured Topic We continue our series highlighting the contributions of SearchDatabase.com's expert panel with DB2 author Craig Mullins. Craig has answered hundreds of your UDB and mainframe DB2 questions. Browse them inside or ask your own... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci871870,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."