SEARCHDATABASE.COM | Database Administrator Tips October 2, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Qualify for FREE attendance to Networking Decisions Conference http://searchNetworking.com/r/0,,4344,00.htm?NetworkingDecisions =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: AutoNumber and Identity functionality in Oracle - Oracle: Compressing Oracle exports on the fly - SQL Server: SQL Server string parser - DB2: Watch your DB2 connections - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast today: Oracle and XML - Ask the Experts: Your tough database questions answered - Featured Topic: XML: Hit or hype? - True DBA Bloopers: Submit your horrifying tale to win! ___________________________________________________________________ *************** Sponsored by Networking Decisions ***************** Top speakers to present key networking, VoIP and wireless solutions at the FREE Networking Decisions conference that arrives in Chicago October 16-18. Speakers include: ** Cisco Systems' Chief Development Officer, Mario Mazzola ** Yankee Group VP, Zeus Kerravala ** Nortel Networks' CIO Richard Ricks ** Giga Information Group Senior Industry Analyst, Jim Slaby Qualify for FREE attendance at: http://searchNetworking.com/r/0,,4344,00.htm?NetworkingDecisions ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: AUTONUMBER AND IDENTITY FUNCTIONALITY IN ORACLE | Murali Krishna Developers accustomed to AutoNumber columns in MS Access or Identity columns in SQL Server often complain when they have to manually populate primary key columns using sequences in Oracle. This type of functionality is easily implemented in Oracle using triggers. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci850770,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= COMPRESSING ORACLE EXPORTS ON THE FLY | Chuck Hamilton Here is how to create compressed Oracle export files on the fly even though the export utility does not support writing to the Unix standard output stream. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci852577,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER STRING PARSER | Alena Willis This stored procedure takes a delimited string, parses it and puts it into a table. It can be used to filter sets of data with lists (strings) from any kind of application. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci851250,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WATCH YOUR DB2 CONNECTIONS | Stephen Swoyer Watch out for this problem connecting Websphere Application Server to DB2... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci838025,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: DB2 STORED PROCEDURES PROVIDE WAY TO REUSE RPG APPS ON THE WEB http://www.searchDatabase.com/tip/1,289483,sid13_gci838015,00.html By Jim Mason and Dave Slater. Stored procedures offer a safe, portable and reliable way to build application-to-application interfaces in many environments, including e-business WebSphere applications on the iSeries. Here's a good introduction to the topic, plus tips on how to use DB2's Stored Procedure Builder. SEVEN STEPS TO A JAVA WEB DATABASE APPLICATION http://www.searchDatabase.com/tip/1,289483,sid13_gci838016,00.html By Jim Mason and Dave Slater. Java Database Connectivity (JDBC) is one of the most important features of Java on any platform. You can use JDBC objects to define and run standard SQL statements to select and update AS/400 data files and call any RPG batch program easily. Here's how. DETERMINING TRANSACTIONS PER SECOND | Cory Brooks http://www.searchDatabase.com/tip/1,289483,sid13_gci852256,00.html This code can approximate the number of Oracle transactions per second by looking at the number of SCN changes per second. AVOID BLOCKING | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci849846,00.html Blocking is a classic database problem in which a transaction locks a first record and then a second record. Here's a quick intro to the topic and a way to avoid blocking in SQL Server. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE AND XML | SearchDatabase.com webcast Who: Bradley D. Brown, Author and co-founder of TUSC When: TODAY, Wednesday, Oct. 2, 2002 at 01:00 PM EDT (17:00 GMT) Get ready to understand the power of XML in Oracle by using XSU, XSQL and XSLT. Learn how easy it is to extract and manipulate data into output formulas, receive XML files from other servers and much more. >> CLICK for more details... http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL: IN subquery or EXISTS subquery http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid493679_tax289340,00.html Oracle: Tool to migrate DB2 stored procedures to Oracle 8i http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid493718_tax289341,00.html Database design: More on exclusive OR subtypes http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid493479_tax285653,00.html SQL Server: Nodes in clusters http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid493458_tax285648,00.html Oracle: Getting the SQL trafic byte size for session and transaction http://www.searchDatabase.com/ateQuestionNResponse More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL TIPS AND SCRIPTS | SearchDatabase.com Featured Topic The structured query language is the lingua franca of all the major database management systems. Inside is a collection of SQL tips, tutorials, and expert advice. Newbie and guru alike will find something useful here! >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci802922,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TRUE DBA BLOOPERS | Submit your horrifying tale to win Attention DBAs: SearchDatabase.com wants your bloopers! Submit your backup/recovery snafus, tuning disasters and ugly upgrades. Stories of good intentions gone bad, over-ambitious and under-trained newbies, clueless consultants, and even more clueless managers will all be accepted. The submitter of the most amusing or wince-inducing blooper of the month will receive a free copy of Craig Mullins' new book "Database administration: The complete guide to practices and procedures." Send your bloopers to [EMAIL PROTECTED] today! >> More details about Mullins' "Database Administration"... http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=0201741296&partner_id=77 ___________________________________________________________________ *********************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."
