=============================================================== SEARCH400.com | Administrator Tip Jan. 22, 2003 =============================================================== FROM OUR SPONSORS:
FREE white paper: Voice Response in an AS/400 world http://search400.com/r/0,,9273,00.htm?imessaging SpooliT - Automate your spool file distribution and archival now! http://search400.com/r/0,,9287,00.htm?asymex News Flash: AS/400 Personnel rescues IT manager from drowning... http://www.as400search.com/ =============================================================== Essential explanations, tools, and code for the iSeries administrator. More tips: http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f8,00.html =============================================================== In today's technical advice roundup you'll find tips, expert answers and input from your peers on the following iSeries administrator questions and concerns: Today's Featured Administrator Tip: -- Use the CHGQRYA command to help lessen interactive workloads Answers to Other Technical Questions - Improving OPNQRYF performance - Limiting maximum Qtemp storage on query joins - Tuning your iSeries - Get a report of large files and total records in a library Important Announcements and Links - Free TCP/IP Tips: Excerpt from The MC Press Desktop Encyclopedia - Tip Exchange: Win a hand-held color TV - Advice: Managing the iSeries Discussion Forum - Monthly Newsletter: Top Expert Advice _______________________________________________________________ ****************** SPONSORED BY iMessaging ******************* LEARN how AS/400 organizations are using Interactive Voice Response to improve communication of AS/400 stored data to any telephone caller, at any time of day. This new white paper "Voice Response in an AS/400 World: Charting Applications and ROI" will provide you with insights into the telephony concepts and the voice applications providing ROI results in many AS/400 shops. DOWNLOAD FREE WHITE PAPER: http://search400.com/r/0,,9273,00.htm?imessaging =============================================================== Today's Featured Tip =============================================================== Use the CHGQRYA command to help lessen interactive workloads If your shop allows users to create and run their own queries or if your systems include many predefined queries that users run often, you may want to consider using the Change Query Attributes (CHGQRYA) command to help lessen interactive workloads. With this command you can establish processing attributes for all subsequent queries executed in a job. It covers all database queries regardless of their origin (i.e., Query/400, SQL, Query Management, etc.). >> CLICK here to view the complete tip: http://www.search400.com/tip/1,289483,sid3_gci875081,00.html =============================================================== Answers to Other Administrator Questions =============================================================== Improving OPNQRYF performance Search400.com member David Moore shows you how to improve performance by entering STRDBG and running a CL that contains the OPNQRYF that needs to be improved. http://search400.techtarget.com/tip/1,289483,sid3_gci751317,00.html Limiting maximum Qtemp storage on query joins If you have ever experienced the problem of a runaway Query or SQL, you may know of the potential danger that exists with your DASD reserve going critical. Often ill constructed joins will run for an excessive amount of time, building work files in the jobs Qtemp library. This technique provides a way to set a ceiling limit of the amount of temporary storage a job can use. http://search400.techtarget.com/tip/1,289483,sid3_gci782944,00.html Tuning your iSeries Is there a simple way to tune up the iSeries? Site expert Tim Granatir points out a few methods. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid449944_tax285222,00.html Get a report of large files and total records in a library Search400.com member David Anderson provides code that helps manage files that need purging or test libraries that programmers may forget to clean up. http://search400.techtarget.com/tip/1,289483,sid3_gci873425,00.html _________________________________________________________________ ********************** SPONSORED BY Asymex ********************** SpooliT from Asymex delivers you intelligence in document management � E-mail your spool files and reports to anyone - Automatically � Drag and drop your spool files to Excel, Word, HTML and PDF - Automatically � Archive your reports to your pc or network, or even burn to CD - Automatically Go paperless and save money - Click the link for your free 30-day trial of SpooliT http://search400.com/r/0,,9287,00.htm?asymex _______________________________________________________________ _______________________________________________________________ ::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS ::::::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE TIPS ON TCP/IP| The MC Press Desktop Encyclopedia of Tips, Techniques and Programming Practices for iSeries and AS/400 Download this free sample chapter from The MC Press Desktop Encyclopedia of Tips, Techniques and Programming Practices for iSeries and AS/400 published by MC Press and get more than 15 tips on using TCP/IP. This chapter offers the combined knowledge of the book's editors and users so you can get a better understanding of how to use your iSeries system and its TCP/IP services. Get information on such topics as batch FTP, FTP and *SAVF, and TCP/IP maintenance. >> DOWNLOAD this free sample chapter today: http://search400.techtarget.com/whitepaperPage/0,293857,sid3_gci874523,00.html >> BUY the book: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=1583470263&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- WIN A HAND-HELD COLOR TV | Submit your tip to win Tired of never getting to watch what you want on TV? Don't fight with your family for the remote any longer. This month we're giving away a hand-held color TV that has a 2.5-in. TFT-enhanced, active- matrix LCD screen. Enjoy the brilliant clarity of a TFT-LCD screen on the world's smallest TV. Send in your tip -- you could be our next winner. >> SUBMIT a Tip: http://www.search400.com/tipsPrize/0,289492,sid3_prz869288_cts869283,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- MANAGING THE ISERIES DISCUSSION FORUM | Interact with your peers Check out Search400.com's Managing the iSeries discussion forum. If you have a performance problem you just can't figure out, or you need help recovering data after a system crash, we recommend you check out this forum. Other system managers can help you with these and other management issues. >> RECENT discussion threads you may find of interest: * What determines your controlling system? http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84639/1060 * How can I determine how much space remains on a cartridge tape after a save? http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84639/1057 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MONTHLY NEWSLETTER | Top Expert Advice newsletter The Top Expert Advice newsletter was designed to help iSeries professionals manage tasks they deal with regularly. Each month we will give you expert advice on such topics as security, backup and recovery, Web development and application development. To receive this newsletter, simply edit your member profile at http://search400.techtarget.com/editSummary/1,291026,sid3,00.html and check Top Expert Advice newsletter under the Tips section. _________________________________________________________________ ***************** SPONSORED BY AS/400 Personnel ***************** News Flash: AS/400 Personnel rescues IT manager from drowning. ... "I thought that it would be easy to find the right IT professional in the 'Sea of resumes'. I got in way over my head and had given up hope," says one IT manager, "and then I called AS/400 Personnel. They saved me from certain doom!" A spokesman from AS/400 Personnel told this reporter that they save IT managers on a daily basis. "We have the resources and technical skills necessary to swim through the 'Sea of resumes' and find just the right professional for the job. This is what we do for a living," said the spokesman. "It's a treacherous sea, and IT managers shouldn't go it alone." "I am glad I called them," declared the IT manager, looking very relieved. "You will be too!" Call them for permanent professionals or contract consultants, or visit their Web site at http://www.as400search.com/. ________________________________________________________________ :::::::::::::::::::::: SEARCH400.COM CONTACTS :::::::::::::::::: TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. ________________________________________________________________ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. ________________________________________________________________ DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. ________________________________________________________________ DAVID GABEL, executive tech editor (mailto:[EMAIL PROTECTED]) >> Send me your technical tips and tip ideas. ________________________________________________________________ GABRIELLE DERUSSY (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. Unsubscribe from 'Administrator Tips' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search400.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
