Ask the Experts: Troubleshooting CICS-DB2 environments

[Search390.com]

Title: Ask The Experts

June 17, 2004 Published by  Search390.com Ask The Experts NEWS     TOPICS     ASK THE EXPERTS     TIPS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > KnowledgeStorm IN THIS ISSUE:   > Troubleshooting CICS-DB2 environments   > Why deadlocks occur and what to do about them   > CICS-DB2 continuously updates   > Keeping up with the latest and greatest DB2 updates   > Data Center Decisions Redux Troubleshooting CICS-DB2 environments [Craig Mullins] A user asked: I'm working 24/7 support in CICS-DB2 environment and we're facing lot of timeout issues during DB2 updates. Could you please suggest a way to minimize these timeouts?   KnowledgeStorm One of the best research tools for new product purchasing is right at your fingertips. Visit the Search390.com Product and Vendor Guide, powered by KnowledgeStorm, to compare specific hardware and software solutions. Don't jump from one vendor site to the next -- do all your comparisons all in one place. You can also receive quotes directly Click Here   Why deadlocks occur and what to do about them [Craig Mullins] A user asked: We already tried to update the rows of the same table in order, but why are we still getting deadlocked to the same program? We use DB2 V6 for OS/390 and CICS TS V1.3 on OS/390 V2.9. The transaction came from RS6K CICS and routed to CICS/390 using DPL. CICS-DB2 continuously updates [Robert Harris] A user asked: One of our CICS-DB2 programs continuously updates a DB2 table. In order to release the update locks frequently, we intend to take syncpoints every 15 seconds of elapsed time. In order to determine if 15 seconds elapsed, we plan to get current time using ASKTIME after every update. What kind of overhead will we incur with ASKTIME calls or is there a better way? Keeping up with the latest and greatest DB2 updates [Craig Mullins] A user asked: When is the date DB2 V7.1 will go off support? TOPICS: Data Center Decisions Redux Earlier this month, data center experts descended on Chicago for Data Center Decisions. This week's Featured Topic features a wide variety of stories from the event. TIPS: The CICS scripter five A while back, site expert Jim Keohane posted a Search390.com tip on having fun with tortoise-speed CICS/REXX. He then researched some potential CICS roll-your-own scripting environments like LUA. Jim also spoke highly of Java, but realized the CICS JVM is either a heavy CPU performance hit, or a pricey $125,000 move. See what he's learned about other potential alternatives to enable process scripting/automation within CICS. Got a CICS tip of your own? We'll post it on our Web site, where all your friends and contemporaries can see it. Click here to post. 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] Free E-Newsletters! Select e-newsletters you would like to receive via e-mail! Search390: Today's News Not a Member? We'll activate your membership with your subscription. 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 MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494