Ask the Experts: Trigger basics in DB2 and OS/390

[Search390.com]

Title: Ask The Experts

September 30, 2004 Published by  Search390.com Ask The Experts NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > Featured Offer: IBM Software Development Platform Webcasts IN THIS ISSUE:   >  Trigger basics in DB2 and OS/390   >  Parallel processing against a DB2 table   >  Who is using a DB2 table?   >  Creating a DB2 trigger   >  Crash Course: Securing your mainframe Trigger basics in DB2 and OS/390 [Search390.com] A Search390.com user asked: I recently read your article and I have a question. TableA is a high transaction table. TableB is essentially a copy of TableA with indexes for reporting. I want to create an insert/update trigger on TableA to replicate the change to TableB. Will TableA be locked up until the commit on TableB completes? Or, will DB2 spawn another process to handle TableB? To see the answer, click here.   Featured Offer: IBM Software Development Platform Webcasts Visit the Expert Answer Center today and find multiple resources -- including a series of webcasts about the IBM Software Development Platform. Learn about the tools & best practices that can help your development team to build, extend, integrate, modernize, and deploy on demand applications. Visit the Resource Center now to view these webcasts & to learn more about the IBM Software Development Platform.   Parallel processing against a DB2 table [Search390.com] A Search390.com user asked: Can we take advantage of parallel processing even if the DB2 table is not partitioned? To see the answer, click here. Who is using a DB2 table? [Search390.com] A Search390.com user asked: In DB2, is there anyway we can figure out how many people are using the same table? To see the answer, click here. Creating a DB2 trigger [Search390.com] A Search390.com user asked: I have been tasked with creating a DB2 trigger to execute a stored procedure whenever a row is updated, added or deleted from several DB2 tables. Do you know where I could find examples of this? To see the answer, click here. FEATURED TOPIC:  Crash Course: Securing your mainframe Need to improve security at your shop? Check the links below to learn more about mainframe security. There is information about everything from securing CICS to disaster recovery. SURVEY:  What's your take on the data center's future? The editors of Search390.com are interested in your informational needs regarding data center management, technologies and strategies. This short survey (only about five minutes to complete) will help us make our offerings more targeted to your needs. Thank you for your cooperation. SYSTEMS MANAGEMENT TIP:  DB2 V8 = better security Security was a major consideration when IBM developed DB2 V8. Recently Edward Hurley, Search390.com's editor, spoke with Curt Cotner, the chief architect of DB2 for zSeries, about the security enhancements in the new version including its tighter integration with RACF. Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by Search390.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Ask The Experts": Go to unsubscribe: http://search390.techtarget.com/u?track=NL-16 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search390 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494